Question: Problem 5 : The FlyRight Aircraft Maintenance ( FRAM ) division of the FlyRight Company ( FRC ) performs all maintenance for FRC s aircraft.
Problem : The FlyRight Aircraft Maintenance FRAM division of the FlyRight Company FRC performs all maintenance for FRCs aircraft. Produce a data model using ERD that reflects the following business rules:
All mechanics are FRC employees. Not all FRC employees are mechanics, ie a general employee.
All mechanics must have one and only one specialization. Some mechanics specialize in engine EN maintenance. Others specialize in airframe AF maintenance or avionics AV maintenance. Each mechanic can specialize in one type of maintenance.
o For EN maintenance mechanics, we also record hisher maintenance level information, whose value is from level to level
o For AF maintenance mechanics, we also record the airframe part information heshe is working on We assume each AF maintenance mechanic works on only one airframe part.
o For AV maintenance mechanics, we also record he is working on communication or navigation. This can be done by adding two attributes communication and navigation to the entity with the value Y or N
All mechanics take periodic refresher training to stay current in their areas of expertise. Each training has a training description. FRC tracks all training taken by each mechanicdate course type, certification YN and performance. Each training can be participated by multiple mechanics.
FRC keeps an employment history of all employees. The history includes the company name, position, date hired, the date promoted, and the date terminated.
Based on the above requirements, create the Crows Foot ERD. You may add necessary attributes for an entity in your design. You are required to use ERD drawing software such as draw.io to create your ERD. The handwritten version will not be accepted.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
