Database Fundamentals Overview: In this you are required to draw the ER diagram from the written specification and re- c

[answerhappygod]

Database Fundamentals Overview In This You Are Required To Draw The Er Diagram From The Written Specification And Re C 1 (52.19 KiB) Viewed 75 times

Database Fundamentals Overview: In this you are required to draw the ER diagram from the written specification and re- create a written specification from an ER diagram. Activity 1: Draw an ER Diagram Draw an Entity Relationship diagram (including connectivity and Cardinality) from the above description. State any assumptions or additional constraints you have used. Case Study The owner of Xpresstex (a laptop repair company) wants to keep track of the jobs related to the repair for the laptops they repair, the item utilized for the repair of each job, the labor cost associated for the repair of each job, the repairmen performing each repair job and the total cost associated with each repair job. When customers bring their laptops in to be repaired, they make a deposit on the repair job and are given a date to return and uplift their laptops. Repairmen then perform repairs on the customers' laptops based on the repair job and detail the labor costs and the items used for each repair job. When customers return, they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and uplift the repaired laptop using this payment receipt.