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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started