Question
A workshop has a manager and a pool of mechanics. When a customer arrives, the manager inspects customers car and prepares a task sheet. Manager
A workshop has a manager and a pool of mechanics. When a customer arrives, the manager inspects customers car and prepares a task sheet. Manager than assigns this task sheet to one or more mechanics. Attributes of manager are employed_id, name, address and phone. Attributes of mechanic are employed_id, name, address, phone and specialty. Attributes of customer are customer id, name, phone. Attributes of task sheet are task id, description, start date, finish date, part number (These are the parts that were purchased during repair work). Attributes of Bill are Bill number, cost of work, cost of parts. A mechanic can be assigned more than one car over a time period. A car can be assigned more than one mechanic but at least one mechanic is must assigned. Develop an ERD for this problem.
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