Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Harness The Power Of Big Data The IBM Big Data Platform

Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos

1st Edition

0071808183, 9780071808187

More Books

Students also viewed these Databases questions