Tasks 1: Draw an ERD for Auto-Parts Warehouse indicating the types of relationships between the entities. Tasks 2: For each of the entities identified, design tables and identify the possible...

Tasks 1: Draw an ERD for Auto-Parts Warehouse indicating the types of relationships between the entities.
Tasks 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.
Tasks 3: Create fully normalized 3NF table designs for the system.
Tasks 4: Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.
Tasks 5: Presentation (cover sheet, clarity, and professionalism).