This research paper is an outcome of the study carried to develop an online airline reservation system. The study resulted into the development of an online airline reservation system using …Full description
Full description
airline reservation system cbseFull description
Airline Reservation System using vb.net...Full description
Document Control Reference No: Security Classification: Issue Date: A$th"r's()
Revieer's()
Iss$er's()
Iss$er *ignat$re's() -istri$ti"n)
-"#$ment ist"r%)
Internal
Name *hrilata Tavargeri
Title Manager + T , -
Name
Title
Training Team
E/e#$tive Managers + T,-
Name
Title
-inesh Anantar
*r. Manager
Name
Title
Team
All -esignati"ns in Training
Date
Revision
Chane
N"v 23 04
0.01-
Initial ra!t
N"v 25 04
0.02-
Revie #"mments in#"rp"rate
J$l% 01
0.0-
J$ne 2517
0.03-
Changes in Miniproject document content to standardize for 60 days training. Changes in Minipr"8e#t "#$ment #"ntent as per the $pgrae #"$rses
C"mpan% C"n!iential
Page 2
JEE Mini Project
C"mpan% C"n!iential
Page
JEE Mini Project
C"mpan% C"n!iential
Page 3
JEE Mini Project
Ta!le o" Contents #
Intro$uction
%
1.1
*et$p Che#9list !"r Mini Pr"8e#t
3
1.2
Instr$#ti"ns
3
&
Pro!lem Statement 2.1 2.2 2. 2.3
O8e#tive Astra#t "! the pr"8e#t &$n#ti"nal #"mp"nents "! the pr"8e#t Te#hn"l"g% $se
Imlementation in JEE *+T .1 .2 .
*$mmar% "! the !$n#ti"nalit% t" e $ilt ;$ielines "n the !$n#ti"nalit% t" e $ilt Eval$ati"n an assessment parameters
' 7 7 7 6
, : 4 11
# INTR+D-CTI+N
C"mpan% C"n!iential
Page 7
JEE Mini Project This "#$ment "$tlines a mini pr"8e#t !"r the J2EE
1.1 *ET=P CEC>
Intel Penti$m 50 "r higher 'P166 re#"mmene( Mi#r"s"!t ?in"s 57 54 "r NT 3.0 29 @P ?in"s : Mem"r%) 2M "! RAM '63M "r m"re re#"mmene( Internet E/pl"rer 6.0 "r higher Ora#le 5i #lient an a##ess t" "ra#le 5i server J-> 4 E#lipse <$na J=nit 3.0
1.2 IN*TR=CTION*
The #"e m"$les in the mini pr"8e#t sh"$l !"ll" all the #"ing stanars. Create a ire#t"r% % %"$r name in rive /$rive0. In this ire#t"r% #reate a s$ire#t"r% MiniProject. *t"re %"$r Pr"8e#t here. B"$ #an re!er t" %"$r #"$rse material. B"$ ma% als" l""9 $p the help pr"vie in the 8ava "#s an "#$mentati"n pr"vie ith ?il&l% server. The t"tal time re$ire t" #"mplete this mini pr"8e#t is 70 hrs. *in#e this pr"8e#t "r9 ill span "ver #"$ple "! m"nths %"$ ill nee t" ta9e #are "! maintaining the #"e
2.2 A*TRACT O& TE PROJECT This pr"8e#t is aime at evel"ping an Airline Reservati"n *%stem 'AR*( !"r #$st"mers. This s%stem #an e $se t" sear#h !light etails reserve !light an $pate#an#el an% reservati"n. This is an integrate s%stem that #"ntains "th the $ser #"mp"nent an the aministrati"n #"mp"nent. There are !eat$res li9e rep"rt generat"rs et# in this s%stem.
2. &=NCTIONA< COMPONENT* O& TE PROJECT &"ll"ing is a list "! !$n#ti"nalities "! the s%stem. ?herever the es#ripti"n "! !$n#ti"nalit% is n"t ae$ateF %"$ #an ma9e appr"priate ass$mpti"ns an pr"#ee. There are three #ateg"ries "! pe"ple h" "$l a##ess the s%stem viG. #$st"mer airlineH e/e#$tive an aministrat"r. Ea#h "ne "! them "$l have s"me e/#l$sive privileges '!"r e.g. =ser #an reserve a !light ti#9et an als" $pate "r #an#el his reservati"n AirlineHe/e#$tive al"ne ill e ale t" vie !lightH"##$pan#% an "nl% the aministrat"r has the right t" 9eep tra#9 "! the !light etails.( 1. =ser sh"$l e ale t"
Pla#e a re$est !"r a !light ti#9et.
=ser sh"$l e ale t" vie the reservati"n etails $pate an #an#el the ""9ing.
2. The airlineHe/e#$tive sh"$l e ale t" )
<"gin int" the s%stem $sing hisher #reentials.
Die !lightH"##$pan#% etails.
. The aministrati"n sh"$l e ale t"
<"gin t" the s%stem $sing hisher #reentials
=pate an manage !light s#he$les.
C"mpan% C"n!iential
Page :
JEE Mini Project
=pate an manage !light in!"rmati"n
;enerate vari"$s rep"rts li9e)
Die
Die ""9ings "! spe#i!i# !light
Die passenger list "! spe#i!i# !light
2.3 TECNO
Business Logic Components and Services :1. Java eans 2. Java #"mp"nent #lasses
Databases:-
1. Ora#le 5i
C"mpan% C"n!iential
Page 4
JEE Mini Project
IMP*EMENTATI+N IN JEE *+T 2# S-MMAR3 +4 T5E 4-NCTI+NA*IT3 T+ 1E 1-I*T6 The parti#ipants nee t" evel"p the ARS % $iling the !$n#ti"nalit% in#rementall% in ea#h "! the #"$rse m"$les "! JEE
Sr. No 1
Course
Duration (in PDs)
No2 o" Satur$ays
4unctionality to !e !uilt Anayze the gi!en case study Create TM< Pages !"r %"$r Pr"8e#t Creating relevant ataase tales Creating relevant =se #ase an #lass iagrams
3
1
#.$
1
3
Programming Foundation with Pseudo code ?e asi#s 'TM< 7C** Java*#ript @M<( %race &asics
-evel"ping $siness #"mp"nents '8ava #lasses(. C"ing !"r test #lasses , testing the !$n#ti"nalit% $sing J=nit -evel"ping the appli#ati"n $sing the pr"t"t%pes. Creating Java #lasses an implementing #"e !"r ispla%ing ata. Integrati"n "! appli#ati"n.
1 Prepare document for presentation.
13
&asic pring -est
1
1#
Mini Project presentation
1
2& 7-IDE*INES +N T5E 4-NCTI+NA*IT3 T+ 1E 1-I*T6 The !$n#ti"nalit% an #"mp"nents t" e $ilt in ea#h "! the #"$rse m"$les "! J2EE
Page 5
JEE Mini Project
#2 Course6 5TM*8 JavaScrit (Duration6 #9 hours) a. -evel"p the !"ll"ing s#reens) i. Die &light *#he$les s#reen) This !$n#ti"nalit% pr"vies the $ser ith in!"rmati"n relate t" !lights s#he$le % Airline C"mpan%. ii. Ma9e a reservati"n) All"s the $ser t" reserve ti#9ets $sing the AR*. iii. Die "r #hange the ""9ing s#reen) &"r $sers the #$st"mer sh"$l e ale t" vie the ""9ing "r #hange the ""9ing. iv. Maintain &light In!"rmati"n) This !$n#ti"nalit% sh"$l e availale "nl% !"r a$th"riGe aministrat"rs. Aministrati"ns maintain in!"rmati"n in#l$es &light n$mer Origin -estinati"n -epart$re Time arrival Time -a%s "n hi#h the !light is availale. Apart !r"m this the "verall #apa#it% availale !"r reservati"ns "n the !lights is als" maintaine. There #"$l e m$ltiple !lights availale eteen an% 2 #ities "n the same a%. The% are ienti!ie "n the asis "! the !light n$mers. v. Die &light O##$pan#% *tat$s *#reen) This s#reen sh"$l "nl% e availale t" a$th"riGe Airline E/e#$tives. e m$st e ale t" see the "##$pan#% ase "n !"ll"ing parameters) 1. O##$pan#% !r"m a given !light !"r a given peri". 2. Overall O##$pan#% !r"m all !lights !l%ing !r"m a parti#$lar s"$r#e t" a parti#$lar estinati"n. vi. Other Mis#ellane"$s In!"rmati"n) Pr"vie #"mpan%s #all #enters #"nta#t n$mers &As Terms an #"niti"ns an a !eea#9 !"rm.
In this #"$rse %"$ nee t" evel"p the $ser inter!a#e $sing 8ava #lasses an "#$ment the !l" "! %"$r appli#ati"n in#l$ing the s#reen sh"t "! #"ns"le in a "r "#$ment. The s#reens sh"$l in#l$e the !iels as per the !$n#ti"nalit% menti"ne a"ve &2 Course6 +racle (Duration6 ' hours) a. Create the !"ll"ing ataase tales) i. =sers) This ill #"ntain the list "! vali $sers 'airlineHe/e# an aministrat"r "nl%(. ii. Airp"rt) This ill #"ntain etails "! ever% airp"rt iii. &lightIn!"rmati"n) This ill #"ntain etails "! ever% !light s#he$le % this airline. iv. ""9ingIn!"rmati"n) This ill #"ntain etails "! ""9ingreservati"n "ne % passengers. . The str$#t$re "! the a"ve liste tales is as !"ll"s)
C"mpan% C"n!iential
Page 10
JEE Mini Project
i. =sers) $sername'var#har2'20(( r"le'var#har2'10(( m"ileKn"'n$mer(
2 Course6 ++P : -M* (Duration6 ' hours) a. -evel"p relevant =se #ase an Class iagrams !"r the ARS appli#ati"n.
%2 Course6 Core Java ; < Develoer Tools (Duration6 #% hours) a. -evel"p $siness #"mp"nents '8ava #lasses( !"r the !"ll"ing !$n#ti"nalit%) i. =ser veri!i#ati"n) This #"mp"nent ill veri!% i! the $ser h" is tr%ing t" a##ess the s%stem is a vali $ser. This veri!i#ati"n is as against the vali $sers liste in the $sers tale. ii. Retrieve &light *#he$les) This #"mp"nent pr"vies the $ser ith in!"rmati"n relate t" !lights s#he$le % Airline C"mpan%. iii. Ma9e a reservati"n) All"s the vali $ser t" reserve ti#9ets $sing the AR*. iv. Die "r #hange the ""9ing) The #$st"mer sh"$l e ale t" vie the ""9ing "r #hange the ""9ing. v. Maintain &light In!"rmati"n) This is a t%pi#al CR='CreateRea=pate-elete( "perati"n. This !$n#ti"nalit% sh"$l e availale "nl% !"r a$th"riGe aministrat"rs. Aministrat"rs maintain in!"rmati"n in#l$es &light N$mer Origin -estinati"n C"mpan% C"n!iential
Page 11
JEE Mini Project -epart$re Time arrival Time -a%s "n hi#h the !light is availale. Apart !r"m this the "verall #apa#it% availale !"r reservati"ns "n the !lights is als" maintaine. There #"$l e m$ltiple !lights availale eteen an% 2 #ities "n the same a%. The% are ienti!ie "n the asis "! the !light n$mers. vi. Die &light O##$pan#% *tat$s *#reen) This s#reen sh"$l "nl% e availale t" a$th"riGe Airline E/e#$tives. e m$st e ale t" see the "##$pan#% ase "n !"ll"ing parameters) 1.( O##$pan#% !r"m a given !light !"r a given peri". 2.( Overall O##$pan#% !r"m all !lights !l%ing !r"m a parti#$lar s"$r#e t" a parti#$lar estinati"n. . -evel"p test #lasses !"r testing the !"ll"ing !$n#ti"nalit% i. <"gin ii. Ti#9et ""9ing. iii. Die &light *#he$le. #. Test the appli#ati"n $sing J=nit 3.0. . C"n!ig$re <"gger t" l"g the stat$s "! an appli#ati"n '2 Course6 Core Java Classes < Develoer =or>!ench (Duration6 #% hours) a. C"nvert all the 8ava #lasses '$siness #"mp"nents( #reate in Java m"$le t" Java eans . Integrate all s#reens'8ava #lasses #reate !"r ispla%ing (ith $siness #"mp"nents '8ava eans( t" #"mplete the entire !$n#ti"nalit% #. C"n!ig$re the -ata*"$r#e an m"i!% the ata a##ess #lasses t" $se -ata*"$r#e "8e#t #"n!ig$re. . =se https !"r se#$rit% thr"$gh"$t the pages s" that the vali $sers #an "nl% a##ess the ARS2 ?2 Documentation (Duration6 & hours) a. Pr"8e#t -"#$mentati"n) -"#$ment %"$r pr"8e#t etails '-$rati"n) 1 h"$r 0 mins(. . Pr"8e#t s$missi"n) *$mit %"$r pr"8e#t ith all the arti!a#ts in#l$ing the test #ases , "#$mentati"n '-$rati"n) 0 mins(.
2 E@A*-ATI+N AND ASSESSMENT PARAMETERS6 This minipr"8e#t ill e "ne in gr"$ps "! !ive. Ea#h gr"$p ill ienti!% a Team
9' Page 12
JEE Mini Project ClientHsie an serverHsie valiati"n C"e -"#$mentati"n an $sing #"ing stanars Overall $siness l"gi#. This in#l$es) =sage "! <"gging API 'l"g38( ;"" am"$nt "! appr"priate ataset t" sh"#ase pr"8e#t #"mpletel% Appr"priate test #ases $sing J=nit 3.0