COMP 378 Lecture Notes - Lecture 6: Edmonton International Airport, Social Insurance Number
30 Jun 2018
School
Department
Course
Professor
Question 6 (20 marks)
The Edmonton International Airport would like to implement a database that will be used to keep track of airplanes,
their owners, airport employees, and pilots. From the requirements for this database, the following information was
collected.
Each airplane has a registration number, is of a particular plane type, and is stored in a particular hangar.
Each hangar is managed by an employee who supervises the maintenance services performed in that
hangar.
Each plane type has a model number, a capacity, and a weight.
Each hangar has a number, a capacity, and a location.
The database keeps track of the owner of each plane, and the employees who have maintained each
plane.
The database keeps track of each airplane’s purchase date.
Each maintenance service record is identified by a work code, and includes the employee who
performed the service, the date and time of the service, and the number of hours the maintenance service
required.
Each plane undergoes service many times, and all its service records are kept.
An owner can be either a person or a corporation.
A person can be an owner, a pilot, or an employee of the airport.
Each pilot has specific attributes, including license number and restrictions.
Each employee has specific attributes, including salary and shift worked.
The database stores social insurance number, name, address, and telephone number for all person
entities.
The database stores name, address, and telephone number for all corporation entities.
The database also keeps track of the types of plane each pilot is authorized to fly, and the types of plane
each employee is qualified to service.
Draw an object-oriented diagram for the Edmonton International Airport database.
Airplane (airreg_no,plane_type, hanger,mmodel, capacity, weight,purchase_date,maintainedby)
Hanagr (hang_maintainer, han_no, han_capacity, han_loc)
maintainance(work_code,serv_emp,serv_date,hours_serv,airreg_no,)
employee (emp_code,emp_name,salary,shift,address,phone)
pilot (p_code,p_name,licence,address,phone)
Introduction to Database Management 1
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
The edmonton international airport would like to implement a database that will be used to keep track of airplanes, their owners, airport employees, and pilots. From the requirements for this database, the following information was collected. hangar. plane. Each airplane has a registration number, is of a particular plane type, and is stored in a particular hangar. Each hangar is managed by an employee who supervises the maintenance services performed in that. Each plane type has a model number, a capacity, and a weight. Each hangar has a number, a capacity, and a location. The database keeps track of the owner of each plane, and the employees who have maintained each. The database keeps track of each airplane"s purchase date. Each maintenance service record is identified by a work code, and includes the employee who performed the service, the date and time of the service, and the number of hours the maintenance service required. entities.
