MySQL + SQL · Lesson 13
RDBMS Concepts with Examples
Core RDBMS Concepts
RDBMS is built on a few core concepts: relation, tuple, attribute, domain, keys and integrity rules.
The Concepts
| Concept | Meaning |
|---|---|
| Relation | A table |
| Tuple | A row |
| Attribute | A column |
| Domain | Allowed values for a column |
| Primary key | Uniquely identifies a row |
| Foreign key | Links to another table |
Integrity Rules
- Entity integrity: primary key cannot be NULL.
- Referential integrity: a foreign key must match an existing primary key (or be NULL).
Summary
- Relation, tuple, attribute, domain, keys form the relational model.
- Entity and referential integrity keep data valid.
💻 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ें.