Database 1 Pre-final Exam

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.
  1. Draw an ER diagram using ERD Plus for the airport database.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s