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

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter5: Working With Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 4AYK
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS