Deliverable 3: Relational Model

1.   Schema Diagram

Ken's Library Relational Model

During the conversion of the model, a few decisions were made:

2.  Functional Dependencies and 3NF

All tables have primary keys, and all columns in each table contain atomic values, so the schema is in 1NF.

The functional dependencies are evaluated separately for each table.

3.   Changes from the Previous Deliverable

Besides the changes listed above (from converting the ER Model to the Relational Model), no new changes from the previous deliverable were made.