Project on Airline Reservation System

Non-Functional Requirements of Airline Reservation System:

Performance Requirements:

The performance requirements are as follows:

  • System login/logout and all transactions shall take  less than 10 seconds.
  • Searches shall return results within 5-10 seconds.
  • All Bookings shall be processed within 5-10 seconds.
  • Application shall support 500 users at a time.

Logical Database Requirements:

There are various functions in the website that require the interface of a database. The three Tables below show the different types of information used by various functions, their frequencies of use, and the data entities and their relationships, respectively.

Expected Frequency of Function Used by Users

The figure below illustrates the anticipated number of users utilizing functions during peak time.                                             

Function Frequency of Use
Registration Function 100 –150 users
Account login Function 200 – 300 users
Search (Schedule & Status) 250 – 300 users
Update account info   50 – 100 users
Book Flight & Reserve   50 – 100 users

 Data Entities and their Relationships:

The data entities and the relationships table describe the attributes of the types of data that shall be sent to the database.

 

Table Names

 

Column Lengths

City Information

 – Airport Code

– Airport Name

– City Name

– State

– Zip code

10 characters

20 characters

20 characters

15 characters

10 digits

Flight Bookings

Book Flight ID

– Flyer Number

– Flight Schedule ID

– No of Seats     

10 digits

15 characters

10 digits

10 digits

Hotel BookingHotel name-Hotel ID

-Number of persons

20 characters

2 digits

2 digits

 

Flight Information

 – Flight Number

– Flight Name

– No of seats

 8 characters

20 characters

4 digits

 

Flight Schedules

 Flight Number

– Flight Schedule ID

– Flight Departing Time

– Flight Arrival Time

– Origin

– Destination

– Flight Status

– Cost

– Reserve Seats

– Booked seats

– Left Seats

– No  of miles

 

10 digits

20 characters

Date time

Date time

15 characters

15 characters

15 characters

5 digits

4 digits

4 digits

4 digits

6 digits

User Information

– Username

– Password

– Address

– Zip Code

– E-mail

– Phone Number

 

15 characters

8 characters

25 characters

10 digits

15 characters

13 digits

Design Constraints

The Airline Reservation System shall conform to the following design constraints:

  • Able to support all operating platforms like Windows, Linux, Mac etc.
  • System logs out user after a ten minute inactivity period. 
  • System supports all web browsers (i.e. both graphical and non-graphical like Mozilla, IE, Google Chrome).

Reliability:

         The system will have redundant hardware. In the event of a website outage, support personnel will respond within 30 minutes. In the event of a less severe problem support personnel will respond within 3 hours.                                                                              

Availability:

Airline Website application will be available to Customers with access to the Internet.

 Security:

Customers will be able to access only their own personal information and not that of other Customers. Payments will be handled through a server to ensure the protection of user’s credit card and personal information.

Maintainability:

This product shall be maintained by an administrator in case of any defect. In addition, any update or change that is made will be changed on server-side computers without any patches required by the Customer.

Hotel Room Booking System Project Report

The main aim & objective of this Hotel Room Booking System Project is to give simple application which provides all facilities like room booking, room class type, hall booking, hotel booking, etc…
These are the below methods used in this project

  • Book Hotel
  • Book  Flight + Hotel
  • Logout
  • Account Update

Stimulus: Book Hotel

Click “ Book  Hotel” :

Description: This “Book  Hotel” function allows a user to book a hotel. The user enters  the   destination, check-in date(dd/mm/yyyy), check-out date (dd/mm/yyyy), the number of rooms needed and the number of people who will stay in the hotel.
Inputs: The user enters  the   destination, check-in date(dd/mm/yyyy), check-out date (dd/mm/yyyy), the number of rooms.
 Outputs: It displays available on a webpage.

Source: Inputs provided by the user or saved data.

 Pre-condition: The user is within his/her account and website.

Post condition: The user can select the hotel from the choice of hotels and can proceed to payment

Side-effects: None.

 Stimulus: Book  Flight + Hotel

Click “Book Flight + Hotel”

Description: From the home page, the user can select Book Flight + Hotel. This will take them to a page which will contain a form in which they can input the flight and hotel information..

Inputs: Source, Destination, Departure date, Return date, number of travelers, one way and round trip, check-in date, check-out date, number of people staying and number of rooms needed. For new user, first name, last name, middle name (if any), date of birth, gender, mailing address, billing address, and email.
Outputs: A list of deals satisfying the criteria will be displayed by prices from the lowest to the highest.

Source: The input will come from the keyboard

Pre-Condition: The user should be logged in.

Post-Condition:  The database will be updated with the flight request information. After the user is done with this page, they must press the “Make Payment” button to move to the next page.

Side-effects: None.

Stimulus:  Logout

Click “Logout”.

Description:  The “Logout” function allows a user to quit/exit from his/her account for secured reasons.

Inputs: No Inputs

Source: None.

Outputs: No Outputs.

Destination: None.

Requires: User needs to be logged in.

Pre-condition: The user is inside the website and logged in.

Post-condition: User gets logged out.

Side-effects:  None

Stimulus:  Account Update
Click “Update”:

Description:  The “Update” function enables the user to view/update his profile at any time. The user can change his address, phone number, email or password.

Inputs: first name, last name, address, phone number, email, password and credit card information.

Source: All inputs provided by the user.

Outputs: Updated profile.

Destination: The outputs are displayed on the screen.

Requires:  User should have an account.

Pre-condition: The user is inside the website and logged in.

Post-condition: The user has updated information in his/her account.

Side-effects:  None

User Account Logout: The account logout function shall allow users to exit their personal website account for security purposes.  This module allows users to logout their accounts.

Airline Ticket Booking System Project

Airline Ticket Booking System Project was developed by Visual Studio 2003 with C#.net for final year BTech students, Mainly  it has the below functions:

  • Flight Status function
  • Accumulate Mileage function
  • Redeem Mileage function
  • Finding Deals function

 Stimulus:  Flight Status

Click “Flight Status” :

Description:  The customer can use this function to check the status of a flight.

Inputs: Confirmation Number, date, origin and destination.

Source: The input is provided by the user.

Outputs: Date, Departure time, Arrival time, Origin and Destination.

Destination: The outputs are displayed on the screen by retrieving information from the Database.

Requires:  User needs to have a confirmation number while inside the secure website.

Pre-condition: The user is on the website.

Post-condition: The user has viewed the information about flight status and schedule.

Side-effects:  None

Stimulus: Mileage Accumulation

Click “Accumulate Mileage” :

Description: This button allows a user to accumulate mileage that he/she has traveled. Once the user clicks on this button, the current flight mileages adds to the previously traveled mileage.

Input: The data will come from the database

Outputs: User gets the message:” Mileage accumulated successfully”.

Source: The data will be in the database

Pre-Condition: The user should be logged in and traveled recently.

Post-Condition: The miles will be posted to the user’s account in the database

Side-effects: None.

Stimulus: Redeem Mileage

Click “Redeem Mileage” :

Description: After user logs into an account, the function should display a mileage redemption form. This form will have the same fields that exist on the Book a flight page, with the exception that it will display the payment costs in miles instead of other traditional payment methods. 

It will also contain a calendar that shows days that are blacked out from mileage users.

Input: Source station, Destination station, Departure date, Return date, number of travelers, one way and round trip, dates available for rewards travel. For new user, first name, last name, middle name (if any), date of birth, gender, mailing address, billing address, and email

Outputs: User gets the message:” Mileage accumulated successfully”.

Source: The keyboard

Pre-Conditions: The user should be logged in.

Post-Condition: The user will be shown verification information regarding their mileage purchase

Side-effects: None.

 Stimulus: Finding Deals

Click: “Finding Deals”

Description:  This function allows the user to search for deals. The user enters the source, destination, time period that  the user wants to go on a vacation, and the price range.

Input: Scheduled flights on the selected date with origin and destination, class( single/double/), check-in and check-out date and time.        

Outputs: A list of deals satisfying the criteria will be displayed by prices from the lowest to the highest.

Source: All the inputs are provided by the user.

Pre-Condition: The user should be logged in.

Post-Condition: The user has viewed the information about stay schedules  and flight schedule

Side-effects: None.

Feedback Management System Project

This Feedback Management System Final Year Btech/BE/MCA Project has the below functions:

The feedback management module can give customers a means to send/share comments to the client regarding their own experiences on the Feedback Management System website, as well as provide a means to give client a satisfaction rating of the website.This feedback system helps the client know what user experiences are and how to improve the application in future. so that they can enhance their product.

Help Module: The help module shall give the user an overview of how to use the different functions listed above.  This allows the user to get answers to immediate questions on using the website.

Click :”Feedback”

Description : This feedback button allows a user to give feedback of his/her experience with the website.

Input: User enters comments about his/her experience with the system.

Outputs: Output message: “ Thankyou very much for your comment”.

Source: All inputs are provided by the customer.

Pre-Condition : The user should be logged  in.

Post-Condition: To enter the feedback, the user should be the valid  customer/member/registered member of a project.

Side effects: None.

Stimulus:  “Contact Us”

Click “Contact Us”:

Description:  The “Contact Us” module is a customer’s service module. It allows the user to get details like e-mail ids, telephone numbers and toll free numbers of the airline website service.

Inputs: No inputs.

Source: None.

Outputs: E-mail ids and phone numbers.

Destination: The outputs are displayed on the screen.

Requires:  Contact us webpage.

Pre-condition: The user is inside the website.

Post-condition: The user is given with contacts of airline website service.

Side-effects:  None

Stimulus:   “Help”

Click “Help” ;

Description:  The “Help” function shall give the user an overview of how to use the different functions listed above and detailed explanation in a separate window.
Inputs: Queries.
Source: Input provided by the user.
Outputs: Function explanation.

Destination: The outputs are displayed on the screen.

Requires:  Queries to get information.

Pre-condition: The user is inside the website.

Post-condition: Knowledge on use of specified function.

Side-effects:  None

Flight Booking System VB Final Year Project

External Interface Requirements of Flight Booking System VB Final Year Project
User Interfaces: System will provide the ability for users to access the AW online, view flight schedules, book tickets and make payment.

The user must be required to login in order to book a ticket and make payment, while for other purposes he need not be logged in.

He can view the status and schedule of a flight directly, tabs for which are provided on every page. The administrator will be required to log in at all times. However, they will have limit access via the web-interface only being able to pull predefined reports. 

The administrators will have to log in to a host machine inside the AW in order to build reports and ensure backups are running.

Functional Requirements

Stimulus:  Login :

Click “Login” :

Description: The ‘Login’ function allows the user to input the user name and the password. After verifying username and password,

account holder/user can Book flight or Update the account information.

Input: User name and password.

Source: All inputs are provided by the user.

Outputs: successful login/failure login.

Destination: The outputs are displayed on the webpage.

Requires: User needs to fill in login information inside secure website.

Pre-condition: The user is inside the website and has a Username and Password.

Post-condition: successful login/failure login

Side-effects:  None

Stimulus: Register:

Click “Register”:

Description:  The “register” function allows users to create accounts.  

Inputs: The user name, address, phone number, email (userID) and password.

Source: All inputs are provided by the user.

Outputs: The user name, current address, permanent address, phone number, email (userID) and password.

Destination: The outputs are displayed on the screen (webpage) and store the data into the Database.

Requires: User needs to fill out His/her information inside the website.

Pre-condition: The user is inside the website and not an account holder.

Post-condition: The user is an account holder that has a valid username and password to login with, as well as stored personal

information (inputs) in the Database.

Side-effects:  None

Hotel Management System Project in VB

Hotel Management System Final Year Computer Science Engineering student Project was developed in VB.Net is the front-end & MS Access is the back end. This project has the below modules:

Hotel  Booking Module:

Customers will be able to search through available hotels and costs of rooms. The restaurant search function shall offer users the ability to search for hotels by supplying desired location in the city of destination, desired room size and standard, and the price range.

Once restaurant’s that meet the user’s specifications are located, their location, room sizes and standards and pricing information will be displayed to the user for the user to select the actual restaurant and room he/she desires to lodge in.

This module offers easy access to a number of available restaurant’s and rooms and gives pricing information for each of them.

Flight Booking Module:

The function allows a user to book a flight and a hotel. A user will get a 30% discount of the total if he/she does so. This module offers easy access to a number of available hotels and rooms and available flights and gives pricing information for each of them.

Make Payment Module:
This module allows user to present payment information after choosing a flight or restaurant. It will bring the user to a page in which they can submit payment information. Once they have agreed, their payment will be processed & will be posted to the database.

The customer must pay at the end of the transaction to complete it. For this, they must enter their payment information and provide agreement to be charged. That is what this function provides.

Travel Management System Project in C#.Net

Travel Management System Project Offers & Deals:

This Project was developed in C#.Net & SQL Server 2000, By using this project we can book airways, train, bus tickets. Mainly this project can be used in all traveling Agencies.

Customers will be able to browse through available travel deals, discounts and offers and corresponding pricing.

This application provides access to lucrative travel deals and offers and gives pricing information for each of them.

Accumulate Mileage:

This module allows a customer to accumulate mileage that he/she has traveled.

By accumulating mileage, the users have an incentive to fly more. This promotes business on the site and allows the site to compete

with other similar sites that offer mileage accumulation

Redeem Mileage:

This module allows a customer to purchase a plane ticket using the mileages accumulated. 50000 miles can be redeemed for a domestic flight and 75000 for an international flight.

The customer has been given the ability to accumulate mileage as the book flights. They must have a way of spending those miles.

This page will present the controlled environment that is necessary for this type of transaction

Account Update:

The update account information function shall give customers access to edit their information.  They can modify name, mailing address, billing address, credit card information, and login password.

This module offers convenience to the customers by allowing changes to account information immediately.

View Booking Status:

The view booking status function shall allow customers to login into their personal website account to check status of booked flight and hotels

This offers convenience to users so they can find out necessary status information to help them prepare for their travel.

Download Travel Management System Project in C#.Net

Greyhound Fleet Manager Using Asp.Net and VB.Net

The ‘Greyhound Fleet Manager’ keeps track the information about the Vehicles, Maintenance, Repair, Parts, Employees, Location and Vendors. It also keeps track the maintenance performed for different vehicles which are used for transportation.

The super users of the system are the ‘ADMIN’ and the ‘MANAGERS’ of the different departments allocated by the admin. The admin may be the owner of the transportation organization or the manager of transportation department of a particular manufacturing company.

If any other vehicle is added to the fleet which already exists for the organization/department the details of the vehicle is added. The details includes whether it is a new one or taken any loan/lease. Database will hold details of new and old employees which include address and phone numbers.

The maintenance to be performed can also be scheduled for each type of vehicles. The details of the parts/inventory used for the vehicles are maintained. The reorder level and the reorder quantity are predefined for each particular type of part.

download  Greyhound Fleet Manager Using Asp.Net and VB.Net.

Airline Reservation System Project Report

This Airline Reservation System Project Report Document uses the following Abbreviations:

Airline Reservation System:    The name of the Final Year Project.
Client:This refers to Airline Reservation System Travel, the company that requested the Airline Reservation System development.
Client Representative:A representative of Airways Travel. Client Representatives will use the website for administrative purposes.
Developer: The company to design and develop the Airline Reservation System.
Customer:    Will refer specifically to anyone that will use the website for booking flights or hotels or both. But we will also use the term ‘user’ for client representatives that will use the website for administrative purposes. We will disambiguate between the external users that use the website for booking from client representatives as necessary.
VeriSign:A Company used by Developer to provide secure online transactions.

Software & Hardware Requirements:

Front End: HTML, Java Script, VB.Net.

Tools: Visual Studio 2005.

Database: MS Access.

Download Airline Reservation System Final Year VB Project Report

Airline Reservation System Project

The purpose of this Software Requirements Specifications (SRS) is to fully document the specifications and requirements for the Airline Reservation System Project, The audience of the Software Requirements Specifications will be the client, Airways Travel (referred to as “client” in this SRS), who wants the software built and the technical Engineers developing the software.

This Airline Reservation System Project will provide the user with the following functions:

I.    Flight Booking System: Paying online for purchase of airline tickets. Customer will be able to choose from a number of available airlines.
II.    Hotel Booking System: Paying online for hotel reservations. Customer will be able to choose from a number of available hotels.
III.    User Website Accounts System: Creating and maintaining an online account on the website, in order to see status and updates on booked flights and hotels.
IV.    Mileage Management System: Accumulating and Redeeming Mileage.
V.    Travel Deals and Offers Purchase System: Paying online for purchase of travel deals and offers.
VI.    Feedback Management System: Submitting comments and website satisfaction rating feedback.

The Airline Reservation System Project will provide the client with the following administrative and auditing functions:

I.    Flights Schedule and Pricing Update: Feeding the Airline Reservation System system with updates of flights schedule and pricing.
II.    Hotels Availability and Pricing Update: Feeding the Airline Reservation System system with updates of hotels availability and pricing.
III.    Travel Deals and Offers Availability and Pricing Update: Feeding the Airline Reservation System system with updates of travel deals and offers.

IV.    Feedback Monitoring and Response: Accessing users’ comments and website satisfaction ratings feedback. And responding to users as necessary.
V.    Income Audit: Viewing purchases summary.

We will not deal with transportation from airport to hotel, car hires, cruises, and any other travel concerns not specifically mentioned above.

The Airline Reservation System will provide easy and straight forward flights and hotels booking for the users, and corresponding administrative facilities for the client.