The management of Philippine Air Lines has decided to use a Database Management System for their operations. To construct the DBMS, we are given with the following pertinent items:
- Each PAL plane model is given a a registration number.
- Each PAL plane model is also given a specific number (e.g., PA-22)
- Each PAL plane model is also given its own weight and capacity.
- All PAL technicians’ information(i.e. name, SSS, address, telephone number, and salary) should be stored in the DBMS.
- PAL technicians are experts on one or more plane model(s). His expertise may overlap with that of other technicians. This should also be recorded.
- All PAL traffic controllers must have a yearly physical examination and you should store the date of the most recent exam.
- Each PAL worker (including technicians) is a member of their respective labor unions. The union membership number of each employee must be part of the DBMS as well.
- Each PAL employee is assigned with a unique social security number.
- NAIA has several tests regularly to make sure that their vehicles are still airworthy. Each test has a Civil Aviation Authority (CAA) test number, a name, and a maximum possible score.
- The CAA requires NAIA to keep track of these tests and store the following: the date, the number of hours the technician spent doing the test, and the score that the airplane received on the test.
- Draw an ER diagram using ERD Plus for the airport database.