Create an ERD for a car dealership. The dealership sells both new and used cars, and it operates a service facility (see Figure B.2). Base your design on the following business rules:A salesperson may sell many cars, but each car is sold by only one salesperson.A customer may buy many cars, but each car is bought by only one customer.A salesperson writes a single invoice for each car he or she sells.A customer gets an invoice for each car he or she buys.A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer.When a customer takes one or more cars in for repair or service, one service ticket is written for each car.The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the car’s serial number.A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars.A car that is serviced may or may not need parts (e.g., adjusting a carburetor or cleaning a fuel injector nozzle does not require providing new parts).

The entity Relationship Diagram also referred to as ERD is a type of structural diagram for use in…

Answered: te an ERD for a car dealership. The…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Create an ERD for a car dealership. The dealership sells both new and used cars, and it operates a service facility (see Figure B.2). Base your design on the following business rules:

A salesperson may sell many cars, but each car is sold by only one salesperson.
A customer may buy many cars, but each car is bought by only one customer.
A salesperson writes a single invoice for each car he or she sells.
A customer gets an invoice for each car he or she buys.
A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer.
When a customer takes one or more cars in for repair or service, one service ticket is written for each car.
The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the car’s serial number.
A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars.
A car that is serviced may or may not need parts (e.g., adjusting a carburetor or cleaning a fuel injector nozzle does not require providing new parts).

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions