Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Database Security Applications And Trends

Authors: Michael Gertz, Sushil Jajodia

1st Edition

1441943056, 978-1441943057

More Books

Students also viewed these Databases questions