Answered step by step
Verified Expert Solution
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 ...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