Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
ABC company is a car dealership that operates a service facility. A salesperson may sell many cars, but each car is sold by only one salesperson.o A salesperson has a unique id, a first name, and a last name.o Each car has its unique VIN number, make, model, color, and year. A customer may buy many cars, but each car is bought by only one customer. Each invoice has its invoice number, date of transaction.o A salesperson writes a single invoice for each car he or she sells.o 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.o A service ticket has its unique number, date received and date returned.o The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the cars VIN number. Each service ticket may include many different services and the same service (i.e., oil change) can be done for many different service tickets. o A service has its ID, name, and hourly rate.o For a given service ticket and a specific service, only one mechanic is assigned. But the same mechanic can work for other services (in different service tickets). o Each mechanic has his/her ID, first name, and last name. Please create an erd diagram with entities, attributes, the relationships, the primary keys and foreign keys. Thanks

ABC company is a car dealership that operates a service facility. A salesperson may sell many cars, but each car is sold by only one salesperson.o A salesperson has a unique id, a first name, and a last name.o Each car has its unique VIN number, make, model, color, and year. A customer may buy many cars, but each car is bought by only one customer. Each invoice has its invoice number, date of transaction.o A salesperson writes a single invoice for each car he or she sells.o 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.o A service ticket has its unique number, date received and date returned.o The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the cars VIN number. Each service ticket may include many different services and the same service (i.e., oil change) can be done for many different service tickets. o A service has its ID, name, and hourly rate.o For a given service ticket and a specific service, only one mechanic is assigned. But the same mechanic can work for other services (in different service tickets). o Each mechanic has his/her ID, first name, and last name. Please create an erd diagram with entities, attributes, the relationships, the primary keys and foreign keys. Thanks

Database System Concepts
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
icon
Related questions
Question

Alert dont submit AI generated answer.

ABC company is a car dealership that operates a service facility. A salesperson may sell many cars, but each car is sold by only one salesperson.o A salesperson has a unique id, a first name, and a last name.o Each car has its unique VIN number, make, model, color, and year. A customer may buy many cars, but each car is bought by only one customer. Each invoice has its invoice number, date of transaction.o A salesperson writes a single invoice for each car he or she sells.o 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.o A service ticket has its unique number, date received and date returned.o The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the cars VIN number. Each service ticket may include many different services and the same service (i.e., oil change) can be done for many different service tickets. o A service has its ID, name, and hourly rate.o For a given service ticket and a specific service, only one mechanic is assigned. But the same mechanic can work for other services (in different service tickets). o Each mechanic has his/her ID, first name, and last name. Please create an erd diagram with entities, attributes, the relationships, the primary keys and foreign keys. Thanks
Transcribed Image Text:ABC company is a car dealership that operates a service facility. A salesperson may sell many cars, but each car is sold by only one salesperson.o A salesperson has a unique id, a first name, and a last name.o Each car has its unique VIN number, make, model, color, and year. A customer may buy many cars, but each car is bought by only one customer. Each invoice has its invoice number, date of transaction.o A salesperson writes a single invoice for each car he or she sells.o 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.o A service ticket has its unique number, date received and date returned.o The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the cars VIN number. Each service ticket may include many different services and the same service (i.e., oil change) can be done for many different service tickets. o A service has its ID, name, and hourly rate.o For a given service ticket and a specific service, only one mechanic is assigned. But the same mechanic can work for other services (in different service tickets). o Each mechanic has his/her ID, first name, and last name. Please create an erd diagram with entities, attributes, the relationships, the primary keys and foreign keys. Thanks
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Linux
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS