. Create the initial ER diagram for a car dealership. The dealership sells both new and used cars, and it operates a service facility. Base your design on the following business rules: a. A salesperson can sell many cars, but each car is sold by onlyone salesperson. b. A customer can buy many cars, but each car is sold to only onecustomer. c. A salesperson writes a single invoice for each carsold. d. A customer gets an invoice for each car(s) hebuys e. A customer might come in only to have a carserviced; that is, one need not buy a car to be classified as a customer. f. When a customer takes in one or more cars for repair or service,one service ticket is written for each car. g. The car dealership maintains a service history for each car serviced. The service records are referenced by the car’s serialnumber. h. A car brought in for service can be worked on by many mechanics,and each mechanic can work on many cars. i. A car that is serviced may or may not need parts. (For example, parts are not necessary to adjust a carburetor or to clean a fuel injectornozzle.)

C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter11: Introduction To Classes
Section11.5: A Closer Look: Uml Class And Object Diagrams
Problem 1E
icon
Related questions
Question

1. Create the initial ER diagram for a car dealership. The dealership sells both
new and used cars, and it operates a service facility. Base your design on the
following business rules:
a. A salesperson can sell many cars, but each car is sold by onlyone
salesperson.
b. A customer can buy many cars, but each car is sold to only onecustomer.
c. A salesperson writes a single invoice for each carsold.
d. A customer gets an invoice for each car(s) hebuys
e. A customer might come in only to have a carserviced; that is, one need not buy
a car to be classified as a customer.
f. When a customer takes in one or more cars for repair or service,one service
ticket is written for each car.
g. The car dealership maintains a service history for each car serviced. The service
records are referenced by the car’s serialnumber.
h. A car brought in for service can be worked on by many mechanics,and each
mechanic can work on many cars.
i. A car that is serviced may or may not need parts. (For example, parts are not
necessary to adjust a carburetor or to clean a fuel injectornozzle.)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage