Deliverable 3: Relational Model

1. Schema Diagram

DataBEAST Relational Schema

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 for each table

3. Changes from Previous Deliverable

We decided, for the sake of convenience, to change the names of some of the primary keys. For example, we changed the ID on the Warehouse entity to WarehouseID, and so on for other entities.