Need your assistance on this ERD Diagram QUESTION 3 (20 MARKS) 1. Create an entity-relationship diagram (ERD)

Need your assistance on this ERD Diagram

 

Transcribed Image Text:

QUESTION 3 (20 MARKS) 1. Create an entity-relationship diagram (ERD) based on the following description. Use the crow's feet notation that we used during this semester. A small garage needs a database to store information about the repair work that is done on customers' vehicles. The database needs to store information about customer's name, customer's address, customer's work telephone number, date of work done, vehicle make, vehicle model, description of work done, the parts needed to complete the job, the labour charge and the total cost of the job. Several parts may be needed in any job. Each type of part has a description and a cost. For warranty reasons data must be maintained in the database for at least 90 days, therefore a customer may have several records in the database at any time. Your ERD should show all entities, attributes, relationships, maxim cardinality and minimum cardinalty (participation). Indicate all primary keys and foreign keys. Include a legend to your diagram. (8 marks) QUESTION 3 (20 MARKS) 1. Create an entity-relationship diagram (ERD) based on the following description. Use the crow's feet notation that we used during this semester. A small garage needs a database to store information about the repair work that is done on customers' vehicles. The database needs to store information about customer's name, customer's address, customer's work telephone number, date of work done, vehicle make, vehicle model, description of work done, the parts needed to complete the job, the labour charge and the total cost of the job. Several parts may be needed in any job. Each type of part has a description and a cost. For warranty reasons data must be maintained in the database for at least 90 days, therefore a customer may have several records in the database at any time. Your ERD should show all entities, attributes, relationships, maxim cardinality and minimum cardinalty (participation). Indicate all primary keys and foreign keys. Include a legend to your diagram. (8 marks)