Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help please will thumbs up! Mark sure to Label the on the ER diagram by: Key Attributes - By Underlining Multi Value - With Double

Help please will thumbs up!

Mark sure to Label the on the ER diagram by:

Key Attributes - By Underlining

Multi Value - With Double Oval on Attribute

Cardinality

Participation

image text in transcribed

An automobile body repair shop needs to keep information about its operations. Customers initially bring their cars to the shop for an estimate of repairs. A mechanic looks at the car and estimates the cost and time required for the entire job. If the customer accepts the estimate, a job number is assigned and the customer's name and contact information; the car's license plate number, make, model, and year; and a list of the repairs needed are recorded. The customer then makes an appointment to bring in the car on a specified date. When the car is brought in for repairs, the work begins. The shop keeps track of the charges for parts and labor as they accumulate. Only one mechanic works on the car for the entire job. A job might include several repairs (e.g., replacing the left fender, painting the passenger door). The time actually spent for each repair is recorded and used to calculate the cost of labor, using a fixed hourly rate. Also note the following requirements: 1) Each mechanic has a unique employee ID. A mechanic's name and phone are to be stored in the database 2) Each part has a unique part number 3) The part(s) used for a particular repair depend(s) upon the mechanic working on that repair Event: Customer accepts estimate o Mechanic info who looks at the car and gives cost/time estimate Cost estimate and time estimate o Job number o Customer info o Car info (License plate#, make, model, year) o List of repairs Event: Customer makes appointment o Appointment date Event: Customer brings car in o Charges for each part labor using fixed hourly rate and actual time spent for each repair Charges for every Actual time for each repair o

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual Basic Net Database Programming

Authors: Rod Stephens

1st Edition

0789726815, 978-0789726810

More Books

Students also viewed these Databases questions

Question

List the six factors that affect stock option prices. AppendixLO1

Answered: 1 week ago