Reference no: EM132322980

Need help to design your plan for the scenario provided below. Your project plan should include the entity relationship diagram (ERD).

Scenario

Imagine that you just started a new job at ABC Car Sales. You've been given the task of adding all the new and used car inventory to a new database management system (DBMS). You would like to manage the new and used car sales in the new DBMS.

Listed below are the categories of information that you will need to input in the new database for each type of inventory:

New Vehicle InventoryUsed Vehicle InventoryVIN NumberVIN NumberPricePriceMakeMakeModelModelYearYearExterior ColorExterior ColorInterior ColorInterior ColorTransmission (Manual/Automatic)Transmission (Manual/Automatic)Engine (# of cylinders)Engine (# of cylinders)MileageMileageFully loaded (Yes/No)Fully loaded (Yes/No)Carfax Report (Yes/No)

You will also want to track the following types of information for new and used car sales, including specific customer data.

New Car SalesUsed Car SalesSales ID NumberSales ID NumberVIN NumberVIN NumberCustomer IDCustomer IDAdvertised PriceAdvertised PricePurchase PricePurchase PriceFinanced (Yes/No)Financed (Yes/No)Date soldDate soldCustomerCustomer IDFirst NameLast NameAddressPhone NumberSales ID Number

Instructions

For Part I of the final project, complete the following steps. Your normalized entity relationship diagram can be created by hand, or in PowerPoint. If you decide to hand-write ERD, please scan and submit it as a PDF fie. If you create ERD in PowerPoint, please submit as a PowerPoint file.

1. Identify which entities should be normalized.
2. Create normalized entity relationship diagram. In your diagram,

• show the relationship between the tables
• include notations and symbols as needed

Drawing your ERD