MySQL + SQL · Lesson 12
Relational Database and RDBMS
What is a Relational Database?
A relational database stores data in tables (relations) made of rows and columns, where tables are linked using keys. The software managing it is an RDBMS (e.g. MySQL).
Table = Relation
| Relational Term | Common Term |
|---|---|
| Relation | Table |
| Tuple | Row |
| Attribute | Column |
| Degree | Number of columns |
| Cardinality | Number of rows |
Example
CREATE TABLE students (roll_no INT PRIMARY KEY, name VARCHAR(50), class_id INT);
CREATE TABLE classes (class_id INT PRIMARY KEY, class_name VARCHAR(20));students.class_id links to classes.class_id — a relationship.
Summary
- Relational database = data in linked tables.
- RDBMS software manages it; MySQL is the most popular free one.
💻 Live Code Editor
Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.
💻 Live Code Editor
Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें.
Agar load na ho to naye tab mein kholें.