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.(a) Create an E-R data model based on the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!