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
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 4RA
Related questions
Question
Alert dont submit
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage