Database Answers Airport Management Operations from Aircraft Mgt Services Inc. (Click for Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Airport Management   
Back to the Data Model

The Requirements have been defined and are listed below.
The Area being Modelled is :-
Small Airport Management.

A. DESIGN NOTES :
A.1 This is a Statement of the User Requirements.
A small airport needs to keep track of its operations. 
It decides to establish a database system to do that. 
Its requirements as the following :- 
  • The airport has a manager for each of its hangers.     But at certain times, the hanger may not have a manager.
  • A hanger houses several planes.
  • Each airplane has a registration number, a model number, a capacity, and weight.
  • Each hanger has a number, a capacity and location.
  • Both manager and pilot have data kept on their social security number, name, address, and telephone number.
  • Each pilot has license number.
  • For each flight we keep track of the date of flying, departure time, arrival time, destination, and hours flying. B. The Things of Interest, ('THINGS'), include :- B.1 Airplanes B.2 Airports B.3 Flights B.4 Hangers B.5 Managers B.6 Pilots. B.7 Others to be determined. C. These THINGS are Related as follows :- C.1 To be determined. D. Other Characteristics of these THINGS include :- D.1 To be determined. E. Sample Data includes :- E.1 To be determined. F. Typical Enquiries include :- F.1
  •  
    Barry Williams
    November 12th. 2009
    Principal Consultant
    Database Answers
    Home Ask a Question Careers Contact us Data Models First Timers Search Site Map