Airline Database Management
AIRLINE MANAGEMENT DATABASE CONCEPTUAL DESIGN
Course: Database Systems
Course ID: CSCI-760
Instructor: Dr Adly Elzoheary Student: Jagmit Singh
School ID: 0653535
Table of contents: 1) Airline Industry at a Glance 2) Arms and Legs of an airline industry 3) Project requirements 4) Business Rules and Function Rules 5) UML diagram 6) Database dependency diagram (DDD) 7) Snapshots of tables created 8) Script for table creation 9) Script for database testing
* Airline Industry: * An airline provides air transport services for passengers or freight, generally with a recognized operating certificate or license. Airlines lease or own their aircraft with which to supply these services and may form partnerships or alliances with other airlines for mutual benefit. * Airlines vary from those with a single aircraft carrying mail or cargo, through full-service international airlines operating hundreds of aircraft. Airline services can be categorized as being intercontinental, intra continental, domestic, or international and may be operated as scheduled services or charters. * Full-service airlines have a high level of fixed and operating costs in order to establish and maintain air services: labor, fuel, airplanes, engines, spares and parts, IT services and networks, airport equipment, airport handling services, sales distribution, catering, training, aviation insurance and other costs. Thus all but a small percentage of the income from ticket sales is paid out to a wide variety of external providers or internal cost centers. * Groups such as the International Civil Aviation Organization establish worldwide standards for safety and other vital concerns. Most international air traffic is regulated by bilateral agreements between countries, which designate specific carriers to operate on specific routes. The model of such an
Course: Database Systems
Course ID: CSCI-760
Instructor: Dr Adly Elzoheary Student: Jagmit Singh
School ID: 0653535
Table of contents: 1) Airline Industry at a Glance 2) Arms and Legs of an airline industry 3) Project requirements 4) Business Rules and Function Rules 5) UML diagram 6) Database dependency diagram (DDD) 7) Snapshots of tables created 8) Script for table creation 9) Script for database testing
* Airline Industry: * An airline provides air transport services for passengers or freight, generally with a recognized operating certificate or license. Airlines lease or own their aircraft with which to supply these services and may form partnerships or alliances with other airlines for mutual benefit. * Airlines vary from those with a single aircraft carrying mail or cargo, through full-service international airlines operating hundreds of aircraft. Airline services can be categorized as being intercontinental, intra continental, domestic, or international and may be operated as scheduled services or charters. * Full-service airlines have a high level of fixed and operating costs in order to establish and maintain air services: labor, fuel, airplanes, engines, spares and parts, IT services and networks, airport equipment, airport handling services, sales distribution, catering, training, aviation insurance and other costs. Thus all but a small percentage of the income from ticket sales is paid out to a wide variety of external providers or internal cost centers. * Groups such as the International Civil Aviation Organization establish worldwide standards for safety and other vital concerns. Most international air traffic is regulated by bilateral agreements between countries, which designate specific carriers to operate on specific routes. The model of such an