View the step-by-step solution to:

Your project plan should include the entity relationship diagram (ERD).

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

Top Answer

View the full answer
ABC Car Sales ERD.jpg

ABC Car Sales ERD Diagram
Customer
Vehicle
Car Sales
PK
CustomerID
PK
VIN
PK
SalesID
FirstName
Transact
Price
FK
VIN Number
LastName
Make
FK
CustomerID
PhoneNo
Model
Advertised Price
FK
SalesID...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online