07 Relational Model
Relations are unordered
Database is a collection of relations
Keys¶
a superkey is a key that is sufficient to uniquely identify a tuple of each possible relation
Schema Diagram¶
shows the different relations
Design¶
The logical schema depicts the structure of the database, showing the tables, columns, and relationships with other tables in the database, and is a direct mapping of the Entity-Relationship diagram. The physical schema is created by actually generating the tables, columns, and relationships in the relational database management software (RDBMS) i.e SQL queries to create the database tables and relationships define