How to produce a data model segment

Assignment Help Computer Engineering

Reference no: EM1326736

The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC's aircraft. Produce a data model segment that reflects the following business rules:

All mechanics are FRC employees. Not all employees are mechanics.

Some mechanics are specialized in engine (EN) maintenance. Some mechanics are specialized in airframe (AF) maintenance. Some mechanics are specialized in avionics (AV) maintenance. (Avionics are the electronic components of an aircraft that are used in communication and navigation.) All mechanics take periodic refresher courses to stay current in their areas of expertise. FRC tracks all course taken by each mechanic?date, course type, certification (Y/N), and performance.

FRC keeps a history of the employment of all mechanics. The history includes the date hired, date promoted, date terminated, and so on. (Note: The "and so on" component is, of course, not a real-world requirement. Instead, it has been used here to limit the number of attributes you will show in your design.)

Reference no: EM1326736

Questions Cloud

Discuss pros of using automated testing tools : Why do so many in-house applications never get finished.

Exemplifying the negligence : Dona gets permission from her mother (single mom) to spend the weekend with her friend and her friends parents.

What are the advantages of using the scsi devices : What will be different about performing a hard-drive-to-tape backup with IDE devices and with SCSI devices? What are the advantages of using SCSI devices over IDE devices for the backups.

Method promote to attract competitive workforce : Evaluate and identify three (3) methods or guidelines a personnel manager should promote in order to find and attract a competitive workforce.

How to produce a data model segment : Some mechanics are specialized in engine (EN) maintenance. Some mechanics are specialized in the airframe (AF) maintenance. Some mechanics are specialized in avionics (AV) maintenance.

Elucidate how might raise the chance that the employee : Elucidate how might raise the chance that the employee would retire earlier as compared with the situation where the employee had to pay for his own health insurance.

Explaining about the tort liability : Mary is cutting weeds at her home. She is unable to trim some weeds she finds, because they grew between the rocks.

Marlene will live for for more time duration : Marlene will live for for more time duration. In the current period, she has the option of attending college.

Describe the differences among b2b : Describe the differences among B2B and What do the abbreviations mean

User Account

All Pages