Answered step by step
Verified Expert Solution
Link Copied!

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


Screenshot 2.jpg


 

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

Calculate UTX's market value-added (MVA) for each year 2010-2012.

Answered: 1 week ago