Question: Hi, the question is 2. QuickLube is in the quick oil and lube business. Although customers bring in their cars for service such as oil

Hi, the question is

2. QuickLube is in the quick oil and lube business. Although customers bring in their cars for service such as oil change. QuickLube also replaces windshield wipers, oil filters, and air filters, subject to customer approval. The ERD should contain information about each customer, his/her car, date of service, grade and amount of oil used, parts replaced, and of course, total amount due.

  • Information about a customer is CustomerID, Name and Address.
  • Information about a car includes plate#, make, model, and year
  • Each car is owned by one customer, each customer may have more than one car.
  • A car can receive many services. Each service is either part replacement, oil change or both.
  • Each part(whindshield wippers, oil filters, or air filters, etc.) has a unique part number. Each part has a part cost and labor cost.
  • Different grade of oils are available. A grade of oil has a grade name(A,B,C etc) and a price/qt.
  • Each car may require different amount of oil
  • When a customer take a car to QuickLube for oil change, some parts may be replaced in the service

Is the ERD diagram I designed correct, and if not what is incorrect about it? I know their are other solutions available on Chegg for this problem, but I kindly ask you to give me feedback on the ERD I drew and not just repost a solution.

Thank you

Hi, the question is 2. QuickLube is in the quick

HW 2 CUSTOMER Customer ID Name (F,M,L) Address (st,city, state, zip) HT SERVICE CAR *Plate Number Make Model Year Parts_Replaced Amount_of_Oil PART OIL CHANGE * Part Number Part Cost Labor Cost * Grade Name Price/OT

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!