[Airline Information System]

Presented to: Madam Bushra

Presented by:Syed Muhammad Zeejah Hashmi

Umul WarahAymen Arfeen

Overview

Introduction Objectives of Project Scope of Project Limitations of Project Requirements of Project Database ER-Diagram ER Mapping to Relational Model (Transformation) Normalization Conclusion

Introduction

This system basically concerned with the reservation system of the airline system.

It is also concerned with the details of the passengers. It is also useful to generate the information about any particular

Flight and Planes. It will done according to the airline services of the different

countries.

Objectives of Project

Some of the objectives are listed below:

The general objective is to make the airline information system online based. Data will be store in organized form. Data manipulation will be easy. To reduce number of registers and documents. To reduce the time needed to reduce this job. To enable the passengers to save their time by using quick reservation. Easy to maintain the records. Record navigation will be very easy. Record duplication will be eliminated. Searching of any record will be very easy and very fast.

Scope of Project

The scope of project is given below:

This project designs and implements Air Information System. Supported by a well-designed database, all available air flight information is

integrated together and can be accessed easily through a single point. A friendly user interface is provided so that various combinations of search

criteria that can be fetched from user and generates corresponding database search statements.

The Air Information System provided best interface between passengers and the airline workers.

The Air Information System will support frequent user registration and personal information.

Limitations of Project

This project is limited in the following boundary:

Online ticket cancellation service. Difficult in accessing data. Data is not flexible.

Requirements of Project

Hardware Requirement:

Processor : Core 2 Duo and Above. RAM : 1GB and Above.

Software Requirement:

Operating System: Windows 7 and up. Developing Tool : Oracle (front end)

Database : ORACLE (back end)

Database ER-Diagram

ER Mapping to Relational Model (Transformation)

Step 1:

Step 2:

Normalization

1NF

2NF

Conclusion This project has something like cancelation of tickets are missing

but it can surely help with the airline reservation system.

We hope this project will work fine & in near future we will do more work to improve this project.