You need to draw ERD for Auto-Part Warehouse that including the types of relationshipsbetween the entities.(You need only to draw a diagram) Task 2:For each of the entities identified, design tables and identify the possible candidate keys, theprimary key, a probable foreign key, and potential secondary keys.a) First you need to identify the entities that related to the Auto-Part Warehouse system.b) Create a table to each entity that you identify as shown below:For example; one of the entities that you identify is Parts.Part:Part Number Store Number Part Description Quantity CostThe possible KeysCandidate keysPrimary keyForeign keySecondary 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.Students' answers may include part numbers as an obvious use of codes for a retail store.Invoice numbers would be an example of sequence codes. A full discussion of codes can befound on pages 381 – 384.