Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an Entity Relationship Diagram (ERD) for the following case study: Blue Garage Private Limited (BLM) provides car maintenance services to their clients. To keep

Draw an Entity Relationship Diagram (ERD) for the following case study: Blue Garage Private Limited (BLM) provides car maintenance services to their clients. To keep costs low, BLM employs freelance mechanics. A record of the names of freelance mechanic working for the garage together with their employee identification is maintained for payment purposes. A car has one owner although some owners have more than one car. When a client contacts the garage, the workshop clerk verifies the client's details. If it is a new client, details of the client are added to the client files. The clerk checks the current service schedule, and the date and time are agreed with the client and a unique job number is given to the client for reference. The chief supervisor assigns mechanics to carry out each service job. Sometimes more than one mechanics are assigned to the job. Each job might require using one or more service parts. This service part has a part number, description, and unit price for billing purpose. When the job is complete, the clerk prepares a bill for the client. On payment, the clerk updates the job record. Please take note that the ERD must clearly show all attributes, primary key, foreign key, relationships (and their types) on the diagram., as well as any assumptions you have made.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Freelance Mechanic mechanicid Primary Key name employeeid Car ... 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

Systems Analysis And Design

Authors: Alan Dennis, Barbara Wixom, Roberta M. Roth

7th Edition

1119496489, 978-1119496489

More Books

Students also viewed these Operating System questions

Question

What are metadata? Why are they important to system developers?

Answered: 1 week ago

Question

What is really the cause of the conflict?

Answered: 1 week ago