PROJECT
ON
AIRLINE RESERVATION
      SYSTEM
       Submitted in partial fulfillment of the requirements
                 for the award of the degree of
           Master of Computer Application(MCA)
                    Session: 2008-2009
                      Submitted to:
       Department Of Computer Science & Application
              G.J.University,Hissar(Haryana)
                            By
                      SUMAN SAINI
                   RollNo.-06261119003
                      (MCA- VI sem.)
Under the supervision of:            Under the Guidance
of:
Lecturer of MCA department               (Project Engineer)
                            PREFACE
             It gives me immense to present my project “AIRLINE RESERVATION
      SYSTEM” in Microsoft Technology (ASP.NET 1.1, C#.NET, SQL SERVER 2000)
      under the Guidance of Mr. Sunil Sikka who was my professional training in charge.
              I express my sincere thanks to the company “Safforn.” who had given me the
       chance to serve and provide their system to make my project in a Systematic and
       professional way.
             I express my special thanks to Md. Ekram, who connected me with their project
      developing team from where I got lot of technical suggestions while making my project.
             Also I am thankful to their developing team, Staff members who helped me a lot
      with their experience and valuable suggestions.
                                                                Guide:
                                                                Mr. Sunil Sikka
                                                                Sr. Lecturer,
                                                                Zad Computers.
                                                                Rohtak-124001
Remarks:
                                     CONTENTS
   1. PROJECT PROFILE                                                                 1
        Introduction Of Project
        Features Of Project
        Advantages Of Project
  2. ABOUT SOFTWARE TECHNOLOGY                   8
        Introduction
        Overview of .Net Framework
        Microsoft.Net Features
        ADO.NET Architecture
        Introduction of SQL Server
        Introduction of C#
  3. PROBLEM FORMULATION                             34
           Problem Definition
           General Description
                User Problem Statement
                User Objectives & Goals
  4. SYSTEM STUDY                                    37
           Existing System
                Limitation Of Existing System
           Proposed System
                Features
                Benefits
        Feasibility Study
             Economy Feasibility
             Technical Feasibility
             Operational Feasibility
5. SYSTEM ANALYSIS                                   44
          Introduction
          User Requirement
          System Requirement
                 Hardware Requirement
                 Software Requirement
                  Performance Requirement
              DFD & E-R Diagram
6. SYSTEM DESIGN                               58
           Design Overview
           Design Goal
           Relational DB Design
           Physical DB Design
           Input Design
           Output Design
7. CODING                                      70
8. SYSTEM TESTING                              74
           Overview Of Testing Process
           Objective Of Testing
           Testing Procedures
9. IMPLEMENTATION                              79
           Overview
           Implementation Tools
           System Maintenance
10. USER MANUAL                                84
11. CONCLUSION                                 87
           Conclusion
           Merit Of Project
           Limitation Of Project
12. SCOPE OF PROJECT                           90
          Limitation of Project
          Future Scope of Project
13. SCREEN SHOTS                               93
14. REFERENCES & BIBLIOGRAPHY                  109
                                 CERTIFICATE
       This is to certify that Ms. SUMAN SAINI , Enrollment No. 06261119003 has worked
under my supervision to prepare her project report on “Airline Reservation System”. The work
embodied in this report is original and was conducted at Noida from 8th Jan 2009 to 10th June
2009. The work has not been submitted in part or full to this or any other university for the award
of any degree or diploma. She has completed all requirements of MCA ordinance.
       Date:                                         Signature of Supervisor
                                                     Name: Mr. Sunil Sikka
                                                     Designation: Sr. Lecturer
                                                     Organization: ZAD Institute
                                ACKNOWLEDGEMENT
       I would like to express my sincere thanks to my project head         Md. Ekram for his
endeavor help and cooperation in completion of this project. He constantly encouraged me with
his valuable suggestions throughout the project life cycle.
       I also like to thank faculty members of my institute for their kind interest at various
points to follow the project life cycle. I also thank my colleagues of training organization and
institution for their valuable help and cooperation whenever I needed.
                                                                           Suman saini