Question: (a) Create an E-R data model based on the following description: 1. A customer may own one or more automobiles that are repaired at Regal.
(a) Create an E-R data model based on the following description: 1. A customer may own one or more automobiles that are repaired at Regal. 2. An automobile is serviced using a repair order. Over its life cycle, an automobile may have several repair orders. 3. Each repair order contains one or more repair details, each detail based on a specific customer complaint. 4. A trouble code is associated with zero, one, or more repair details. 5. A mechanic is assigned to each repair detail. A mechanic will work on many repair details. 6. A part detail lists all the parts associated with a repair detail. The part detail includes the part IDs and quantities used in the repair. Some repair details have no part detail because no parts are involved in the repair. 7. A part is associated with zero, one, or many part details. 8. A repair order has a repair cost summary, which includes the labor costs, part costs, and total cost. (b) Using the information in Figure CS3.2 and elsewhere in the description of this case, assign attributes to entities, indicating the primary and foreign keys.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
