facebook messenger
WhatsApp
Hi there šŸ‘‹
Struggling with Assignments?

Our experts can help you!
Get Quote

We are here to help.

Chat with our expert writers on WhatsApp

for any kind of assignment queries.

Click to chat!
Struggling with Assignments? WhatsApp Us
sample banner

245 Downloads

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)

Ā 

Download Full Sample Here
HIRE EXPERT
Email ID *
Subject
Pages
Deadline


Thank You!

We will get back to you as soon as possible.


Your friends could use our help too! Tell them about us also!