| SPS Home > Dgreath > RDBMS > Comparision of Relational Database Concepts |
COMPARISON OF RELATIONAL DATABASE CONCEPTS |
|---|
Comparison of Concepts by Model |
||||
|---|---|---|---|---|
| Formal Name |
ER Model |
Relational Model |
Physical Model |
Definition |
| Relation | Entity | Table | File | A collection of one or more tuples |
| Tuple | Instance | Row | Record | A collection of one or more attributes |
| Attribute | Attribute | Column | Field | A datum about a tuple as defined in a relation |
| Datum | Datum | Datum | Datum | A fact contained in an attribute that is both atomic and in compliance with the domain integrity rule. |