Bakery Relational Model

Schema Diagram

Functional Dependencies and 3NF

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

Most of our tables were given surrogate keys, and all other columns in these tables are dependent only on this key. As a result, all of them are in 3NF. These tables include:

CREDIT Table

DELIVERY Table

PICKUP Table

WHOLESALE Table

The columns of all tables are dependent on the primary key and nothing else. All tables are in 3NF.

Changes from the Previous Deliverable