Back to the Data Model
PURPOSE OF THESE BUSINESS RULES :-
These Business Rules define the functional requirements which the Database must meet.
They form the basis for agreement between the User and the Database Designer and are
written in a form of structured English which is clear and unambiguous.
The Business Rules have been defined and are detailed here ...
A. The Area being Modelled is :-
An Airline Reservations System.
B. The Things of Interest, ('THINGS'), include :-
B.2 Aircraft Types
B.6 Legs in a Flight
B.11 Ticket Types
B.12 Travel Class
C. How are these THINGS_OF_INTEREST related ?
C.1 A PASSENGER can have zero or many RESERVATIONS.
c.2 A BOOKING can be for one and only one PASSENGER.
c.3 A GROUP_RESERVATION can be for one or many PASSENGERS.
E. Sample Data includes :-
E.1 To be determined
F. Typical Enquiries include :-
F.1 Do we have two Seats together for Australia ?
F.2 Show status report of all flights for one day and the avaibility of each seat, on each flight.
F.3 Show a flight report that can be printed out for a single flight that shows passenger name,
type of fares and totals for each class of travel.
November 20th. 2008