braydensampson
commented
2 years ago - Identify what NF you think each table is in. Employee Table: 3NF Store Table: 3NF Customer Table: 3NF Order Table: 2NF Product Table: 3NF Category Table: 3NF Supplier Table: 3NF
- Are there any attributes that should be in a different table in their design? After analyzing, it does not seem that any attributes are out of place and it seems all attributes fit their respective tables.
- Do they have any partial dependencies? No, there is no composite keys in the ERD.
- Do they have any transitive dependencies? The only transitive dependency I could find was in the Order Table, where Order_Price is dependent on Order_Qty.