Task 1
Draw an ERD for AutoParts Warehouse indicating the types of relationships between the entities.
Task 2
For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.
Task 3
Create fully normalized 3NF table designs for the system.
Task 4
Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats.