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.

ERD Exercise

Prepare an Entity Relationship Diagram for Patty’s Daycare Centre. For each entity indicate the primary key by underlining attribute(s) making up primary key and also specify 1 additional significant attribute. Identify and label significant relationships between pairs of entities (either 1:1, 1 : M or M:N).

Patty’s Playschool is a child daycare centre. A parent registers their child or children at the school using a registration form. A parent can submit more than one registration form. Each room in the daycare is assigned an age group. For example an infant is under 1 yearof age and toddlers are from 1 to 3 years of age. A child is assigned to a room based on their age and availability of space. A room may be assigned one or more employees. An employee can only be assigned to one room. The minimum number of employees required for a room is determined by the number of children assigned to the room and the child:staff ratio identified by the government. For example one employee can care for 5 infants or 8 toddlers.