Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

E-R, do not add any entity unless absolutely needed. You may broaden keys as needed to accommodate the necessary design constraints. Do not forget attributes

image text in transcribed

E-R, do not add any entity unless absolutely needed. You may broaden keys as needed to accommodate the necessary design constraints. Do not forget attributes and show all keys. Items come into the shop for repair. Each item is of a typebecause i Honda Civic". An item is identified by an item id (item#) and its type. An item comes into the shop because it has a problem, of course ; e.g., "faulty has, and the day the item comes in. The shop keeps a catalogue of problems. Each problem entry is an official fuel injector". When the item comes in, a ticket is issued. The ticket identifies the item, the problem the item description of a problem for a given type of item; e.g., "faulty fuel injector ona 2003 Honda Civic". A problem catalogue entry states how many hours such a repair takes. Any ticket should be valid; that is, the problem unique employee id (emp#). A mechanic may be licensed in any number of skills; e.g., "fuel injector repair". (And, of course, each skill may have several mechanics licensed for it.) Record when a mechanic first became licensed for a skill . A skill records an hourly rate that a licensed mechanic will earn doing a job requiring the skill. Each catalogue problem requires a specific skill for the repair. Only a mechanic with the appropriate skill may be assigned a given ticket to do the repair. A repair records when the repair for a ticket is finished, and by which licensed mechanic. A ticket will have at most one repair. (If the same item breaks again in the same way later, it will be brought back to the shop and a new ticket is issued.)

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

More Books

Students also viewed these Databases questions

Question

Which state has the lowest sum of transaction amount?

Answered: 1 week ago