Use the following brief description of operations as the source for the next database design:

All aircraft owned by ROBCOR require periodic maintenance. When maintenance is required, a maintenance log form is used to enter the aircraft identification number, the general nature of the maintenance, and the maintenance starting date. A sample maintenance log form is shown in Figure PB.7A.

Figure PB.7 A:

Once the maintenance log form is initiated, the maintenance log form€™s number is written on a maintenance specification sheet, also known as a maintenance line form. When completed, the specification sheet contains the details of each maintenance action, the time required to complete the maintenance, parts (if any) used in the maintenance action, and the identification of the mechanic who performed the maintenance action. The maintenance specification sheet is the billing source (time and parts for each of the maintenance actions), and it is one of the sources through which parts use may be audited. A sample maintenance specification sheet (line form) is shown in Figure PB.7B.

Figure PB. 7 B:

Parts used in any maintenance action must be signed out by the mechanic who used them, thus allowing ROBCOR to track its parts inventory. Each sign-out form contains a listing of all the parts associated with a given maintenance log entry. Therefore, a parts sign-out form contains the maintenance log number against which the parts are charged. In addition, the parts sign-out procedure is used to update the ROBCOR parts inventory. A sample parts sign-out form is shown in Figure PB.7C.

Figure PB.7 C:

Mechanics are highly specialized ROBCOR employees, and their qualifications are quite different from those of an accountant or a secretary, for example.

Given this brief description of operations, draw the fully labeled ER diagram. Make sure you include all the appropriate relationships, connectivities, and cardinalities.

Transcribed Image Text:

ROBCOR Aireraft page 1 of 1 Service Log #: 2155 Checked in by: George D. Ramsey (115) Aircraft: 2155w Date in: 18-Jan-2014 Squawk summary 1. Left mag rough on run-up_ |2. Nose gear shimmies at taxi speeds 3. Left main gear door does not close flush with wing panel 4. Gear struts do not maintain proper pressure 5. Left engine vibrates when power is pulled back to 20 in. manifold pressure 6. 7. 8. 9. 10. Released by: Bea L. Patterson (109) Aircraft release date: 19-Jan-2014 ROBCOR Aircraft page 1 of 1 Service Log #: 2155 Item Action des cription Time Part Units Mechanic 0.8 None Performed run-up. Rough mag reset 112 Cleaned #2 bottom plug. left engine 2 0.9 None 112 3 Replaced nose gear 1.3 P-213342A 103 shimmy dampen er Replaced left main gear door oleo strut seal 1.7 GR/311109S 112 Cleaned and checked 1.7 None 116 gear strut seals 8. 5.