Question

The owners of a small car repair shop would like to keep track of the repair jobs for cars they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job.

When customers bring their cars in to be repaired, they are given a date to return and pick up their car. Repairmen, which can be more than one, then perform repairs on the customers’ cars based on the repair job, and detail the list of labor costs and the list of items used for each repair job.

When customers return they pay the total cost of the repair job and pick up the repaired car. Note that the shop must record the payment for each repair job.

Use this scenario to generate an ER diagram (crow's foot notation only please). The take the ER diagram and convert it into a relational schema, in horizontal schema notation

Answer 1

PLEASE GIVE IT A THUMBS UP, I SERIOUSLY NEED ONE, IF YOU NEED ANY MODIFICATION THEN LET ME KNOW, I WILL DO IT FOR YOU