- eo 6 6 6 Om | MCA-III Semester In-house Project AIRLINES RESERVATION SYSTEM Prepared by Hitesh B Thakor University Examination Number: 37 PID: MS21123 Guided By: Mr. BharatBhai B.Patel November 2022 Submitted To Post Graduate Department of Computer Science & Technology Sardar Patel University. Page 1 of 30Post Graduate Department of Computer Science and Technology SARDAR PATEL UNIVERSITY CERTIFICATE This is to certify that Mr. Hitesh B Thakor of MCA-III Semester has successfully carried out a project entitled “ Airlines Reservation System ” towards partial fulfillment of the course PS03CMCAS6 In- house Project Work. Se Sij ire of Project Guide Signature of * Dicector of the Departinent, | Comp Sardar Patel Univ Date: 24/11/2022 ent Page 2 of 30ACKNOWLEDGEMENT With immense pleasure, | would like to present this report on the project assignment of “Airlines Reservation System”. It gives us a great pleasure to acknowledge the help and guidance available to me during the system development period from various eminent persons. We offer my sincere thanks to Dr. D.B.Shah, Professor & Director of the G.H Patel P.G Department of Computer Science & Technology, Sardar Patel University, for giving me an opportunity to develop my skills as a part of 3a Semester In-house project work and Mr.Bharatbhai B Patel, Sir our project Guide for giving me their support to develop our website. | also express my profound thanks to academic as well as non-academic staff authorities of GDCST family for providing me all facilities & helping me in clearing out doubts, without whom this project would not be a successful one. Esteemed knowledge, dynamic and valuable advices are the backbone of this project. | am highly indebted to all, for helping me to give project its presentation. The success of this project is not due to any single person but to combined success and failings of a group of dedicated and inspirational individuals including infallible staff members. Finally, | would like to thanks my family and my friends for all the support and encouragement. Date: Hitesh B ThakorINDEX 1 About The System He |} troduction 3 ~ | 12 Objectives wae raa sa Par er 723 Purpose car 6 1.4 Resource Requirements a 6 7 ma: car a 7 1.7 Future Enhancement 7 2 Work Analysis 2.1 Preliminary Study 8 2.2 Feasibility Study 3 | 2.3 Requirements Analysis 9 2.4 Design Constraints | 25 User bnesface 2.6 System outputCHAPTER 1: About the System 1.1 Introduction + The application allows operator to book tickets of the client as well as agent will able to print the report summery of the reservation Ticket. * The main application of the system is to enable the user to book ticket from home via internet our site . +> on will work for both the users as well as internal users . In this application external user to see availability of the Airlines . + The application allowed cancellation of ticket to user . The application allows to admin Adding , Deleting existing Flight , Manage Passenger, Adding Ticket Price. 1.2 Objective Enable users to book ticket ,Print already booked Tickets. “ Enable admin to maintain management services like , “ Create and maintain airline schedule, fare and timings of the Flight. “ View the passenger list. * Cancel the tickets. 4 Updating the flight schedule and timings and fare. Page 5 of 301.3Purpose * The Proposed system ensures the complete freedom for users, where user at his own system can logon to this website and can book his ticket. Our proposed system allows only registered users to book the tickets, view timings and cancel their tickets. * In this Proposal the entire work is done on online and ticket with id is also provided for passengers as a print document. Here passengers can send their queries and suggestions through a feedback form. 1.3 Resource Requirement (A) Hardware Specification CPU: Intel Core i3 2.8GHz or Above RAM: 2GB or More Hard Disk: SOOMB or More Display Monitor: Standard Color Monitor Wavew¥ (B) Software Specification +> Plateform : Microsoft Windows Family Software +> Framework: Microsoft .NET Framework 4.5 Tools: Microsoft Visual Studio 2017 Front-End; ASP.NET With C#, Bootstrap 5.0,CSS3,HTMLS. Back-End: Microsoft SQL Server. Web Server: lIS(internent Information Services) Web-Browser: Google Chrome/Microsoft edge etc Wee. 0. wa, Page 6 of 301.5 Application of the Project + This application is useful for booking tickets through internet from anywhere ++ This application is also useful for the cancelling of your ticket which is booked by user Easy process for booking of your tickets Easy process for cancelling of your tickets. User friendly environment. * Easy process for function for the administrator . 1.4 Limitations User can Book only Flight tickets. User cannot book hotel and taxes. User can book only Domestic Flight. + User can not book return ticket. 1.5 Future Enhancement User can get booked ticket detail to his/her Mobile Add the facility of Advertisement through which earning be possible “ Admin can view daily, monthly, yearly report of the ticket book. “% System will be more user friendly as compare to today’s System. “% System will have more details information about the different destination and other new Flights. Page 7 of 30Chapter 2: Work Analysis 2.1 Preliminary Study % Our initial study shows that most of the current operator working on paper & phone inquire for seat availability . “ The reason behind using web based is that web base is interoperable with any platforms and they work on HTTP protocol , Firewall doesn’t block this protocol . < Our initial study was also how the user interface with the keyboard and our study shows if the short cuts are well defined then user’s productivity increases . So our focus is also on building great user interface . This project gives complete information for its user’s to select their Source and Destination City , date of journey. 2.2 Feasibility Study 2.2.1 Technical Feasibility “ We have with necessary tools for developing software with us . “ We already have license version of all software that provides us the basic about the tool we need to develop .2.2.2 Operational Feasibility * The database stores all the transaction information so periodically indexing and compacting of database is required for optimal efficiency . *% This application will be used if it will be implemented well and users will readily accept it . ‘% System Performance . *% The proposed project is beneficial only if turned into an information system that will meet the requirements . 2.2.3 Economic Feasibility * The application requires a high performing server with huge bandwidth to support a large number of users. “> The application on client side requires a good PC with goof graphic card for the rich user interface . 2.3 Requirements Analysis 2.3.1 Specific Requirements ** The project needs a server where this application can be developed . * User will need browser of standard IE8.0 or higher or Mozilla Fire Fox 3.0 of higher Page 9 of 302.3.2 Performance Requirements * Good internet bandwidth is require. + The client has to have an operating system which can support IE 6.0 of higher version . * User might have RAM that is more than 512 MB so that system can operate smoothly . * Good Graphics card can give better user interface. 2.3.3 Functional Requirements + This application needs a computer and internet connection to run 2.4 Design Constraints 4 User Should have the Standard Keyboard to utilize the Keyboard binding. 2.5 User Interface “ The User Interface is Quite attractive to the native and the users can explore the site easily.2.6 System Output > The application provides an interface that enables the user to Search Flights between cities and book tickets of Flights + The application provides user to maintain its portfolio by the providing the details about his / her security holding > This application allows administrator to maintain the user's information and their transactions also . *% This application also provide different kinds of reports which are required by the administrator . Page 11 of 30Chapter 3: Work Design 3.1 UML(Unified Modeling Language) Diagram 3.1.1 Use Case of Admin Hood SO 8 VU eve eu vous elf 1 Page 12 of 30(8\ (4\ GY Ae | YY L f | GY of User 1.2 Use Case si CUCEEEREELELT TILT EEN) 3..... De Pe = 3.2 ACTIVITY DIAGRAMil 3.3 SEQUENCE DIAGRAM 3 : : i ee ae Logout —— Gives ticket id He oe "| fle Update data base Redirect to startpage 1 og I I I I 1 1 I I ! | 1 I! I 1 1 I 1 Page 15 of 303.4 COLLABORATION DIAGRAM 1.Admin login 4 Perform Operations T.Logout 3.Show the Admin Panel 6 Retum Result, 9 Redirect to StartPage 10.User Login 13 Book Ticket 16 Logout 12Show User Pane! 15.Gives Ticket id 18 Retum To Startpage User 2.Nalidate Admin Account 5,Update Database €.Close Session 11.Validate User 14 Update Database 17.Close Session System Page 16 of 303.5 Data Dictionary * Table: Register Peele Description Register id ‘Auto_increment Userfirstname _—‘Notnull Varchar(15)—-User LastName —=—-Notnnull_— Ee Varchar(15)-Emailid Not null “date +Dateofbirth | —-Notnull el jot null Varchar(5) 7 Gender “password * Not null Varchar(25) “Table: : Admin_login Peles 7 forse tol) Peele} Primary key username Varchar(10) Admin usernam password Varchar(15) password Not null Page 17 of 30* Table : Flight_details Field DEEL Dla tC) (ied Flight_id Int(5) Flight Primary key Flight_name Varchar(10) Flight name Not null Airlines_name Varchar(15) Airlines Company name “Not null Departure city Varchar(15) Source city Not null Ariaval_city Varchar(15) Destination city _-—-‘Not null Total_seat Int(5) Total Seat "Not null Date date departuredate -+—«sNotnull—| Time Varchar(10) Flight arivaltime | —Not null NetFare int(7) Ticketcost. ~—~—~=SNotnull_~— Page 18 of 30“Table : Book_details Varchar(10) eld Datatype Po Cid book_id Int Booking Id Primary Key || Flight_id — Int ~ Flight_id Not null Flight_name ~~ Varehar(10) Flight name Not null Airlines_name ~~ Varchar(15)—_—Airlines Not null Company name Departure_cit Varchar(15) Source city Not null Ariaval_city Varchar(15) “Destination city Notnull Date date departure date Not null Time ~ Varchar(10) Flight arival time Not null First_name ; Varchar(15) Passenger Name Not null Last_name Varchar(15) Passenger last Not null a Name email Varchar(15) Passenger email Not null Contact no Varchar(12) Contact Number Not null 7” Pass_no Int "Number of Not null Passenger ~~ Varehar(10) Travelclass -Notnull Booking Status Default,/Pending’ Page 19 of 30“Table: Payment Peer Dla a) eu “+ Table:Feedback Perens) Perera Pid Int Payment Id Primary key, Auto Increments book_id Int ‘Booking Id Foreign key (Book_details) Card _Type Varchar(10) _ Debit card type Not null Card_no Varchar(16) Debit card number — Notnull ; Card_name Varchar(20) CardOwnername —Nott null , cw Varchar(3) Cardevvcode “Not null Exp_date Varchar(7)__‘Cardexpiringdate Not null , Totalnetfare Int A Total Payment Not null Petey Name Varchar(10) User name Not null Email Varchar(15) User Email-id ~~ Not null Phone Varchar(15) Usercontactnumber _—_—Not null Subject Varchar(50) subject Not null Comment Varchar(100) Comment Not null » - Page 20 of 30A Chapter 4: System Output 4.1 Screen Shots 4.1.1 Home Page BlucSky2% wee nest reter—_rght Manngmet? Sign-Up to get a Personalised experience (© FASTERBOOKING (© SPECIAL OFFER © MANAGE PREFERENCE @ EASY CECK aa Why We Are The Best a Q Fast and Reliable Ticket More Than IM Visitors User-Friendlly Search Bookit Each Month St 24*7 SUPPORT vices is available 24 hours a day,7 days a week to help y eM So Page 21 of 30[—— 4.1.2 User Login page @eeeeeeeeeeee 4.1.3 Admin Login Page Page 22 of 30eeveuevuvuevrvvevedégeo 4.1.4 User Registration Page BlueSky” ae ee |4.1.6 Flight-list Page BlueSky» mimes eeEeerrewrwvvwrcwrvwo f Page 24 of 30Page 25 of 30—_— = 2 oe eee 4.1.10 Add-Flight Page 4.2.1 Modify Flight Page Page 26 of 304.2.2 Feedback-list page 4.2.3 Contact-us Page Send a Message ~ : 4 Page 27 of 305. TESTING PROCEDURE Introduction Testing presents an interesting anomaly for the software engineer. During earlier software engineering activities, the engineer attempts to build software from an abstract concept to a tangible product. Now comes testing. The engineer creates a series of test cases that are intended to “demolish” the software that has been built. In fact, testing is the one step in the software process that could be viewed (psychologically, at least) as destructive rather than constructive. Software engineers are by their nature constructive people. Testing requires that the developer discard preconceived notions of the “correctness” of software just developed and overcome a conflict of interest that occurs when errors are uncovered. Any engineered product (and most other things) can be tested in one of two ways: (1)Knowing the specified function that a product has been designed to Perform, tests can be conducted that demonstrate each function is fully Operational. While at the same time searching for errors in each function. (2)Knowing the internal Working of a product, tests can be conducted to Ensure that “all gears mesh,” that is, internal operations are performed Page 28 of 30d According to specifications and all internal components have been adequately Exercised. The first test approach is called black box testing and the second, White-box testing . Testing performed were: e UNIT TESTING ¢ INTEGRATION TESTING © DATABASE TESTING RECOVERY TESTING | FUNCTIONALITY TESTING | @ MOKE TEST SANITY TEST © COMPATIBILITY TESTING e LOAD TESTING | © SYSTEM TESTING PERFORMANCE TESTING © USER ACCEPTANCE TESTING ___Page 29 of 30°6. CONCLUSION This application avoids the manual work and the problems concern with it. It is an easy way to obtain the information regarding the different scheduled item information that is currently issued. Well, | have worked hard in order to present an improved application better than the existing. One’s regarding the information about the various activities. Still, | found out that the project can be done ina better way. Primarily, when | request information about particular schedules it just shows the exam date and platform. So, after getting the information we can get access to the quiz. 7. BIBLIOGRAPHY + Reference > SQLFOR PROFESSIONALS - By Roger’s.Pressman > ASP.NET With C# ~ ByJain WEBSITES: 1. _www.Support.microsoft.com 2. www.asp.net 3. _www.w3schools.com 4. www.freetutes.com Page 30 of 30 eer