e VIN, make, model, year, color, asking price, number of miles, number of collisions, tire age, and number of owners. Attr
A car dealership sells both new and used cars and provides two types of maintenance: repair and service to customers. It wants to track its customers, their cars, and type of maintenance performed on each car. Given that a customer can purchase multiple new and used cars from this dealership and seek both types of maintenance, how will you illustrate this scenario using an ERD and EER combination? Include additional attributes and subtype discriminators as needed. Any many-to-many relationships identified during the construction of the ERD/EER should be split into pairs of 1:M relationships with primary and foreign keys clearly defined. MS Visio should be used to complete this assignment. Upload a pdf version of the file in Canvas.
Attributes of Customer include Customer ID, Name, Address (Street, City, State, Zip), and Phone.
Attributes of New car include VIN, make, model, year, color, MSRP, and asking price.
Attributes of Used car include VIN, make, model, year, color, asking price, number of miles, number of collisions, tire age, and number of owners.
Attributes of Repair include id, description, cost
Attributes of Service include id, description, cost, hourly rate, number of hours worked on car
Business Rules:
- A customer can purchase many cars, but each car is sold to one customer.
- A car can have many services performed, each service can be performed on one or more cars.
- A car can have many repairs performed, each repair can be performed on one or more cars.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
