Create only the entity relationship diagrams

Assignment Help Computer Engineering

Reference no: EM132157048

Use DIA to create ONLY the Entity Relationship Diagrams (ERD) for the following question.

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 car includes plate#, make, model, and year

- Each car is owned by one customer, each customer may have more than one car.

- 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

(This problem was already posted elsewhere on here, but the answer they gave left me really confused about several things, so I'm posting it again).

Reference no: EM132157048

Questions Cloud

What is the effective annual rate : The interest rate on a savings account is 6.2 percent, compounded daily. Assume there are 365 days in a year. What is the effective annual rate (EAR or EFF%)

Using the euclidean algorithm find the decipherment key : Use the Euclidean Division Algorithm to show that 31 and 207 are relatively prime, and hence find integers x and y such that 1= 207x + 31y.

What is the maximum amount scholarship : What is the maximum amount your scholarship will be able to pay out each year? Round your answer to the nearest cent.

Explain the term symmetric key cipher : Use concrete examples to explain each of the following concepts relating to security in network computing: symmetric key cipher.

Create only the entity relationship diagrams : QuickLube is in the quick oil and lube business. Although customers bring in their cars for service such as oil change.

Design an html form to enter a country : Use the database file to design an HTML form to enter a country and the php code loads information about the country and a list of its cities.

Analyze algorithm and show the results in order notation : Use the divide-and-conquer approach to write a recursive algorithm that finds the maximum sum in any contiguous sublist of a given list of n real values.

Create the hash function that produces an n bit hash : Use an encryption function to create a hash function. Assume you have an encryption function of n bits - and you are to construct a hash function of n bits.

Create an informative website : Create an informative website. The site must also include a minimum of two interactive data visualizations.

User Account

All Pages