Airways Reservation

Published on October 2020 | Categories: Documents | Downloads: 3 | Comments: 0 | Views: 42
of 81
Download PDF   Embed   Report

Comments

Content

 

AIRWAYS RESERVATION SYSTEM

ABOUT NIIT EDUCATION

 NIIT, Asia's largest IT Trainer, pioneered IT educ educat atio ion n and and tr trai aini ning ng in In Indi diaa more more th than an tw two o decades ago. Over the years NIIT has developed a ran range

of

curricula

fo forr

people

with

diverse rse

requirements--from students seeking a career in IT, to IT professional professionalss looking looking at enhancing enhancing their IT skills; from from busi busine ness ss mana manage gers rs se seek ekin ing g to deve develo lop p a comp compet etit itiv ivee edge edge,, to new new user userss in the the ques questt of  computer literacy.

 NIIT is the first and the only Asian Education and Training Organization to feature among the IDC Top 20 Global IT Training market leaders.  NIIT is a leading Global Talent Development Corporation, building a skilled manpower   pool for global industry requirements. The company which was set up in 1981, to help the nascent IT industry overcome its human resource challenges, has today grown to rank  among the world’s leading talent development organisations offering learning solutions to Individuals, Enterprises and Institutions across 40 countries.

1|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

INTRODUCTION TO VISUAL BASIC .NET   Visual Basic.Net is an object oriented programming language. Visual Basic .Net is the fastest and easiest way to create application for Microsoft Windows. Visual Basic.Net  provides you with a complete set of tools to simplify rapid application development. development. The “Visual” part refers to method used to create the graphical user interface (GUI). Rather than writing numerous lines of code to describe the appearance and location of interface elements, you simply drag and drop pre built objects into place on screen. The “Basic” part refers to the BASIC (Beginners All-Purpose Instruction Code) language used by more programmers than any other language in the history of computing. Visual Basic.Net has evolved from the original BASIC language and now contains several hundred statements, functions and keywords, many of which relate directly to Windows GUI. Beginners can create useful applications by learning just the few of the keywords, yet the power power of the langua language ge allows allows profess profession ionals als to accomp accomplis lish h anythi anything ng that that can be accomplished using any other Windows programming language. The Visual Basic.Net programming language is not unique to Visual Basic.Net. The Visual Basic.Net programming system, Application Edition included in Microsoft Excel, Microsoft Access, and many other windows applications uses the same language. It is also very user friendly. It has menu driven interface which gives the user a great deal of convenience convenience in creating and handling handling database. It is becoming very popular  among the users due to its user friendliness and advanced features.

2|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

FEATURES OF VISUAL BASIC .NET Some of the features that we used in our Office Automation System are described below: 

General tools



MDI form.



Menu Editor 



Communication control.

GENERAL TOOL The Visual Basic.Net toolbox contains the tools you use to add controls on your forms.

THE VISUAL BASIC.NET TOOLBOX

3|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

CONTROL CATEGORIES There are three broad categories of controls in Visual Basic.Net: •

Intrinsic controls, such as the command button and frame controls. These controls are contained inside the Visual Basic.Net .exe file. Intrinsic controls are always included in the toolbox, unlike ActiveX controls and insert able objects, which can  be removed from or added to the toolbox. toolbox.



ActiveX Active X controls controls which exist as separate files with a .ocx file name extension.  ,

These include controls that are available in all editions of Visual Basic.Net (Data Combo, Data List controls, and so on) and those that are available only in the Professional and Enterprise editions (such as List view, Toolbar, Animation, and Tabbed Dialog). Many third-party ActiveX controls are also available.

Note Controls with the .vbx file name extension use older technology and are found in applications written in earlier versions of Visual Basic.Net. When Visual

Basic.Net opens a project containing a .vbx control, the default behavior is to replace the .vbx control with an .ocx control, but only if an .ocx version of the control is available. •

Insertable Objects, such as a Microsoft Excel Worksheet object containing a list of  all your company's employees, or a Microsoft Project Calendar object containing the scheduling information for a project. Since these can be added to the toolbox, they can be considered controls. Some of these objects also support Automation (form (fo rmerl erly y calle called d OLE OLE Auto Automa mati tion on), ), whic which h al allo lows ws yo you u to pr prog ogra ram m an anot othe her  r  application's objects from within a Visual Basic.Net application.

4|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

ACTIVEX CONTROLS Visual Basic.Net Basic.Net contains a number number of ActiveX ActiveX controls controls (referred to as standard ActiveX controls) that allow you to add advanced features to your applications. ActiveX controls have the file name extension .ocx and can be used in your project by manually adding them to the toolbox. The following table summarizes the standard ActiveX controls available in the Learning edition of Visual Basic.Net.

Icon

Control name

Class name

Description

ADO Data Control

ADODC

Creates a connection to a database us usin ing g ADO. ADO. Assi Assign gnab able le to th thee Data Data Source property of other controls such as the Data Grid.

Common dialog

Common Dialog

Provides a st standard se set of of di dialog bo boxes for op for opera erati tion onss such such as op open enin ing g an and d saving files, setting print options, and selecting colours and fonts.

DataCombo

DataCombo

Provides m mo ost of of th the fe features of of th the stan standa dard rd co comb mbo o bo box x co cont ntro rol, l, pl plus us increased data access capabilities.

DataGrid

DataGrid

A grid control that allows can be data bound to a data source such as the ADO AD O

Data Data Con ontr trol ol..

Re Read adin ing g

an and d

editing the record set is possible. DataList

DataList

Provides most of the features of the standard list box control, plus increased data access capabilities.

Microsoft Microso ft Hierarchical Hierarchical MSHFlexGrid

A rea read-only gr grid co control tha that can can be be

FlexGrid

 bound the Data Environment designer  to show hierarchical record sets.

MULTIPLE DOCUMENT INTERFACE (MDI) APPLICATIONS

5|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

The multiple document interface (MDI) allows you to create an application that maintains multiple forms within a single container form. Applications such as Microsoft Excel and Microsoft Word for Windows have multiple-document interfaces. An MDI application allows the user to display multiple documents at the same time, with each document displayed displayed in its own window. window. Documents Documents or child windows windows are contained  

in a pa paren rentt wind window ow,, whic which h pr prov ovid ides es a work worksp spac acee fo forr all th thee ch chil ild d wind window owss in th thee applic app licatio ation. n. For exampl example, e, Microso Microsoft ft Excel Excel all allows ows you to create create and displa display y multip multipleledocument windows of different types. Each individual window is confined to the area of  the Excel parent window. When you minimize Excel, all of the document windows are minimized as well; only the parent window's icon appears in the task bar. A child form is an ordinary form that has its MDI Child property set to true. Your  application can include many MDI child forms of similar or different types.

At run time, child forms are displayed within the workspace of the MDI parent form (the area inside the form's borders and below the title and menu bars). When a child form is

6|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM minimized, its icon appears within the workspace of the MDI form instead of on the taskbar, as shown in Figure.

CHILD FORMS DISPLAYED WITHIN THE WORKSPACE OF THE MDI FORM

Note: Your application application can also include standard, non-MDI non-MDI forms that are not contained contained

in the MDI form. A typical use of a standard form in an MDI application is to display a modal dialog box. An MDI form is similar to an ordinary form with one restriction. You can't place a control directly on a MDI form unless that control has an Align property (such as a picture box control) or has no visible interface (such as a timer control).

RUN-TIME FEATURES OF MDI FORMS 7|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM At run time, an MDI form and all of its child forms take on special characteristics: •

All child forms are displayed within the MDI form's workspace. The user can move and size child forms like any other form; however, they are restricted to this workspace.



When a child form is minimized, its icon appears on the MDI form instead of the taskbar. When the MDI form is minimized, the MDI form and all of its child forms are represented by a single icon. When the MDI form is restored, the MDI form and all the child forms are displayed in the same state they were in before being minimized.



When a child form is maximized, its text is combined with the caption of the MDI form and is displayed in the MDI form's title bar (see Figure).



By sett settin ing g th thee Auto Auto Show Show Chil Childr dren en pr prop opert erty, y, yo you u ca can n di disp splay lay ch chil ild d fo form rmss automatically when forms are loaded (True), or load child forms as hidden (False).



The active child form's menus (if any) are displayed displayed on the MDI form's menu bar, not on the child form.

A CHILD FORM TEXT COMBINED WITH THE TEXT OF AN MDI FORM

8|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

MENU EDITOR TO DISPLAY THE MENU ITEMS   •

From the toolbox, Choose Menu strip and drop on to the MDI form. You can write the name of the menu items by clicking on the strip. Also, place an ampersand (&)  before the letter you want to be the access acc ess key for that menu item. This letter will automatically be underlined in the the menu. As shown in figure.

 

The two most important properties for menu controls are: • •

 Name — This is the name you use to reference the menu menu control from code. Text — This is the text that appears on the control.

9|Page COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

CREATING SUB MENU ITEMS We can simply add the sub menu items by single clicking on the menu item. Its sub menu  boxes will automatically highlighted. Click on a sub menu box and write the name of your  sub menu. As in figure:

 

By following this procedure you can create your desired sub menus. Note: A menu control cannot be a separator bar if it is a menu title, has submenu items, is

checked or disabled, or has a shortcut key.

10 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

CREATING MENUS WITH THE ITEMS COLLECTION EDITOR  

You can use the Items Collection Editor to create new menus and menu bars, add

new comman commands ds to existi existing ng menus, menus, replace replace existi existing ng menu menu comman commands ds with with your your own own commands, and change and delete existing menus and menu bars.

TO CREATE MENU CONTROLS IN THE ITEMS COLLECTION EDITOR  1. Se Sele lect ct the the MDI MDI form form.. 2. From the the menu bar, bar, right right click on the menu menu item, you you want want to add sub sub items. items. 3. Select ‘Edit Drop Down Items’ 4. In the the Sel Selec ectt item item box, box, sel selec ectt ‘Menu item’ and click on ‘add’. 5. A ‘Tool Strip Menu Item’ will add to the list. In the property window type the text in the ‘Text’ property for the first menu item that you want to appear as the sub menu. 6. In the Name Name text box, box, type the the name that that you will will use to refer to the the menu contr control ol in code. 7. Click Click the up arrow arrow or down arrow arrow buttons buttons to change change the indenta indentatio tion n level of the control. 8. Set other other properti properties es for the control control,, if you choos choose. e. You can do this this in the Items Items Collection Editor or later, in the Properties window. 9. You can can add add multiple multiple items items by by followin following g the same procedu procedure. re. 10. Choose Choose OK to close the Items Items Collec Collectio tion n Editor Editor when you have created created all the menu controls for that form.

11 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

The figure shows the working of Editor.

The menu titles you create are displayed on the form. At design time, click a menu title to drop down its corresponding menu items.

SEPARATING MENU ITEMS A separator bar is displayed as a horizontal line between items on a menu. On a menu with many items, you can use a separator bar to divide items into logical groups. For  example, the File menu in Visual Basic.Net uses separator bars to divide its menu items into three groups, as shown in figure:  

Separator bars

12 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

 

TO CREATE A SEPARATOR BAR IN THE MENU ITEMS   1. If you are addin adding g a separat separator or bar to an existin existing g menu, menu, which has has sub menu items items,, then right click on the menu item and select ‘Edit DropDownItems’ DropDownItems’.

13 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

 

14 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

2. An Items Items Collect Collection ion Editor Editor Box will will open. open. Select Select separato separatorr from from ‘select ‘select item item and add to list below’ and click on add. A separator will add at the last. Choose your  desired position of separator bar by clicking on ‘up’ or ‘down’ button. As shown:

3. Choose OK to close the Items Collection Editor. Note: Although separator bars are created as menu controls, they do not respond to the

Click event, and users cannot choose them.

15 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

ASSIGNING ACCESS KEYS AND SHORTCUT KEYS You can improv improvee keyboa keyboard rd access access to menu menu comman commands ds by defini defining ng access access keys keys and shortcut keys.

ACCESS KEYS Access keys allow the user to open a menu by pressing the ALT key and typing a  

designated letter. Once a menu is open, the user can choose a control by pressing the letter  (the access key) assigned to it. For example, ALT+F might open the File menu, and S might select the Save menu item. As shown in Figure.

16 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

TO ASSIGN AN ACCESS KEY TO A MENU CONTROL IN THE MENU EDITOR  1. Select the the menu menu item to which which you want to assign an access access key. 2. In the Text Text box, type type an ampersand ampersand (&) (&) immediate immediately ly in front of the letter letter you want to be the access key. For example, if the Edit menu shown in Figure is open, the following Caption property settings respond to the corresponding keys.

Menu co control ca caption

Caption pr property

Access ke keys

Cut

Cu&t

T

Copy

C&opy

O

Paste

&Paste

 p

Delete

De&lete

l

Select All

Select &All

a

Time/Date

Time/&Date

d

Note: Do not use duplicate access keys on menus. If you use the same access key for 

more than one menu item, the key will not work. For example, if C is the access key for   both Cut and Copy, when you select the Edit menu and press C, the Copy command will  be selected, but the application will not carry out the command until the user presses ENTER. The Cut command will not be selected at all.

17 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

SHORTCUT KEYS Shortcut keys run a menu item immediately when pressed. Frequently used menu items  

may be assigned a keyboard shortcut, which provides a single-step method of keyboard access, rather than a three-step method of pressing ALT, a menu title access character, and then a menu item access character. Shortcut key assignments include function key and control key combinations, such as CTRL+F1 or CTRL+N. They appear on the menu to the right of the corresponding menu item, as shown in Figure.

 

TO ASSIGN A SHORTCUT KEY TO A MENU ITEM   1. Open Open tthe he Item Itemss Colle Collectio ction n Edit Editor. or. 2. Se Sele lect ct the the men menu u item item.. 3. Select a functi function on key or key combinatio combination n in the the Shortcut Shortcut combo combo box. box. 4. To remove remove a shortcut shortcut key assignm assignment, ent, choose choose "(none)" "(none)" from from the top top of the list. list. 5. You can can simpl simply y set the the short shortcut cut keys keys by by the the ‘shortcutkeys’ option in the property window.

18 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

INTRODUCTION ABOUT THE PROJECT “AIRWAYS RESERVATION SYSTEM” This project is to develop software for a Reservation officer at the platforms. The first module is about the personal records of the users and other staff. I have consulted a officer  of the Airways, who explained me about the existing working system & provided me relevant source from time to time. He told me about the earlier working in which all the tasks were carried out manually. He wanted me to computerize the whole thing. This project is aimed to overcome the drawbacks of the existing Reservation System and related Queries. Appropriate inbuilt checks in the software minimize the chance of wrong data input. Software incubates alerts and is loaded with password facility for authorized users only. Varied screens are incorporated for reports, queries and addition of records. The 2nd module of this project is to automate all the functioning of Airways Reservation System for Airways Ticket Booking office or may be for other organization with minor  modifications. We ha have ve tried tried ou ourr be best st an and d all th thee effor efforts ts to co comp mput uter erize ize th thee syste system m after after ke keen enly ly conducted system study.

19 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

APPLICATION AREA AND END USER

 

This project is applicable to work of persons working in the Airport Reservation

Office and do the work of booking of tickets (data storage), and the required reports are created. Till now they used to follow the old manual methods of storing and collecting data through registers which was very tedious and time consuming. This software can be easily used by them as it aims at providing them with a record of all the tickets booked in the city and also help them them in feedin feeding g relevan relevantt inform informati ation on which which can be recalle recalled d whenev whenever  er  required. Also by using this we can cancel the reservation if needed. It also generates relevant reports and queries which may be required by them. Thus, it can be successfully used by the end users i.e. office bearers.

20 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

PROBLEM DEFINITION

The definition of our problem lies in manual system and a fully automated system. Manual system: The system is very time consuming and lazy. This system is more prone

to errors and sometimes the approach to various problems is unstructured. Technical system: With the advent of latest technology if we do not update our system

then our business result in losses gradually with time. The technical systems contains the tools of latest trend i.e. computers printers, fax, Internet etc. The systems with this technology are very fast, accurate, user-friendly and reliable.

 

TECNICAL SYSTEM

21 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DIFFICULTIES IN THE EXISTING SYSTEM Duee to manu Du manual al pr proc oced edu ure re,, ex exis isti tin ng sy syst stem em doe oess not work work ac acco cord rdin ing g to specifi spec ificati cations ons.. The slow slow process processing ing due to manual manual proced procedure ure leads leads to ineffi inefficien cientt and inconsistency of the system.



In the current system some entries are done at more than one place, which leads to wastage of manpower, time and cost.



If any updating has to be done in the present system, the changes have to be done at so many places. Entries have to be done in a number of registers, which makes the procedures very cumbersome.



In Existing system, there is no way to restrict unauthorized access to the



date except putting the files under lock and key. Present System does not support any type of integrity constraints e.g. it does not specify any data type for any data item. i.e. even alphabet alphabetic ic entries can  be done where only numeric are allowed.



In existing system user can skip any valuable information.



It is very difficult to get up to date information in the existing system. If any information is required for any specific purposes, all these sorting has to be done manually and data is re-entered at some other places in the stored order.

22 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

OBJECTIVES OF THE PROPOSED SYSTEM Afterr thorou Afte thoroughl ghly y analyz analyzing ing the existi existing ng system system,, follow following ing ob object jective ivess of the propos proposed ed system have been set:



Controlling redundancy in storing the same data multiple times.



Smooth flow of data without many hurdles.



Adequate validation checks for data accuracy.



Facilitate input of data efficiently and accurately.



Facility to update the data from time to time.



Prompt and specific retrieval of data.



Flexibility in the system according to changing environment.



Adequate security of data.



Application must be most informative to users.



To develop an easy and efficient solution to record the information about the students and teachers in the school.



Generating Reports periodically for better decisions

In order to overcome difficulties faced in present system a new system is proposed. The new system involves the complete computerization of Reservation Office Informationcum-Automat cum-Au tomation ion System. System. The computerizat computerization ion comprises comprises of development development of software, software, which whi ch mainta maintains ins and updates updates the comple complete te databa database se of Reserva Reservatio tion n and user account account.. Softwa Sof tware re is being being develo developed ped in VB and SQL Server Server 2005. 2005. This This projec projectt is aimed aimed to overcome the drawbacks of the existing Airways Reservation System and related queries. This project can manage overall records of the reservation of air tickets.

23 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

NEED OF AIRLINES SYSTEM A few factors that directs us to develop a new system are given below -: 1) Faster System 2) Accuracy 3) Reliability 4) Informative 5) Reservations and cancellations from anywhere to any place

24 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

SYSTEM STUDY

FEASIBILITY STUDY

Feasibility study is to check the viability of the project under consideration. Theoretically va vari riou ouss ty type pess of fe feasi asibi bili litie tiess are co cond nduc ucte ted, d, bu butt we ha have ve co cond nduc ucte ted d th thre reee ty type pe of  feasibilities explained as under. ECONOMIC FEASIBILITY FEASIBILITY

With the manual system the operating cost of the system is about 60 Lacks P.A. This cost comprises salary of 25 people, stationary, building rent, electricity, water, telephone etc. But with the new system this reoccurring cost comes out to be about 20 Lacks P.A. Hence the new system is economically feasible. TECHNICAL FEASIBILITY FEASIBILITY

The new system requires only 6 trained person to work with the system and in overall 10  people per office are sufficient. So we will identify 6 best people from existing system and train them. As our existing system is purely manual, so we need a one time investment of  Rs 4 Lacks for the purchase of 7 computers, 5 Ticket printers, a laser printer, AC and networking etc. It requires 20 Lacks PA as a operating cost. With the above details our  system is technically feasible as after investing 24 lacks in a year, the company is still saving Rs 25 Lacks PA. OPERATIONAL FEASIBILITY

The new solution is feasible in all sense but operationally it is not. The new system demands the expulsion of at least 15 people from the company. It creates an environment of joblessness and fear among the employees. It can lead to an indefinite strike in the company also. So the management must take corrective actions prior in advance in order to start the further proceedings.

25 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

SYSTEM ANALYSIS This was the most important phase of my project life cycle .It had connected my maximum time. The block diagram given below depicts various fact which were understood by one during the analysis phase.

 

BLOCK DIAGRAM

26 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

SYSTEM DESIGN

In this phase initially I had designed E-R diagram of the processes, in order to identify variouss entities variou entities and relationship relationship set, entity set, attributers, attributers, link attributes attributes The Diagram Diagram of  this process as under. After this step .We had tried design the data base for the new system and normalized it. The tables motivated in data dictionaries enclosed as annex II is an outcome of this step. The symbols of entities are shown below:

 

27 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

28 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

29 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM  

30 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAMS (DFDS)

31 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAM (DFD)

A data flow diagram diagram (DFD) is a graphical representation representation of the “flow” of data through through an information system. A data flow diagram can also be used for the visualization of data  processing. It is common practice practic e for a designer to draw a context-level DFD first which shows the interaction between the system and outside entities. This context-level DFD is then “exploded” “exploded” to show more detail of the system being modeled. modeled. Therefore, Therefore, the DFD  provides a mechanism for functional modeling as well as information flow modeling. In so doing it satisfies the second operational analysis principle.

Symbols used in DFD Data Fl Data Flow ow Di Diag agram ramss are co comp mpos osed ed of th thee fo four ur ba basic sic symb symbol ols. s. Thes Thesee Symb Symbol olss are described in the table given below:

Symbols

Description A Rectangle defines a source or destination of system data. A Circ Circle le or a Bub ubbl blee re rep pre rese sent ntss a pr proc oces esss th that at transforms the incoming data flows into outgoing data flows. An open Rectangle is a data store: data at rest, or a temporary repository of data. Arrows represents the flow of data in a system. It is a  pipeline through which the information flows.

 

32 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAM OF AIRWAYS RESERVATION SYSTEM

33 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAM OF GENERAL ENQUIRY SECTION

34 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAM OF PASSENGER ENQUIRY SECTION

35 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAM OF BOOKING

36 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

 

37 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DATA FLOW DIAGRAM OF CANCELLATION

38 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

 

TABLES USED

39 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

1.

Useraccount

Column Name

Data Type

Userid

Varchar(10) primary key,

Username

Varchar(20),

Password

Varchar(10),

Accounttype

Varchar(15)

2.

Flightsinfo

40 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Column Name

Data Type

FlightNo

varchar (10) primary key,

FlightDescription

varchar (20),

Origin

varchar (20),

DepartureTime

varchar (15),

Destination

varchar (20),

ArrivalTime

varchar (15),

Duration

varchar(15),

TotalSeatsInFC

int,

TotalSeatsInBC

int,

TotalSeatsInEC

int

 

3.

Reservation 41 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Column Name

Data Type

PNRno

Varchar(30) primary key,

TicketNo

Varchar(30),

FlightNo

Varchar(30) foreign key references flightsinfo (flightno)

PassportNo

Varchar(30),

DepartureTime

Varchar(30),

ArrivalTime

Varchar(30),

DateofIssue

Varchar(30),

DateofJourney

Varchar(30),

Class

Varchar((30),

Fare

Varchar(30),

ModeofPayment

Varchar(30),

Status

Varchar(30)

4.

Pnrstatus 42 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Column Name

Data Type Varchar(30) foreign key references

PNRno

reservation(PNRno),

PName

Varchar(30),

Gender

Varchar(30),

Age

Varchar(30),

Category

Varchar(15)

43 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

SNAPSHOTS

44 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

FRONT END DESIGN The Front End should be so that user who has the proper access to the Software can easily interface with the forms. The user should give a valid Username and the Password to get the access to the Airways Reservation System Software. After that, he will have the access to every Form of the Software. THE SPLASH SCREEN OF OUR SOFTWARE IS AS FOLLOWS:

  Splash Screen

45 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

THE MDI FORM

This is the main form i.e. MDI form of the Airways Reservation System Software. On the top, there is Menu Bar from which various options to operate and access the Software can  be selected. But initially, only the first menu option i.e. “Login” is highlighted and the User is restricted to perform any other operation. On clicking the Login menu option, a “Login Form” gets loaded on the screen and the user is prompted to type in user-id and  password. If the user is authorized one, he will be allowed to access and operate the software. There are two types of users allowed…”ADMINISTRATOR” and “USER”. An “ADMINISTATOR” can perform all the transactions on software but a “USER” has only restricted privileges.

46 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

LOGIN SCREEN

This is the Login Form. Only after entering the valid username and password, the user can access the Airways Reservation System SOFTWARE; otherwise a message of invalid user serid or passw ssword is displayed to the Use serr. Ther eree are two types of use serrs allowed…”ADMINISTRATOR” and “USER”. An “ADMINISTATOR” can perform all the transactions on software but a “USER” has only restricted privileges.

47 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

On entering the wrong password, the user will not be allowed to access the Reservation Software. The message screen in this case would be like as:

48 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

The Main Form Once the user is logged in as an authorized user, the main form with all the privileges assigned to the appropriate user will be enabled. If the user is “ADMINISTRATOR”, then all the menu bar options are enabled. The screen in this case would be as follows:

49 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Otherwise if the user is logged in as a “STANDARD USER, the main form with all the  privileges assigned to the appropriate user will be enabled. In this case only some of the menu bar options are enabled. E.g. A “USER” can’t make additions or deletions in the  back end. The screen in this case would be as follows:

50 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

The various menu bar options are as follows:

1. Us User er Acco Accoun untt

Create New User 

 

51 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Modifying Password A user can modify his password by selecting the “Modify password” option from “User Account” drop down menu.

52 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Delete Account Only Administrator can do the operation of deleting the existing account. This option can  be selected from “User Account” drop down menu option.

53 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

To Add, Modify and Delete users

These operations also can be done only by “ADMINISTRATOR”. These various options can be selected from “User Account” drop down menu option.

54 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Giving Tool Tip for each option This option is for user’s better understanding. As below, the box showing “Enter Your Name” is the tool tip.

55 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

2. RESERVATION SCREEN This form is for booking of of Airways tickets. The Pnr No. and Ticket No. will be generated automatically. Initially only Flight Description box is enabled.

56 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

 As we select Flight Description, Origin and Destination would become highlighted. When we select Origin and Destination, the other options would be enabled. As in figure:

57 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Data is saved After pressing ‘Submit’ button, the data will be saved in the Reservation table in the database if all the fields are filled by the administrator.

58 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Cancel the Reservation Administrator can also do the job of cancellation of the ticket in the case when the person which has already booked a ticket has no longer needed the ticket. In this case some cancellation charges would be taken from the person.

59 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

3.

ENQUIRY  Flights Info

This option can be used by both Administrator and Standard user. By entering flight description, origin and destination, the relevant information can be taken.

60 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM Get Availability

We can get the availability of seats by clicking ‘Get Availability’ button. As:

Get Fair 61 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

We can also check the fare of selected class by clicking the ‘Get Fare’ button. As:

62 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Seats Availability We can check the information of seats availability by clicking the ‘Enquiry’ menu and selecting ‘Seats Inquiry’. Firstly we have to select Description and then Origin, Destination and then Journey Date. As:

After clicking ‘Get It’ we can get the required seats information. As:

63 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

PNR Status 64 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM For checking if the seat is reserved or being cancelled, we can do this job by click  ‘Enquiry’ from menu and selecting ‘PNR Status’. We have to enter only our PNR no. and

click on ‘Get it’. Our flight’s information and Status will be shown to us. As in figure:

4. WINDOWS 65 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM If multiple windows are opened, and we want to arrange these windows as Vertically, Horizontally or in Cascade mode, then we can do this job by pressing ‘Windows’ option from menu and selecting ‘Vertical’ or ‘Horizontal’ or ‘Cascade’.

Vertical windows

Horizontal windows

66 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

Cascade windows 67 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

5. REPORTS

Types of Reports 68 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM



Domestic Fares



Domestic Reservation



International Fares



International Reservation



Cancelled Reservation



Reservation By Date



Reprint Ticket

DOMESTIC FARES REPORT

69 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

DOMESTIC RESERVATION REPORT

70 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

INTERNATIONAL FARES REPORT

71 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

INTERNATIONAL RESERVATION REPORT

72 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

CANCELLED RESERVATION REPORT

73 | P a g e COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

RESERVATION BY DATE REPORT

74 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

REPRINT TICKET REPORT

75 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

ABOUT US

76 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

TESTING

77 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM The purpose of system testing is to identify and correct errors in the new system. Testing is an important phase of system development life cycle. System testing was conducted in order to detect errors and for comparing then the final system with the requirement specification reports, i.e. whether the system meets requirements. During testing the software was executed with the set of test cases and the output of programs for the test cases was evaluated to determine if the program is  performing as it was expected to. Testing Test ing presen presents ts an intere interestin sting g challe challenge nge for the softwa software re engine engineers ers attempt attempt to build build softwa sof tware re from from an abstra abstract ct concep conceptt to an accepta acceptable ble implem implementa entatio tion. n. In testing testing engineer engin eer create a series of test cases that occurs when errors are uncovered. uncovered. Testing is the process of executing a program for finding errors. A good test is one that has the high probability of finding an uncovered error. A successful error is one that uncovers undiscovered errors. There are two methods for testing:   1. Whit Whitee Box Box Test Testin ing g 2. Blac Black k Box Box Test Testin ing g

WHITE BOX TESTING

White box testing of software is predicate on close examination of procedural details. Logical paths through the software are tested by providing test cases that exercise specific set of conditions and loops.

BLACK BOX TESTING

Black box tests are performed to access how well a program meets its requirements, looking for incorrect or missing functionality. Functional tests typically exercise code with valid or nearly valid input for which the expected output is known. This includes concepts such as ‘boundary values’.

78 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

BIBLOGRAPHY

These are some of the text material that I have referred during the course of our application development. Besides I have also referred notes from various other books and explored the internet for the same. Books Referred

1. System System Analys Analysis is and Design Design

Pu Punee neett Wadhwa Wadhwa

2. Progra Programmi mming ng in Visual Visual Basic Basic

Gabriel Gabriel Oancea Oancea

3. Visual Visual Basic Basic Project Projectss

Som Somma ma Dassgup Dassgupta ta

Sites Referred

1. http http:/ ://w /www ww.w .w3s 3sch choo ools. ls.co com m 2. http http:/ ://w /www ww.k .kid idwa ware re.c .com om 3. http http:/ ://w /www ww.s .scri cribd bd.c .com om 4. http http:/ ://en /en.w .wik ikip ipedi edia. a.or org g

79 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

 

AIRWAYS RESERVATION SYSTEM

SPECIAL THANKS

It is my proud to express our heart felt gratitude to our  H.O.D of  CSE Department Er. Collegee of Engine Engineerin ering g and Manage Managemen ment, t, Kapurt Kapurthal halaa for giving giving me Balkrishan at Colleg suggestions regarding the project. I also thanks to the Project Guide Mr. Jatinder Singh (NIIT Sr. Faculty) under whose guidance the project is carried out successfully. I also give special thanks to all the lecturer’s lecturer’s of College of Engineering Engineering and Management Management for giving me chance to develop a project. They helped me in almost every field of study.

80 | P a g e

COLLEGE OF ENGINEERING AND MANAGEMENT KAPURTHALA

Sponsor Documents

Or use your account on DocShare.tips

Hide

Forgot your password?

Or register your new account on DocShare.tips

Hide

Lost your password? Please enter your email address. You will receive a link to create a new password.

Back to log-in

Close