Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

include any assumptions

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 o o Customer info Car into (License plate#, make, model, year) List of repairs Event: Customer makes appointment o Appointment date Event: Customer brings car in o Charges for each part o Charges for every labor using fixed hourly rate and actual time spent for each repair o Actual time for each repair

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

Seven NoSQL Databases In A Week Get Up And Running With The Fundamentals And Functionalities Of Seven Of The Most Popular NoSQL Databases

Authors: Aaron Ploetz ,Devram Kandhare ,Sudarshan Kadambi ,Xun Wu

1st Edition

1787288862, 978-1787288867

Students also viewed these Databases questions