Reference no: EM131839181

Question: 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 acceps the estimate, a job number is assigned and the customers 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 accumalte. Only one mechanic works on the car for the entire job. A job might include several repairs (i.e, 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. Assume the shop is expanding to perform mechanical repairs as well as body work. Body work can be done by a technician, but all mechanical repairs require a licensed mechanic. Jobs now may require one technician to handle the body work (if any) and a licensed mechanic to do the mechanical repairs. Draw an EE-R diagram for the automobile body repair shop.