Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need your assistance on this ERD Diagram QUESTION 3 (20 MARKS) 1. Create an entity-relationship diagram (ERD) based on the following description. Use the crow's
Need your assistance on this ERD Diagram
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started