Answered step by step
Verified Expert Solution
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
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 oStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started