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