Question: Problem 5 : The FlyRight Aircraft Maintenance ( FRAM ) division of the FlyRight Company ( FRC ) performs all maintenance for FRC s aircraft.

Problem 5: 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, i.e., 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 his/her maintenance level information, whose value is from level 1 to level 3.
o For AF maintenance mechanics, we also record the airframe part information he/she 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 (Y/N), 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 hand-written version will not be accepted.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!