Question: Using the provided set of requirements below, generate a data model. This database will support a variety of applications for a nationwide chain of car

Using the provided set of requirements below, generate a data model.

This database will support a variety of applications for a nationwide chain of car dealerships. Each dealership has a name and address, as well as a variety of staff members. All vehicles in inventory must be tracked in the database as well. For each vehicle, the database should track the year of the vehicle, the make, model, VIN, mileage, current list price, and the dealership where it is located. Each vehicle sale should be tracked as well. For each sale, the vehicle sold, the sale price, method of payment, and the employee who completed the sale should be recorded.

Your written assignment should answer the following questions:

  • Are there any requirements missing that would have been helpful?
  • Are there any reasonable alternative models for this set of requirements?
  • What was the most difficult part of this task and why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!