Create the data model segment for business rules

Assignment Help Basic Computer Science

Reference no: EM1382364

The FlyRight Aircraft Maintenance (FRAM) division of FlyRight Company (FRC) does all maintenance for FRC's aircraft. Create the data model segment which 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 electronic components of aircraft which are utilized in communication and navigation). All mechanics take periodic refresher courses to stay present in their areas of expertise. FRC tracks all courses taken by each mechanic - date, course type, certification (Y/N), and performance.

- FRC maintains a history of employment of all mechanics. The history writes date hired, date promoted, date terminated, and so on.

Reference no: EM1382364

Questions Cloud

What are some management characteristics that might help : What are some management characteristics that might help a company maintain competitive advantage through information technology? When answering these questions, keep in mind that the three traditional ways companies differentiate themselves

Tape corrections under following conditions : The tape is stretched over three equal spans. Calculate the tape corrections under the following conditions at field, temperature = 85ºF, pull = 18kg, E= 2.109 x 10 6 kg/cm 2

Find the magnitude of ft : Approximation the force a person should exert on a string attached to a 0.130 kg ball to make the ball revolve in a horizontal circle of radius 0.600 m.

Illustrate what you consider to be your own leadership : illustrate what you consider to be your own leadership style and, using examples, also discuss the various strategies and interventions which you have found successful in motivating and influencing people to accomplish certain.

Create the data model segment for business rules : The FlyRight Aircraft Maintenance (FRAM) division of FlyRight Company (FRC) does all maintenance for FRC's aircraft. Create the data model segment which reflects the following business rules.

Mythic heroes and heroines in movies : Please provide examples of types of male and female heroes and heroines found in classic or contemporary movies?

European companies rely upon foreign companies : Both big and small U.S. and European companies rely upon foreign companies for everything from software development to financial analysis.

Elucidate why is the formation of the corporation important : Deon Donato buys 1,000 common shares of Tromput Corporation in an offering of shares made pursuant to a Rule 506 exemption from the registration provisions of the Securities Act.

Finding dependent and independent variable : Proportion of Australians aged twenty-five years and over with high blood pressure, by age group, 1999-2000. Note: High blood pressure is defined as systolic blood pressure of 140 mmHg or more;

User Account

All Pages