Assignment title: Management


Task 1 Draw an ERD for AutoParts Warehouse indicating the types of relationships between the entities. (30%) 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. (25%) Task 3 Create fully normalized 3NF table designs for the system. (25%) Task 4 Suggest ways AutoParts Warehouse can use codes to simplify output, input, and data formats. (20%)