Draw ERD for Auto-Part Warehouse that including the types of relationships between the entities. 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. Create fully normalized 3NF table designs for the system. Suggest ways Auto-Parts Warehouse can use codes to simplify output, input, and data formats

PartsMovementTransferTable ( TrackingNumber, InvoiceNumber, Date, PartNumber, OriginPlace, Destination)

AllSalesTable (InvoiceNumber, DateofSale, PartNumber, CustomerNumber)

AllVehiclesMakeModelTable (VehicleModel,Make)

AllPartsTable (PartNumber, Cost, RetailPrice)

ClientsTable (CustomerNumber, FirstName, LastName, PhoneNumber, VehicleModel)