Question
For the context below, draw an ER Diagram. You may make assumptions as necessary, but state any assumptions that you make. HomeCarRepair is an organization
For the context below, draw an ER Diagram. You may make assumptions as necessary, but state any assumptions that you make.
HomeCarRepair is an organization that offers a unique service. Using HomeCarRepair, customers can book an appointment for a car mechanic to come to their home and repair their vehicle. The company has locations in all major cities of the US. Each location has supervisory staff, who oversee one or more full time mechanics. Each location has a location manager to whom all supervisory staff report to.
The company hires full time mechanics on their payroll, and each mechanic is assigned a supervisor. Not all mechanics can repair/diagnose all cars. Each mechanic has a set of vehicle makes and models he/she is familiar with. Mechanics are assigned to only those car types which correspond to their expertise area.
The customer makes an appointment by specifying the type of repair that is required, or if it is unknown, the customer writes a note about what is wrong with the car. Each repair has a specific price associated with it. An available mechanic who can work on the customers car is then assigned to do the repair/diagnosis visit.
Step 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