Pdfcoffee - dfsdfdsffff fdsssssssssssss fsdddddddddd fsdddddddddddddddddd fdsfdsf weqw PDF

Preview

Summary

dfsdfdsffff fdsssssssssssss fsdddddddddd fsdddddddddddddddddd fdsfdsf weqw...

Description

AIRLINE RESERVATION SYSTEM

BY

KAAVYA KUPPA

Bachelor of Engineering, Jawaharlal Nehru Technological University, India, 2005

A REPORT

submitted in partial fulfillment of the requirements for the degree of

MASTER OF SOFTWARE ENGINEERING

Department of Computing and Information Sciences College of Engineering

KANSAS STATE UNIVERSITY Manhattan, Kansas 2008 Approved by: [Major Professor] Dr. Daniel Andresen

1

ABSTRACT The objective of the project is to design an Airline Reservation System application which enables the customers to search and book flights, packages and hotels. The project has been designed in C#.NET technology and consists of a SQL server which acts as the database for the project. My motivation for the project came from my enthusiasm and strong urge to learn C# and .NET which is one of the fastest growing technologies in today’s world. The Airline Reservation System project mainly consists of two types of users. The customers who access the information provided by the website and the administrator who modifies and updates the information available in the website. All the data needed for the application is stored in the form of tables in the SQL server 2000. The report contains the details of all the tasks carried out during the entire software development life cycle of the Airline Reservation Project. This document depicts all the details of the project starting from the project design to testing.

2

Table of Contents

List of Figures................................................................................................................................. 9 List of Tables ................................................................................................................................ 11 List of Tables ................................................................................................................................ 11 Acknowledgements....................................................................................................................... 12 Dedication ..................................................................................................................................... 13 CHAPTER 1 - VISION DOCUMENT......................................................................................... 14 1. INTRODUCTION ................................................................................................................ 14 1.1 PURPOSE AND MOTIVATION....................................................................................... 14 1.2 PROJECT OVERVIEW ..................................................................................................... 14 .1.3 REFERENCES .................................................................................................................. 14 2. OVERALL PRODUCT DESCRIPTION ............................................................................. 15 2.1 PRODUCT PERSPECTIVE............................................................................................... 15 2.2 PRODUCT FEATURES..................................................................................................... 15 2.2.1 Customer / End user activities ..................................................................................... 15 2.2.2 Administrator Activities............................................................................................... 17 2.3 USER CHARACTERISTICS............................................................................................. 18 2.4 CONSTRAINTS................................................................................................................. 18 2.5 ASSUMPTIONS AND DEPENDENCIES ........................................................................ 19 3. SPECIFIC REQUIREMENTS ............................................................................................. 19 3.1 EXTERNAL INTERFACES .............................................................................................. 19 3.1.1 USER INTERFACE .................................................................................................... 19 3.1.3 SOFTWARE INTERFACE ......................................................................................... 20 4. FUNCTIONAL REQUIREMENTS..................................................................................... 20 4.1 Use Case name: User Registration...................................................................................... 21 4.2 Use Case name: User Login................................................................................................ 21 4.3 Use Case name: Contact the company................................................................................ 21 4.4 User Case name: Booking Instructions............................................................................... 22 4.5 Use Case name: Book Flights............................................................................................. 22

3

4.6 Use Case name: Book Motel .............................................................................................. 22 4.7 Use Case name: Booking Packages.................................................................................... 23 4.8 Use Case name: Login/Logout ........................................................................................... 23 4.9 Use Case name: Add/Delete or Modify Customer information ......................................... 23 4.10 Use Case name: Add/Delete or Modify flight information .............................................. 24 4.11 Use Case name: Cancellation of Reservations ................................................................. 24 4.12 Use Case name: E-mail confirmations.............................................................................. 24 4.13 Use Case name: Modifying details of webpage................................................................ 25 4.14 Use Case name: Add/Delete or Modify Motel information ............................................. 25 4.15 Use Case name: Add/Delete or Modify package information .......................................... 25 5. PERFORMANCE REQUIREMENTS................................................................................. 26 CHAPTER 2 - PROJECT PLAN.................................................................................................. 27 1. TASK BREAKDOWN ......................................................................................................... 27 1.1 INCEPTION PHASE.......................................................................................................... 27 1.2 ELABORATION PHASE .................................................................................................. 27 1.3 PRODUCTION PHASE ..................................................................................................... 28 2. COST ESTIMATE ............................................................................................................... 29 2.1 COCOMO MODEL............................................................................................................ 29 2.2 GANTT CHART ................................................................................................................ 32 3. ARCHITECTURE ELABORATION PLAN ....................................................................... 32 3.1 REVISE VISION DOCUMENT ........................................................................................ 32 3.2 REVISE PROJECT PLAN ................................................................................................. 33 3.3 ARCHITECTURE DESIGN .............................................................................................. 33 3.4 DEVELOPING PROTOTYPE ........................................................................................... 33 3.5 TEST PLAN ....................................................................................................................... 33 3.6 FORMAL TECHNICAL INSPECTORS ........................................................................... 33 3.7 FORMAL REQUIREMENTS SPECIFICATION ............................................................. 33 CHAPTER 3 - ARCHITECTURE DESIGN................................................................................ 34 1. INTRODUCTION ................................................................................................................ 34 2. ARCHITECTURE OF THE AIRLINE RESERVATION SYSTEM................................... 34 3. PRESENTATION TIER....................................................................................................... 36

4

4. BUSINESS LOGIC TIER .................................................................................................... 38 4.1 CLASS DIAGRAM............................................................................................................ 39 4.2 SEQUENCE DIAGRAM ................................................................................................... 39 5. DATABASE TIER ............................................................................................................... 40 CHAPTER 4 - INSPECTION CHECKLIST................................................................................ 41 1. INTRODUCTION ................................................................................................................ 41 2. ITEMS TO BE INSPECTED ............................................................................................... 41 3. FORMAL TECHNICAL INSPECTORS ............................................................................. 41 4. FORMAL TECHNICAL INSPECTION CHECKLIST....................................................... 41 CHAPTER 5 - FORMAL REQUIREMENTS SPECIFICATION............................................... 43 CHAPTER 6 - COMPONENT DESIGN ..................................................................................... 47 1. INTRODUCTION AND PURPOSE .................................................................................... 47 2. CLASS DIAGRAM.............................................................................................................. 47 2.1 CLASS DESCRIPTIONS................................................................................................... 48 2.1.1 USER ........................................................................................................................... 48 2.1.2 ADMINISTRATOR .................................................................................................... 48 2.1.3 CUSTOMER................................................................................................................ 49 2.1.4 PACKAGE................................................................................................................... 50 2.1.5 FLIGHT ....................................................................................................................... 50 2.1.6 HOTEL ........................................................................................................................ 51 CHAPTER 7 - SOFTWARE QUALITY ASSURANCE PLAN ................................................. 52 1. PURPOSE............................................................................................................................. 52 2. REFERENCE DOCUMENTS.............................................................................................. 52 3. MANAGEMENT.................................................................................................................. 52 3.1 ORGANIZATION .............................................................................................................. 52 3.2 RESPONSIBILITIES ......................................................................................................... 53 3.3 TASKS................................................................................................................................ 54 4. DOCUMENTATION ........................................................................................................... 54 5. STANDARDS, PRACTICES, CONVENTIONS AND METRICS .................................... 54 6. REVIEWS AND AUDITS ................................................................................................... 55 7. TEST AND PROBLEM REPORTING................................................................................ 55

5

8. TOOLS, TECHNIQUES AND METHODOLOGIES.......................................................... 56 9. RECORDS COLLECTION, MAINTENANCE AND RETENTION ................................. 56 10. DELIVERABLES............................................................................................................... 56 CHAPTER 8 - TEST PLAN ......................................................................................................... 58 1. TEST PLAN IDENTIFIER .................................................................................................. 58 2. INTRODUCTION ................................................................................................................ 58 2.1 OBJECTIVES..................................................................................................................... 58 2.2 REFERENCES ................................................................................................................... 58 2.3 DEFINITIONS.................................................................................................................... 59 3. TEST ITEMS........................................................................................................................ 59 4. APPROACH ......................................................................................................................... 59 4.1 UNIT TESTING ................................................................................................................. 60 4.2 INTEGRATION TESTING................................................................................................ 60 4.3 REGRESSION TESTING .................................................................................................. 60 4.4 ACCEPTANCE TESTING................................................................................................. 61 4.5 SYSTEM TESTING ........................................................................................................... 61 5. TEST CASES ....................................................................................................................... 61 5.1 TEST CASE 1 – USER LOGIN ......................................................................................... 61 5.2 TEST CASE 2 – USER REGISTRATION ........................................................................ 61 5.3 TEST CASE 3 – USER REGISTRATION ........................................................................ 62 5.4 TEST CASE 4 – SEARCH AND BOOK FLIGHTS ......................................................... 62 5.5 TEST CASE 5 – SEARCH AND BOOK PACKAGES..................................................... 62 5.6 TEST CASE 6 – SEARCH AND BOOK HOTELS........................................................... 63 6. PASS OR FAIL CRITERIA ................................................................................................ 63 7. SUSPENSION CRITERIA AND RESUMPTION REQUIREMENTS............................... 63 7.1 SUSPENSION CRITERIA................................................................................................. 63 7.2 RESUMPTION REQUIREMENT ..................................................................................... 64 8. TEST DELIVERABLES ...................................................................................................... 64 CHAPTER 9 - ASSESSMENT EVALUATION ......................................................................... 65 1. INTRODUCTION ................................................................................................................ 65 2. TEST CASE RESULT SUMMARY.................................................................................... 65

6

3. DETAILED TEST RESULTS.............................................................................................. 66 3.1 MANUAL TESTING ......................................................................................................... 66 3.1.1 TC # 1 – USER LOGIN............................................................................................... 66 3.1.2 TC # 2 - USER REGISTRATION............................................................................... 66 3.1.3 TC # 3 – SEARCH AND BOOK FLIGHTS ............................................................... 67 3.1.4 TC # 4 – SEARCH AND BOOK PACKAGES........................................................... 68 3.1.5 TC # 5 - SEARCH AND BOOK HOTELS................................................................. 68 3.1.6 TC # 6 - ADMINISTRATOR SIGN IN ...................................................................... 69 3.1.7 TC # 7 – NEW FLIGHT/PACKAGE/HOTEL ADDITION ....................................... 70 3.1.8 TC # 8 – UPDATING FLIGHT, PACKAGE, MOTEL DETAILS ............................ 70 3.2 PERFORMANCE TESTING ............................................................................................. 71 3.2.1 Home page of Airline Reservation System website..................................................... 72 3.2.2 Login Page of the Airline Reservation System............................................................ 74 3.2.3 Flight Search and booking page of the Airline Reservation System ........................... 75 4. OBSERVATIONS................................................................................................................ 76 CHAPTER 10 - USER MANUAL ............................................................................................... 81 1. INTRODUCTION ................................................................................................................ 81 2. INSTALLATION AND SETUP .......................................................................................... 81 2.1 REQUIRED HARDWARE ................................................................................................ 81 2.2 REQUIRED SOFTWARE.................................................................................................. 81 2.3 REQUIRED NETWORK CONFIGURATION ................................................................. 82 2.4 SOFTWARE SET-UP ........................................................................................................ 82 3. AIRLINE RESERVATION SYSTEM USAGE FOR CUSTOMERS................................. 88 3.1 REGISTER FEATURE ...................................................................................................... 88 3.2 FLIGHT SEARCH AND BOOKING ................................................................................ 90 3.3 HOTEL SEARCH AND BOOKING ................................................................................. 92 3.4 PACKAGE SEARCH AND BOOKING............................................................................ 95 CHAPTER 11 - PROJECT EVALUATION ................................................................................ 98 1. INTRODUCTION ................................................................................................................ 98 2. PROBLEMS ENCOUNTERED........................................................................................... 98 2.1 SOLUTION DOMAIN RESEARCH AND LEARNING .................................................. 98

7

2.2 LEARNING ASP.NET AND C# LANGUAGE ................................................................ 98 2.3 SECURITY ISSUES........................................................................................................... 98 2.4 JMETER ....................................................................................................