Chapter-1: Introduction
1
Description of Organisation The OVERSEAS TRAVELS company is one of the Airline Reservation Company in India. It has numer of ranches! "hich are spread over the country or the "orld. So person "ants to reserve his#her tic$et and he#she has to contact at nearest Overseas Travel Travelss ranch ranch.. The The Airlin Airlinee Reserv Reservatio ation n System System %ARS& %ARS& provid provides es an interfa interface ce to schedule fli'hts and reservations for an airline that services. Its responsiility is to $eep trac$ of system users! customers! Airus information! fli'ht information and cancellation. The functionality of the ARS is ro$en into various primary 'roups.
Customer reservation information and user "ere added! deleted and updated in the implementation phase to account for the "ay "e decide to implement security. (ser $eeps trac$ of the username! pass"ord information and customer reservation information lin$ provides a lin$ et"een the customers) reservation information and lo'in tale.
*rom the very e'innin' human ein' used to search for fli'ht. After a
lon' research human ein' has discovered fli'ht that has ecome a part of OVERSEAS +roup)s life.
+radually lly the airlin airlinee "itnes "itnessed sed ne" route route additio additions! ns! increas increased ed fli'ht fli'ht +radua fre,uencies and passen'er lists. Today OVERSEAS TRAVELS -VT. LT. To offe offerr passe passen' n'er er the the very very est est in the the s$ie s$ies! s! OVERSEAS OVERSEAS GROUP GROUP constantly up'rades its in/fli'ht facilities.
0
Description of Organisation The OVERSEAS TRAVELS company is one of the Airline Reservation Company in India. It has numer of ranches! "hich are spread over the country or the "orld. So person "ants to reserve his#her tic$et and he#she has to contact at nearest Overseas Travel Travelss ranch ranch.. The The Airlin Airlinee Reserv Reservatio ation n System System %ARS& %ARS& provid provides es an interfa interface ce to schedule fli'hts and reservations for an airline that services. Its responsiility is to $eep trac$ of system users! customers! Airus information! fli'ht information and cancellation. The functionality of the ARS is ro$en into various primary 'roups.
Customer reservation information and user "ere added! deleted and updated in the implementation phase to account for the "ay "e decide to implement security. (ser $eeps trac$ of the username! pass"ord information and customer reservation information lin$ provides a lin$ et"een the customers) reservation information and lo'in tale.
*rom the very e'innin' human ein' used to search for fli'ht. After a
lon' research human ein' has discovered fli'ht that has ecome a part of OVERSEAS +roup)s life.
+radually lly the airlin airlinee "itnes "itnessed sed ne" route route additio additions! ns! increas increased ed fli'ht fli'ht +radua fre,uencies and passen'er lists. Today OVERSEAS TRAVELS -VT. LT. To offe offerr passe passen' n'er er the the very very est est in the the s$ie s$ies! s! OVERSEAS OVERSEAS GROUP GROUP constantly up'rades its in/fli'ht facilities.
0
Epandin' the net"or$ as a part of its epansion schedule! OVERSEAS
+roup has collaorated "ith several international 2 domestic carries to offers its passen'er)s convenience all the "ay.
OVERSEAS AS +roup) +roup)ss cre" and staff staff are "ell "ell trained trained to attend attend to all OVERSE passen'er)s needs al"ays and in OVERSEAS +roup)s efforts to provide passen'er "ith eclusive care and comforts all the "ay.
3
Data Collection
A fact 'atherin' study "as underta$en to study the activities involved in the various aspect of the eistin' computeri4ed system. 5e had visited various person of the company. The eistin' system "as studied y means of Intervie"s Record Revie"s Intervie"s6 (ser intervie"s "ere conducted to retrieve the ,ualitative information. These intervie"s! "hich "ere unstructured! provided opportunity to 'ather information from the respondents "ho involved in the process for a lon' time.
These intervie"s provided information such as6
Activities involved in process of reservation processin' involvin' fare! other
services! fli'ht information! fli'ht schedule information! airus! various reports are 'enerated usin' eistin' system. Type 2 fre,uency of forms and reports. Limitation of Eistin' system.
Record Revie"s6 7
To 'ather details aout the Airlines Reservation! many $inds of records 2 reports "ere revie"ed. This study covered.
Standard Operatin' -rocedure. *orms and reports 'enerated y eistin' manual system. ocument flo" %Input # Output& of the system.
HARDWARE AND SOFTWARE CONFIGURATION
The 8ard"are and Soft"are Confi'uration for the proposed system is 'iven elo". 8ard"are Confi'uration6/ *or the successful run of the proposed system the re,uired stand alone -ersonal Computer "ith! minimum hard"are re,uired to run the system is as elo".
8ard"are
9inimum Re,uirement
-rocessor
-entium 0
8ard dis$
7 +:
RA9
;7 9:
ot 9atri -rinter
1; -in
<
Soft"are Confi'uration6/
The minimum Soft"are re,uired y the system is follo"s.
1. ORACLE as :ac$ End. 0.
Visual :asic ;.= as *ront End
The reason for selectin' ORACLE and Visual :asic as tools are as follo"s. *eatures of ORACLE 6 / It is a hi'h performance! full tolerant relational dataase mana'ement System especially desi'ned for lar'e dataase application. It offers follo"in' enefits6 It eliminates all parent/child relationships and instead represented all
data in the dataase as simple ro"#column tales of data values. *leiility in data modelin'. Easy for accessin' data. Each tale is an independent entity and there is no physical
relationship et"een tales. Reduce data stora'e and redundancy. Independent of physical stora'e and lo'ical data desi'n. It has "ide level data manipulation lan'ua'e %S>L&. 9ost data mana'ement system ased on the relational model has a
uilt/in support for ,uery lan'ua'es li$e A?SI S>L or >:E %>uery :y
;
Eample&. These ,ueries are simple En'lish constructs that allo" adhoc data manipulation from a tale. eferred "ritin' at commits to improve transaction performance. Security and control. It has a rollac$ command for recreatin' the dataase to its most recent
safe point. +rant and revo$e limits access to information do"n to ro" and column level. Vie"s are valuale features for limitin' access to the primary tac$les in the dataase. -rofessional ORACLE starts the :9S %ataase 9ana'ement
System& in the etended memory! so more main memory is availale for other applications. Relational model of data mana'ement is ased on set theory. :uilt/in
,uery lan'ua'e is desi'ned in the R:9S! so that it can manipulate sets of data %one or more tuples&. (ser interface used "ith relational models is non/procedural ecause
only "hat needs to e done is specified and not ho" it has to e done. (sin' any of the other methods! you have not only to specify "hat need to e done ut ho" it has to e done as "ell.
@
*eatures of Visual :asic ;.= 6 / Visual :asic provides complete set of tools to simplify rapid application evelopment. It provides a vital lin$ to 'raphical environment and allo"s you to
develop applications ased on standard "indo"s features6 ialo' oes! Command uttons! -ull do"n menus! Scroll :ars! Selection lists etc. It also allo"s creatin' roust applications that fully ma$e use of the 'raphical user interface. Active ata OBects %AO& and OLE : replace the Open dataase
connectivity %O:C& A-I as the preferred method for a ccessin' shared file and client#server dataases. Internet techni,ues such as ynamic 8T9L %89L&! Etensile
mar$up lan'ua'e %9L&! Active server pa'es %AS-& and Active documents offer ro"ser/ased alternatives for displayin' and updatin' data. Etensions to Visual :asic class modules assist in "ritin' middle/tier
LLs for 9icrosoft transaction server 0.=. A multitude of "i4ards and other 'raphical tools aid developers ne" to
Visual :asic. Visual :asic is an event driven pro'rammin' lan'ua'e.
Visual :asic allo"s you to adopt more of parallel approach! "ith
independent sections of code for each option that the user may select. This is $no"n as Event driven pro'rammin' lan'ua'e. ata Environment esi'ner %E&. ra' and drop form 'eneration. ata vie" "indo". AO ata Control %AOC&. AO/compliant data/ound controls. 8ierarchical record sets and the *le +rid Control. ata report desi'n. ata form "i4ards. *ormat oBects. ata repeater control. ata source classes and data uildin'. 9TS transaction 9ode property of Class modules. Visual data tools %VTS&. S>L editor. Component creation. Lan'ua'e. -ac$a'in' and eployment "i4ard. The inte'rated development environment. ata oBect "i4ard.
D
Chapter-2: System Analysis
1=
INTRODUCTION TO EISTING S!STE"
The Company follo"s a manual system for maintainin' the Airline Reservation System.
5henever any re,uisition comes to the Counter to issue a tic$et the firstly the
Tic$et Capacity chec$ed "hether the re,uired ,uantity of the tic$et is present or not. If the re,uired tic$ets is present then issue a tic$et and update the reservation information and an entry is done to the Tic$et Issue Re'ister.
The day/to/day entries are made manually into the oo$ that has 'otten all the
relevant entries.
Chec$ the Tic$et >uantity re'ularly "hether any tic$et is not in! if so then
Tic$et Issue process is cancelled. In the same "ay Tic$et cancellation is
11
follo"ed. If *are is increased or decreased then chan'es into *are :oo$. If ?e" *li'ht is introduced then entry on relevant oo$! that process applies to *li'ht/Schedule! Airus! and :ranch.
At the end of the year or "hen an intermediate report is needed then prepare
the report is re,uired.
#I"ITATIONS OF THE EISTING S!STE"
The Eistin' system includes prolems li$e lac$ of time consumin'! accuracy! hi'h cost! security prolems! etc. There are many prolems in eistin' systems li$e6 Time and speed 9an po"er 8i'h cost Security Compleity 9aintenance Accuracy Storin'
10
Records mi'ht 'et lost or e insufficient due to manual errors. 9aintainin' and mana'in' data is very costly and time consumin'!
ecause there are many documents that have to e maintained y each ranch and copies have to e transferred to relative ranches. Transfer of information "ithin the ranches is costly and time
consumin'.
INTRODUCTION TO PROPOSED S!STE"
There are many activities that can e computeri4ed in this "idely spread or'ani4ation. The current contet is related to maintain the tic$et Reservation/Cancel tic$et. The important reason is to ma$e/"or$ easy. ?o need to search a *li'ht re'ister for entry or any other transaction.
Computeri4ation of this must fulfilled the re,uirements of "or$in' staff due to effective "or$ of computer in terms of efficiency! speed! accuracy! stora'e capacity and ,uic$ness.
Even thou'h it is costly! it is recommended the computeri4ation of the tic$et issue process.
13
O$%ECTIVES OF PROPOSED S!STE"
9anual "or$ has to e reduced. +et accuracy. Result to e received very ,uic$ly. It uses concept of user friendliness. It provides usin' of multiple applications at a time. Increase security! speed! storin' and accurac y. Customer services can not only e satisfied ut also enhanced to the etent
that one can otain or cancel a reservation from any ranch for any route at any 'iven time. To speed up the operation. 9ana'in' and maintainin' data ecomes easier. -rovide convenience to travelers. It decreases manpo"er and hi'h cost.
FEATURES OF PROPOSED S!STE"
9anual "or$ has to e reduced and Result to e received ,uic$ly.
To speed up the operation and ecrease manpo"er! hi'h cost.
Increase security! speed! storin' and accuracy.
17
The customers have to face only one person at the oo$in' counter for
otain the reservation. 9ana'in' and maintainin' data ecomes easier and cost effective due to
very hi'h amount and reliaility of stora'e space availale in the proposed system.
It provides support for ,ueries throu'h out all the ranches at any 'iven
time at a very hi'h speed! savin' a lot of time. The system has een developed under "icrosoft Vis&al $asic '() as a
*ront/End tool and Oracle *() as a :ac$/End tool.
ADVANTAGES OF PROPOSED S!STE"
The proposed system due to computeri4ed is much faster in reservation
process! cancellation process and transactions. Transfer of information from various ranches "ould ecome easier and
faster. 9ana'in' and maintainin' data ecomes easier and cost effective due to very
hi'h amount and reliaility of stora'e space availale in the proposed system.
1<
Customer services can not only e satisfied ut also enhanced to the etent
that one can otain or cancel a reservation from any 'iven time.
#I"ITATIONS FOR PROPOSED S!STE"
The main limitation of system is if any plane that not stop in a particular
destination that have not een included in airline reservation system. -er tic$et only one other services are included at a time. -assen'er cannot transfer his#her reservation from one fli'ht to another
fli'ht.
TA$#E DESIGN Tale desi'n contains all the tales re,uired to store the re,uired information "hich are stated elo"6
1. TABLE NAME: AIRBUS
Fiel+s Airusno *irstcap :uscap Ecocap *irst"lcap
Data T,pe Varchar0 ?umer ?umer ?umer ?umer
Si-e %<& %3& %3& %3& %3&
1;
:us"lcap Eco"lcap
?umer ?umer
%3& %3&
Data T,pe Char Varchar0 ?umer ?umer ?umer
Si-e %@& %<& %& %& %&
2. TABLE NAME: FARE
Fiel+s Routecode Airusno *irstfare :usfare Ecofare
3. TABLE NAME: SERVICE
Fiel+s Sscode Ssdesc Ssfare
Data T,pe Char Varchar0 ?umer
Si-e %7& %1<& %<&
4 . TABLE NAME : CONTROL Fiel+s Airta Ecess'limit *irst'limit :us'limit Eco'limit Cancdeduc10 Cancdeduc; Cancdeduc3
Data T,pe ?umer ?umer ?umer ?umer ?umer ?umer ?umer ?umer
Si-e %7& %3& %3& %3& %3& %3& %3& %3&
5. TABLE NAME: CANCELLATION
Fiel+s
Data T,pe
Si-e
1@
-?R *li'htno *li'htdate Class Reservdate -assname -assadd -assportno Sscode Canceldate Totalfare :ranchcode Routecode Totfare *li'httype -assstatus Cancamt
?umer Varchar0 ate Char ate Varchar0 Varchar0 ?umer Varchar0 ate ?umer Varchar0 Char ?umer Char Varchar0 ?umer
%<& %@&
Data T,pe Varchar0 Varchar0 Varchar0 Varchar0 ?umer
Si-e %7& %0=& %0=& %1<& %&
%1& %0=& %1==& %& %7& %!0& %7& %@& %!0& %1& %1<& %!0&
6. TABLE NAME: BRANCH Fiel+s :ranchcode Add1 Add0 City Telephone
7. TABLE NAME: RESERVATION
Fiel+s -?R *li'htno *li'htdate Class Reservdate -assname -assadd -assportno Sscode -assstatus Routecode Totalfare :ranchcode
Data T,pe ?umer Varchar0 ate Char ate Varchar0 Varchar0 ?umer Varchar0 Char Char ?umer Varchar0
Si-e %<& %@&
%1& %0=& %1==& %& %7& %1<& %@& %!0& %7& 1
*li'httype Totfare Cancfla'
Char ?umer Char
%1& %!0& %1&
Data T,pe Varchar0 ate ?umer ?umer ?umer
Si-e %@&
Data T,pe Varchar0 Varchar0
Si-e %1<& %1<&
8. TABLE NAME: FLIGHT
Fiel+s *li'htno *li'htdate *irst$seats :us$seats Eco$seats
%3& %3& %3&
9. TABLE NAME: LOGIN
Fiel+s (serid -ass"ord
10. TABLE NAME: FLIGHT_SCH
Fields
*li'htno Airusno Airusnm Routecode eprttime Fourneyhrs *li'htday1 *li'htday0
Data T,pe
Si-e
Varchar0 Varchar0 Varchar0 Varchar0 Char Char ?umer ?umer
%@& %<& %0=& %@& %<& %<& %1& %1&
11. TABLE NAME: ROUTE
1D
Fiel+s Routecode Routedesc Ori'in estination
Data T,pe Varchar0 Varchar0 Varchar0 Varchar0
Si-e %@& %0<& %1<& %1<&
0=
Chapter-3: Systems Requirement Specifcation (SRS)
DATA F#OW DIAGRA"
As information moves throu'h soft"are! it is modified y a series of transformations. A ata *lo" ia'ram %*& is a 'raphical techni,ue that depicts information flo" and the transformations that are applied as data move from input to output. The data flo" dia'ram is $no" as a data flo" 'raph or a ule chart.
01
The ata *lo" ia'ram may e used to representation a system or soft"are at any level of astraction. In fact! *s may e used partitioned into levels that represent increasin' information flo" and functional detail. Therefore! the * provides a mechanism for functional modelin' as information flo" modelin'.
The ata *lo" ia'ram %*& serves t"o purposes6
1& To provide an indication of ho" data are transformed as they move throu'h the system and 0& To depict the functions that transform the data flo". The * provides additional information that is used durin' the analysis of the information domain and serves as a asis for the modelin' of function.
A Level = * also called as fundamental system model or a contet model! represents the entire soft"are element as a sin'le ule "ith input and output data indicated y incomin' and out'oin' arro"s respectively. Additional processes and information flo" paths are represented as the level = is partitioned to reveal details. Each of the proves represents at level 1 is su function of the overall system depicted in the contet model. Each of the process may e refined are layered to depict more
00
detail. Information continuity must e maintained in every layer! that is input and output to each refinement must remain the same.
CONTEXT
DIAGRAM
FOR
AIRLINE
RESERVATION
SYSTEM
Request for flight availability
ASS!"#!R
03
AIRLI?E RESERVATIO?
Verification reply & tickets
Reservation particulars
SGSTE9
Acknowledgeme nt (availability of seats available or not)
$%%&I"# %''IC!R
1-LEVEL DATA FLOW DIAGRAM
Flight Retrieve
ASSENGER
#nquiry
fli'ht details
Reservation file Flight information Airbus information
Add new details
ASSENGER oney! visa & passport "icket
07
*' Verify availability of seats
"icket! visa & passport
ancel passenger information
' Reservation process
Retrieve flight schedule information
Airbus
Fare information
Flight$sch
Route information
%' ancellation process
,elete Retrieve passenger passenger information details
Fare Route
+' Report generation
-assenger details
Reservation file
Re ort
ancellation
2!LEVEL "IAGRAM FOR ROCESS 2.0
oney ASSENGER
Add information about passenger
oney! visa & passport
ASSENGER
* ,omestic flight reservation process 0<
.nternational flight reservation process
Reservation file
Reservation file Request for other services ASSENGER
Add information about passenger
Add + information "icket reservation process
% Registration of other service process
/ther service details
Add information of other services
0ervice file
Reservation file
2!LEVEL ROCESS FOR ROCESS 3.0
#nquiry for cancellation process
ancel or invalid
ancellation
%*
heck for valid information
heck validity process
Add cancel information % "icket cancel process
ancel within %!1 or * days
,elete 0; -assenger information
control Reservation file
0@
DATA DICTIONAR!
ata ictionary is a store of information aout the data in dataase. The dictionary defines the name! description! source of data! users of data! and $ey"ords in data! formula to derive the data! specification and such other details. ata dictionary rin's common understandin' of the data in the or'ani4ation. R:9S provides soft"are to create the dictionary. (se of data dictionary enforces the standards of processin'! usa'e)s application and documentation in the or'ani4ation.
ata ictionaries are an inte'ral component of structured analysis! since data flo" dia'ram y them do not fully descrie the information aout the system. The data dictionary provides additional information aout the system.
A data dictionary is a catalo'ue H a repository H of the elements in a system. These elements center on data the "ay they are structured to meet user re,uirements and or'ani4ation needs. In a data dictionary! a list of all the elements composin' the data flo"in' throu'h a system is included. If a proBect team memer "ants to $no" the definition of a data item name or the contents of a particular data flo"! the information "ill e availale in the data dictionary. escriptions of all data used in the system are 'iven in a data dictionary.
0
Anal,sts &se Data Dictionar, for fi.e i/portant reasons(
1& To mana'e the detail in lar'e systems. 0& To communicate a common meanin' for all system elements. 3& To document the features of the system. 7& To facilitate analysis of the details in order to evaluate characteristics and determine "here system chan'es should e made. <& To locate errors and omissions in the system.
0D
Data Dictionar, 01 1.# Ta2le Na/e
0 AIR$US
escription
6 This tale stores Airus Information
-rimary ey
6 Airusno
*orei'n ey
6
/
Sr No 1
Fiel+s
Data T,pe
Si-e
Constraints
Description
Airusno
Varchar0
%<&
-rimary ey
0 3
*irstcap :uscap
?umer ?umer
%3& %3&
?OT ?(LL ?OT ?(LL
7
Ecocap
?umer
%3&
?OT ?(LL
<
*irst"lcap
?umer
%3&
;
:us"lcap
?umer
%3&
@
Eco"lcap
?umer
%3&
Airus no start "ith JAIK *irst Class Capacity :usiness Class Capacity Economic Class Capacity *irst Class)s 5aitin' List Capacity :usiness Class)s 5aitin' List Capacity Economic Class)s 5aitin' Capacity
2.# T$%&' N$('
: FARE
,escription
2 "his table stores Fare .nformation
-rimary 3ey
2
Foreign 3ey
2 Airbus (Airbusno) ! Route(Route$code)
4
Sr No 1
Fiel+s
Data T,pe
Si-e
Constraints
Description
Routecode
Char
%@&
*li'ht)s Route Code
0
Airusno
Varchar0
%<&
3 7 <
*irstfare :usfare Ecofare
?umer ?umer ?umer
%& %& %&
Composite primary ey Composite primary $ey ?ot ?ull ?ot ?ull ?ot ?ull
Airusno *irst Class *are :usiness Class *are Economic Class *are
3=
3.# T$%&' N$(' : SERVICE ,escription 2 "his table 0tores 0ervice .nformation -rimary 3ey 2 ss$code Foreign 3ey 2 Sr No 1 0 3
4
Fiel+s
Data T,pe
Si-e
Constraints
Description
Sscode Ssdesc Ssfare
Char Varchar0 ?umer
%7& %1<& %<&
-rimary ey ?ot ?ull ?ot ?ull
Service Code Service escription Service *are
4.# T$%&' N$(' : CONTROL ,escription 2 "his table 0tores ontrol .nformation -rimary 3ey 2 4 Foreign 3ey 2 4
Sr No 1 0 3 7
Fiel+s
Data T,pe
Si-e
Constraints
Description
Airta Ecess'limit *irst'limit :us'limit
?umer ?umer ?umer ?umer
%7& %3& %3& %3&
?ot ?ull ?ot ?ull ?ot ?ull ?ot ?ull
<
Eco'limit
?umer
%3&
?ot ?ull
;
Cancdeduc10
?umer
%3&
?ot ?ull
@
Cancdeduc;
?umer
%3&
?ot ?ull
Cancdeduc3
?umer
%3&
?ot ?ull
*ied Air Ta -er Etra :a' char'e *irst Class)s :a' Limit :usiness Class)s :a' Limit Economic Class)s :a' Limit Cancel deduction char'e for @/10 days Cancel deduction char'e for 7/; days Cancel deduction char'e for =/3 days
31
5.# T$%&' N$(' : CANCELLATION ,escription 2 "his table 0tores ancelled "icket .nformation -rimary 3ey 2 4 Foreign 3ey 2 Reservation (-5R)! Flight$sch (Flight$no)! 6ranch(6ranch$code)! 0ervice(ss$code)! Route(Route$code) Sr No 1
Fiel+s
Data T,pe
Si-e
Constraints
Description
-?R
?umer
%<&
?ot ?ull! *
0
*li'htno
Varchar0
%@&
?ot ?ull! *
3 7
*li'htdate Class
ate Char
%1&
?ot ?ull
<
Reservdate
ate
; @
-assname -assadd -assportno
Varchar0 Varchar0 ?umer
%0=& %1==& %&
?ot ?ull ?ot ?ull ?ot ?ull
D
Sscode
Varchar0
%7&
*
1= 11 10
Cancamt Totalfare :ranchcode
?umer ?umer Varchar0
%!0& %!0& %7&
/ ?ot ?ull *
13
*li'httype
Char
%1&
?ot ?ull
17
-assstatus
Char
%1&
1< 1; 1@
Routecode Totfare Canceldate
Char ?umer ate
%@& %!0&
-?R for Reservation Tic$et *li'htno from *li'htsch tale *li'ht ate information Class)s Areviation *) for *irst Class! ):) for :usiness Class! )E) for Economic Class Tic$et)s Reservation ate -assen'er)s ?ame -assen'er)s Address -assen'er)s -assport ?o Service code from service tale Cancel amount Total *are :ranch code from :ranch Tale *li'ht type Areviation I) for International! )) for omestic fli'ht -assen'er)s status 5) for "aitin'! )C) for Confirm *li'ht)s route code Total amount Cancellation date
?ot ?ull
?ot null! * ?ot null ?ot null
30
6# T$%&' N$(' : RESERVATION ,escription 2 "his table 0tores "icket Reservation .nformation -rimary 3ey 2 -5R Foreign 3ey 2
Flight$sch(Flight$no)!6ranch(6ranch$code)! 0ervice(ss$code)! Route(route$code)
Sr No 1
Fiel+s
Data T,pe
Si-e
Constraints
Description
-?R
?umer
%<&
?ot ?ull! *
0
*li'htno
Varchar0
%@&
?ot ?ull! *
3 7
*li'htdate Class
ate Char
%1&
?ot ?ull
<
Reservdate
ate
; @ D
-assname -assadd -assportno Sscode
Varchar0 Varchar0 ?umer Varchar0
%0=& %1==& %& %7&
?ot ?ull ?ot ?ull ?ot ?ull *
1= 11 10
Cancfla' Totalfare :ranchcode
Char ?umer Varchar0
%1& %!0& %7&
/ ?ot ?ull *
13
*li'httype
Char
%1&
?ot ?ull
17
-assstatus
Char
%1&
1< 1;
Routecode Totfare
Char ?umer
%@& %!0&
-?R for Reservation Tic$et *li'htno from *li'htsch tale *li'ht ate information Class)s Areviation *) for *irst Class! ):) for :usiness Class! )E) for Economic Class Tic$et)s Reservation ate -assen'er)s ?ame -assen'er)s Address -assen'er)s -assport ?o Service code from service tale Cancel amount Total *are :ranch code from :ranch Tale *li'ht type Areviation I) for International! )) for omestic fli'ht -assen'er)s status 5) for "aitin'! )C) for Confirm *li'ht)s route code Total amount
?ot ?ull
?ot null! * ?ot null
33
7# T$%&' N$(' : BRANCH ,escription 2 "his table 0tores 6ranch .nformation -rimary 3ey 2 6ranch$code Foreign 3ey 2 4
Sr No 1 0 3 7 <
Fiel+s
Data T,pe
Si-e
Constraints
Description
:ranchcode Add1 Add0 City Telephone
Varchar0 Varchar0 Varchar0 Varchar0 ?umer
%7& %0=& %0=& %1<& %&
-rimary ey ?ot ?ull
:ranch Code :ranch)s Address1 :ranch)s Addess0 :ranch)s City :ranch)s Telephone no
?ot ?ull
8.# T$%&' N$(' : FLIGHT ,escription 2 "his table 0tores Flight .nformation -rimary 3ey 2 4 Foreign 3ey 2 Flight$sch(Flight$no)
Sr No 1 0 3
Fiel+s
Data T,pe
Si-e
Constraints
Description
*li'htno *li'htdate *irst$seats
Varchar0 ate ?umer
%@&
*! ?ot ?ull
7
:us$seats
?umer
%3&
<
Eco$seats
?umer
%3&
*li'ht ?umer *li'ht ate *irst Class)s oo$in' seats :usiness Class)s oo$in' seats Economic Class)s oo$in' seats
%3&
37
9.# T$%&' N$(' : FLIGHT_SCH ,escription 2 "his table 0tores Flight 0chedule .nformation -rimary 3ey 2 Flight$no Foreign 3ey 2 Airbus (Airbusno)! Fare (Route$code)
Sr No 1 0 3 7 < ; @
Fiel+s
Data T,pe
Si-e
Constraints
Description
*li'htno Airusno Airusnm Routecode eprttime Fourneyhrs *li'htday1 *li'htday0
Varchar0 Varchar0 Varchar0 Varchar0 Char Char ?umer ?umer
%@& %<& %0=& %@& %<& %<& %1& %1&
-rimary ey *! ?ot ?ull ?ot ?ull *! ?ot ?ull ?ot ?ull ?ot ?ull ?ot ?ull
*li'ht ?umer Airus ?umer Airus name *li'ht)s Route code eparture Time Fourney 8ours *li'ht ay1 *li'ht ay0
10.# T$%&' N$(' : ROUTE ,escription
2 "his table 0tores Route information
-rimary 3ey 2 Route$code Foreign 3ey 2
4
Sr No 1 0
Fiel+s
Data T,pe
Si-e
Constraints
Description
Routecode Routedesc
Char Varchar0
%@& %0<&
- ?ot null
3 7
Ori'in estination
Varchar0 Varchar0
%1<& %1<&
?ot null ?ot null
*li'ht)s Route code *li'ht)s Route description *li'ht)s ori'in *li'ht)s destination
3<
11.# T$%&' N$(' : LOGIN ,escription 2 "his table 0tores 7sername and -assword information -rimary 3ey 2 7ser$id Foreign 3ey 2 4 Sr No 1 0
Fiel+s
Data T,pe
Si-e
Constraints
Description
(serid -ass"ord
Varchar0 Varchar0
%1<& %1<&
-rimary $ey ?ot ?ull
(sername -ass"ord
3;
Chapter-: System esi*n
3@
SLASH SCREEN :
This is a 5ellCome Screen of Airline Reservation System. 5hen the user starts the application from the pro'ram 'roup! then splash screen is displayed.
LOGIN FORM:-
This screen is used for data security purpose. The lo'in screen is used for authentication purpose. The lo'in screen as$s the user to enter the username and pass"ord. 5hen the system is installed then after the splash screen! in the lo'in screen the user must e created first. The admin user only creates another user. In my
3
system username and pass"ord must e 1< character. To enter in the system first user has to enter "ith follo"in' user name and pass"ord.
(ser name 6 admin -ass"ord 6 suBal
MAIN SCREEN OF AIRLINE RESERVATION S)SETM :
The follo"in' screen is the main screen of my Airline Reservation System. *rom here the user can perform desire operations. Actually it is a menu/ased screen so user user can perfo perform rm oper operati ation onss y selec selectin tin' ' then then from from the the menu menu or sum sumen enu. u. ependin' on the type of user "hether he or she is JadminK or other user the particular ri'hts are 'iven.
MASTER MENU : 3D
The follo"in' fi'ure sho"s the J9aster 9enu J of the system. The master menu contai contains ns option optionss li$e li$e Lo'in! Lo'in! :ranch :ranch!! Servic Service! e! Airu Airus! s! *are! *are! *li'ht *li'ht Info! Info! *li'ht *li'ht schedul schedule! e! Contro Control! l! Route Route inform informatio ation n and Eit Eit from from the menu. menu. :y selectin selectin' ' the desired option the associated form "ill e sho"n.
TRANSACTION MENU : 7=
The The follo" follo"in' in' fi'ure fi'ure sho"s sho"s the JTrans JTransacti action on 9enuK 9enuK of the system system.. The The transaction menu contains options li$e Reservation and Cancellation of tic$ets. :y selectin' the desired option the associated form "ill e sho"n.
REORT MENU :
71
The follo"in' fi'ure sho"s the JReport 9enuK of the system. The report menu contains options li$e Reservation Report! Cancellation Report! *li'ht information y :ranch. :y selectin' the desired option the associated report "ill e sho"n.
A"" USER FORM :
70
This form is used to create ne" user. Only admin user can create ne" user. In this form enter username and pass"ord "ith confirmation pass"ord. And than clic$ on JOK utton. After press on clic$ utton small messa'e o "ill e displayed li$e JCREATE (SERK.
CHANGE PASSWORD FOR" 0
73
This form is used to chan'e pass"ord of the user.To chan'e pass"ord username of the user "ill e entered. Old pass"ord of the user "ill e entered after display old pass"ord enter ne" pass"ord and confirm pass"ord and then press JOK utton after clic$ on o$ utton small messa'e o "ill e displayed li$e J -ass"ord 8as :een Chan'edK.
DE#ETE USER FOR" 0
77
This form is used to delete the user. Enter the username of the user "hich you "ant to delete. Only admin user can delete the user. After press on JOK utton small messa'e o "ill e displayed li$e J(ser is eletedK.
$RANCH INFOR"ATION FOR" 0
7<
The follo"in' form sho"s the ranch information of Airline Reservation System. This form is used to sho" the information of ranch! selectin' for reserve tic$et. This form is also used to process accordin' to user)s choice on ranch information tale. In this form A! ELETE! SAVE! EIT! CA?CEL! *I?! *IRST! ?ET! -REVIO(S! LAST A? EIT follo"in' operations can e performed.
SERVICE INFOR"ATION FOR" 0
7;
The follo"in' form sho"s the JService Information J of the system. This form is used to select any etra other services of the system. At a time only one service is used to reserve the tic$et. In this form A! ELETE! SAVE! EIT! CA?CEL! *I?! *IRST! ?ET! -REVIO(S! LAST! *I? A? EIT follo"in' operation can e performed.
AIR$US INFOR"ATION FOR" 0
7@
This form sho"s the Airus Information of the system. This form is used to sho"s the capacity of first class! usiness class ! economic class and also the "aitin' list capacity of the first class! usiness class and economic class. 5hen you press on save utton after addin' a record a fare information form "ill e opened to add fare information.
FARE INFOR"ATION FOR" 0
7
This form sho"s the fare information of the system. In "hich route code is to e select and throu'h route code fare can e sho"n. To add fare information in first class fare! usiness class fare and economic class fare information. In this form SAVE! EIT! ELETE! CA?CEL! *IRST! ?ET! -REVIO(S! LAST! *I? A? EIT the follo"in' operations can e performed.
F#IGHT INFOR"ATION FOR" 0
7D
This form sho"s the fli'ht information y particular fli'ht no and fli'ht date.This form automatically operate after reservin' the tic$et. If the tic$et is confirmed then the record "ill e insert into the fli'ht information! ut "hether the tic$et is not confirmed then the record "ill not inserted into the fli'ht information form. If t"o tic$et is confirmed "ith same fli'ht no and fli'ht date and class then it "ill increment y 1 in oo$in' seats. This form is used to sho" the fli'ht information.
F#IGHT SCHEDU#E INFOR"ATION FOR" 0
<=
This form sho"s the fli'ht schedule information. This form used for the fli'ht no and the name of the airus. It is also used to sho" the departure time and Bourney hours of the fli'ht. And it "ill also sho"s that in "ee$ in "hich day the fli'ht is 'one. (sin' the route code it "ill sho"s the departure time! Bourney hours fli'ht day1 and fli'ht day0 of that fli'ht.
CONTRO# INFOR"ATION FOR" 0
<1
This form sho"s the control information of the system. In "hich Air ta! a' limit and cancellation deduction "ill e displayed. Air ta "ill e directly calculate in reservation form. And cancellation deduction "ithin 10! ; and 3 days "ill directly calculate "hen you cancel the tic$et and cancellation amount "ill e calculated. Air ta "ill e Rs.@== fied for every fli'ht.
ROUTE INFOR"ATION FOR" 0
<0
This form sho"s the route information of the fli'ht. In this form route code! route description! ori'in and destination "ill e displayed. *rom "here fli'ht)s ori'in and the place "here the fli'ht is 'one. In this form A! ELETE! EIT! SAVE! CA?CEL! *IRST! ?ET! LAST! -REVIO(S! *I? A? EIT follo"in' operations "ill e performed.
FLIGHT LIST FORM :
<3
This form sho"s the fli'ht list of the system. It sho"s "ith the "hole information of the fli'ht schedule information form. Select the date and route code and then press on Jclic$K utton and the fli'ht list "ill e displayed and select the fli'ht list.
RESERVATION FORM :
<7
This form is used to reserve tic$et. This form sho"s the reservation information. -?R numer is auto 'enerate numer. In this form tic$et fare "hich "ill comes from the fare tale. And "hen you select class it)s fare "ill insert into tic$et fare. And for fli'ht no press J*1K $ey for fli'ht list and service code. In total fare tic$et fare! air ta and service fare "ill e calculated automatically. passen'er information "ill e inserted and in passen'er status if the status is confirm then the information of fli'ht "ill e added in to fli'ht information tale! other"ise status is "aitin' then information "ill not e added into information tale. In this form A! ELETE! EIT! SAVE! CA?CEL! *IRST! ?ET! -REVIO(S! LAST! *I?! -RI?T! and EIT follo"in' operation "ill e performed.
CANCELLATION FORM :
<<
This form is used to cancel the reserved tic$et. 5hen you press on add utton small o is displayed li$e JEnter -?R numer6 / J and enter the pnr numer from the reservation form. And if you press on save utton and press yes then tic$et is cancelled. In find utton you enter pnr numer of reserved tic$et it display the messa'e li$e J?O S(C8 -?RK. In cancel amount field direct cancel amount "ill e calculated.
RESERVATION REPORT 0
<;
This report sho"s the reservation report of the reservation tic$et.
CANCE##ATION REPORT 0
<@
This report sho"s the cancellation report from the cancel tic$et.
FLIGHT INFORMATION B) BRANCH :
<
This report sho"s the fli'ht information y ranch.
CONC#USION
The Airline reservation system has een a "ay of minimi4in' the clerical "or$! "hich is almost a routine and consumes the most precious time.
This AIRLI?E RESERVATIO? SGSTE9 has een an attempt to help the user to minimi4e his "or$load alon' "ith minimi4in' the paper "or$s and savin' of time.
The system has een developed in a "ay to ma$e it very user friendly. It provides an on/line messa'e and an error detection and error messa'es every time the user needs. Any person havin' a little it of "indo" ased can run this system "ithout any pain.
Almost all the difficulties of manual reservation have een removed y this system. Ti "ind up let me "elcome all the su''estions and other improvements! "hich the system needs so that it covers all the needs if the user in the user "ay.
APPENDICES
;=