Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions