COMP 266 Lecture Notes - Lecture 5: Edmonton International Airport, Social Insurance Number

131 views4 pages
Question: The Edmonton International
Airport would like to i...
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.
Expert Answer
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
Unlock document

This preview shows page 1 of the document.
Unlock all 4 pages and 3 million more documents.

Already have an account? Log in

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. 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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents