Question
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.
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 airplanes 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started