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 salesperson can sell many cars, but each car is sold by only one salesperson.A customer can buy many cars, but each car is sold to only oneA salesperson writes a single invoice for each carA customer gets an invoice for each car(s) heA customer might come in only to have a car serviced; that is, one need not buy a car to be classified as aWhen a customer takes in one or more cars for repair or service, one service ticket is written for eachThe car dealership maintains a service history for each car serviced. The service records are referenced by the car’s serialA car brought in for service can be worked on by many mechanics, and each mechanic can work on manyA car that is serviced may or may not need (For example, parts are not necessary to adjust a carburetor or to clean a fuel injector nozzle.)

Entity: Rectangles are used to represent entities. Rectangles are given names that correspond to the…

Answered: 1. Create the initial ER diagram…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

A salesperson can sell many cars, but each car is sold by only one salesperson.
A customer can buy many cars, but each car is sold to only one
A salesperson writes a single invoice for each car
A customer gets an invoice for each car(s) he
A customer might come in only to have a car serviced; that is, one need not buy a car to be classified as a
When a customer takes in one or more cars for repair or service, one service ticket is written for each
The car dealership maintains a service history for each car serviced. The service records are referenced by the car’s serial
A car brought in for service can be worked on by many mechanics, and each mechanic can work on many
A car that is serviced may or may not need (For example, parts are not necessary to adjust a carburetor or to clean a fuel injector nozzle.)

Expert Solution