Relational Databases Cheatsheet
1. Relation vs Table INFORMAL TERMS FORMAL TERMS Table Relation Column Attribute Data type Domain Row Tuple Table definition Relation schema 2. Keys 3. Constrains 4. SQL 4. Database Design – Four Phases 5. Entity-Relationship (ER) Model 5. Functional Dependency Let R be a relation schema. t1[X] = t2[X] ⇓t1[Y] = t2[Y] 6. Implied Functional […]
