You need to draw ERD for Auto-Part Warehouse that including the types of relationships between the entities. You need only to draw a diagram  Task2: For each of the entities identified, design tables...

You need to draw ERD for Auto-Part Warehouse that including the types of relationships between the entities.  You need only to draw a diagram

 Task2: 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.
1- First you need to identify the entities that related to the Auto-Part Warehouse system. 2- Create a table to each entity that you identify as shown below:
For example; one of the entities that you identify is Parts.
The possible Keys
 Task 3: Create fully normalized 3NF table designs for the system.
Create 3NF table designs should include all the entities that you identified in Task 2
 Task 4: Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats.