Database Answers Runway at Heathrow Airport. (Click for Web Site)
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
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 aircraft 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 Aircraft 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