Computers and Technology, 28.02.2020 00:55 alyxkellar06

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).

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 24.06.2019 07:00, sudotoxic

Into what form does the barcode reader convert individual bar patterns?

Answers: 1

continue

Computers and Technology, 24.06.2019 21:30, shunna33

How is a wan different than a lan? both connect computers, but only wan users don’t need the same operating system. both are peer-to-peer networks, but only a wan requires networking hardware. both network computers, but only a wan can cover larger geographical ranges. both connect computers to the internet, but only wan connects to the cloud.

Answers: 1

continue

Computers and Technology, 25.06.2019 05:20, andrealeon2000

6. write a user-defined matlab function for the following math function: r() = 4cos(4sin ) the input to the function is  (in radians) and the output is r. write the function such that  can be a vector. a) use the function to calculate r(/6) and r(5/6). b) use the function to plot (polar plot) r() for 0 ≤  ≤ 2. hint: use “ polar” and/or for “polar plot in matlab." include the title “'r(\theta)=4cos(4sin(\theta))”

Answers: 1

continue

Computers and Technology, 26.06.2019 01:50, andybiersack154

Which of the following is not one of the steps a company would take in an attempt to prevent a malfunction or failure of their product? a. overdesign b. redundancy c. protesting of parts and procedures d. outsourcing of final product assembly

Answers: 1

continue

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...