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
Get step-by-step solutions from verified subject matter experts
