subject

Create an ERD for a car dealership in crow's foot notation. The dealership sells both new and used cars, and it operates a service facility. 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).

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 22:00
During physical science class ben and jerry connected three identical lightbulbs in parallel to a battery where happens when ben removes one of the lightbulbs from it’s socket
Answers: 2
question
Computers and Technology, 22.06.2019 22:30
Alex’s family members live in different parts of the world. they would like to discuss the wedding plans of one of their distant relatives. however, alex wants all the family members to talk to each other simultaneously so that they can make decisions quickly. which mode of internet communication should they use? a. blog b. email c. wiki d. message board e. instant messaging
Answers: 2
question
Computers and Technology, 23.06.2019 03:50
Q-1 which of the following can exist as cloud-based it resources? a. physical serverb. virtual serverc. software programd. network device
Answers: 1
question
Computers and Technology, 23.06.2019 19:30
You can apply several different worksheet themes from which tab?
Answers: 1
You know the right answer?
Create an ERD for a car dealership in crow's foot notation. The dealership sells both new and used c...
Questions
question
Mathematics, 02.01.2020 15:31
question
Mathematics, 02.01.2020 15:31
question
Mathematics, 02.01.2020 15:31
question
Mathematics, 02.01.2020 15:31
question
History, 02.01.2020 15:31
question
Business, 02.01.2020 15:31
question
Mathematics, 02.01.2020 15:31
Questions on the website: 13722367