Search icone
Search and publish your papers

Airline ticketing system

Or download with : a doc exchange

About the author


About the document

Published date
documents in English
56 pages
2 times
Validated by
0 Comment
Rate this document
  1. Introduction
  2. Purpose and overall description
  3. Functional requirements
  4. Non-functional requirements
  5. Future scope
  6. Analysis models
    1. Data dictionary
    2. Use cases
    3. User interface
  7. Conclusion

Before modern computing, the reservation system was done using manual means. This meant that a person about to travel had to spend a lot of unnecessary time waiting in queues in order to book their tickets. The manual process of reservation was also prone to human errors, which lead to a lot of dissatisfaction amongst travelers. The Airline Ticketing System proposed in this project will aim to automate the process of booking airline tickets online, thus reducing the time wasted as well as the errors that are involved in the manual process. The system in question will be available online, empowering future travelers to reserve their tickets themselves at the convenience of their on home. From the viewpoint of the Airline Company, the aims are to minimize repetitive work done by the system administrator and reservation clerks. Maintain consistency among different access modes, e.g. by phone, by web, at the information desk and across different physical locations. The users should be basically taken through the same steps by the system as they go through in conventional desk-reservation systems i.e. a true model of the physical world. The various access nodes are commonly referred to as channels. Maintain customer information. Maximize the revenue of the airline company by attracting global travelers to the company domain. Increase awareness among frequent travelers about various special offers and discounts. Maintain the capability to adopt a flexible pricing policy. The price of the tickets should be dynamically determined based whether or not the customer is a registered user as well as check whether the user qualifies for any discounts.

[...] The actions that an Administrator is allowed to take are as follows: o Add, Edit or Delete an Airplane o Add, Edit or Delete a Flight o Add, Edit or Delete a Schedule o Add, Edit or Delete a Scheme Operating Environment Hardware Platform The Airline Ticketing System will be available to the User's using the World Wide Web as a means of access. Therefore the system has two aspects, namely the client and the server. The Client: The hardware requirements of the client are as follows: o An Internet Connection o Color Monitor or any other Visual Display Unit o Printer o Mouse and Keyboard for User Inputs The Server: The hardware requirements for the server are as follows: o Multiple storage devices based on necessity o A minimum of 512 MB of Random Access Memory o Connection to the World Wide Web Software Platform The Client: The software requirements of the client are as follows: o Operating System o Web Browser The Server: The software requirements of the server are as follows: o The Dot Net Framework o Microsoft SQL Server System Context The Airline Ticketing System will provide the following types of easy-to- use, interactive, and intuitive graphical interfaces. [...]

[...] The Airline Ticketing System is based on the flights that the Airline company has. These follow a very precise schedule and are subject to change. The Administrator, who is an authorized employee of the Airlines Company, has the authorization to update the flight details/schedules of a particular flight. Trigger: A request to Update Flight Details Preconditions The User must be logged in as an Administrator. A flight has to exist in order for it to be deleted. When deleting a flight, no tickets can be booked on that flight. [...]

[...] Data Dictionary Constraint: UserName can only begin with Constraint: IX_SCHEMES: Uniqueness maintained in every entry Foreign Key: FK_TICKETS_SCHEME1 Schemes Table FK_TICKETS_FLIGHT Flight Table FK_TICKETS_SCHEDULE1 Schedule Table Constraints: IX_Schedule: Uniqueness maintained in every entry Foreign Keys: FK_FLIGHT_SCHEDULE: Schedule Table FK_FLIGHT_AIRPLANES: Airplane Table Constraints: IX_FLIGHT: Type_ID and ScheduleID must be Unique Foreign Keys FK_USERTABLE_TICKETS: Ticket Table FK_USERTABLE_REGISTERED: Registered Table Stored Procedures AddAirplaneProc: CREATE PROCEDURE AddAirPlaneProc (@model as nvarchar @typeid as nvarchar @capacity as nvarchar(50)) AS Insert into Airplanes values(@model,@typeid,@capacity) addScheme: CREATE PROCEDURE addScheme(@Scheme_ID as nvarchar(50),@Miles as nvarchar(50),@Discount as nvarchar(50) AS insert into Schemes values (@Scheme_ID,@Miles,@Discount); authenticateAdmin CREATE PROCEDURE authenticateAdmin (@UID nvarchar @password nvarchar(25) ) AS select * from Administer where Admin_id=@UID and Password = @password; DeleteAirplane CREATE PROCEDURE DeleteAirplane (@typeid as nvarchar AS delete from Airplanes where type_id = @typeid DeleteFlight CREATE PROCEDURE DeleteFlight (@Flight_NO as nvarchar(50)) AS delete from Flight where Flight_NO = @Flight_NO DeleteSchedule CREATE PROCEDURE DeleteSchedule (@ScheduleID as nvarchar(50)) AS Delete from Schedule where ScheduleID= @ScheduleID DeleteScheme CREATE PROCEDURE DeleteSchedule (@ScheduleID as nvarchar(50)) AS Delete from Schedule where ScheduleID= @ScheduleID ForgotPassword CREATE Procedure ForgotPassword(@UserID nvarchar(50), @Question nvarchar(100), @Answer nvarchar(100)) as select Password from Registered where User_ID=@UserID and Question=@Question and Answer=@Answer getDestinationCities CREATE PROCEDURE getDestinationCities(@DepartureCity nvarchar(50)) as Select distinct(ArrivalCity) from Flight where DepartureCity=@DepartureCity order by ArrivalCity getReturnTrip CREATE PROCEDURE getReturnTrip (@DepartureCity nvarchar @ArrivalCity nvarchar AS Select f.Flight_NO as 'Flight Number', s.Departure_Time as 'Departure Time', s.Departure_Day as 'Departure Day', s.Arrival_Day as 'Arrival Day', s.Arrival_Time as 'Arrival Time', f.price as 'Price' from Flight Schedule s where f.DepartureCity= @DepartureCity and f.ArrivalCity=@ArrivalCity and f.ScheduleID=s.ScheduleID getSchedule CREATE PROCEDURE getSchedule (@DepartureCity nvarchar @ArrivalCity nvarchar @Departure_Day nvarchar(10)) AS Select f.Flight_NO as 'Flight Number', s.Departure_Time as 'Departure Time', s.Arrival_Day as 'Arrival Day', s.Arrival_Time as 'Arrival Time', f.price as 'Price' from Flight Schedule s where f.DepartureCity= @DepartureCity and f.ArrivalCity=@ArrivalCity and s.Departure_Day =@Departure_Day and f.ScheduleID=s.ScheduleID getScheduleDetails CREATE PROCEDURE getScheduleDetails(@ScheduleID as nvarchar(50)) AS select * from schedule where ScheduleID=@ScheduleID getSeatsAvailable CREATE PROCEDURE getSeatsAvailable (@FlightNO nvarchar @DepDate as datetime) as Select Seats from Flight_Bookings where Flight_NO=@FlightNO and Departure=@DepDate getSourceCities CREATE PROCEDURE getSourceCities AS Select distinct(DepartureCity) from Flight order by DepartureCity getTicket CREATE PROCEDURE getTicket(@PNR int) as Select f.flight_NO as 'Flight Number',t.TicketNo as 'Ticket Number' ,u.FName+' '+u.LName as 'Name', f.DepartureCity as 'Departure City' ,substring(cast(t.Departure_Date as nvarchar),0,10) as 'Departure Date' , s.Departure_Time as 'Departure Time', f.ArrivalCity as 'Arrival City' ,s.Arrival_Time as 'Arrival Time' from Flight Tickets UserTable u,Schedule s where t.TicketNo=@PNR and t.TicketNo=u.TicketNo and t.FlightNo=f.Flight_NO and t.ScheduleID=s.ScheduleID InsertFlight CREATE PROCEDURE InsertFlight (@Flight_NO as nvarchar(50), @Type_ID as nvarchar(50),@DepartureCity as nvarchar(50), @ArrivalCity as nvarchar(50),@Miles as nvarchar(50), @price as nvarchar(50), @schid as nvarchar(50)) ASinsert into Flight values (@Flight_NO ,@Type_ID ,@schid, @DepartureCity ,@ArrivalCity, @Miles, @price) InserScheduleProc CREATE PROCEDURE InsertScheduleProc(@scheduleid as nvarchar(50),@departureday as nvarchar(10),@departuretime as nvarchar(50), @arrivalday as nvarchar(10),@arrivaltime as nvarchar(50)) AS insert into Schedule values (@scheduleid ,@departureday,@departuretime , @arrivalday,@arrivaltime) insertreg_user CREATE PROCEDURE insertreg_user (@User_ID nvarchar(50),@Password nvarchar(50),@First_Name nvarchar(50), @Last_Name nvarchar(50),@Address nvarchar(50),@Phone nvarchar(50),@Miles real, @Question nvarchar(100), @Answer nvarchar(100) ) AS insert into Registered Values(@User_ID,@Password,@First_Name ,@Last_Name, @Address,@Phone,@Miles, @Question, @Answer); retrieveuser CREATE PROCEDURE retrieveUser (@User_ID nvarchar(50), @Password nvarchar(50)) as Select * from Registered where User_ID =@User_ID and Password =@Password showScheme CREATE PROCEDURE showScheme(@Scheme_ID nvarchar(50)) as select * from Schemes where Scheme_ID=@Scheme_ID; UpdateAirplaneProc CREATE PROCEDURE UpdateAirPlaneProc (@model as nvarchar @typeid as nvarchar @capacity as nvarchar(50)) as Update Airplanes set model=@model,capacity=@capacity where type_id=@typeid updateFlight CREATE PROCEDURE updateFlight (@Flight_NO as nvarchar(50), @Type_ID as nvarchar(50),@DepartureCity as nvarchar(50), @ArrivalCity as nvarchar(50),@Miles as nvarchar(50), @price as nvarchar(50), @schid as nvarchar(50)) AS update Flight set Flight_NO=@Flight_NO , Type_ID=@Type_ID , DepartureCity=@DepartureCity , ArrivalCity=@ArrivalCity, Miles=@Miles, Price=@price, ScheduleID=@schid where Flight_NO=@Flight_NO UpdateregUser CREATE PROCEDURE UpdateRegUser(@User_ID nvarchar(50), @Password nvarchar(50),@Address nvarchar(200),@Phone nvarchar(50) ) AS update Registered set Password=@Password, Address=@Address, Phone=@Phone where User_ID=@User_ID UpdateSchedule CREATE PROCEDURE UpdateSchedule(@ScheduleID as nvarchar(50), @DepartureDay as nvarchar(10), @DepartureTime as nvarchar(50),@ArrivalDay as nvarchar(10),@ArrivalTime as nvarchar(50))AS Update Schedule set Departure_Day=@DepartureDay,Departure_Time=@DepartureTime,Arrival_Day=@Arriv alDay,Arrival_Time=@ArrivalTime where ScheduleID=@ScheduleID UpdateScheme CREATE PROCEDURE UpdateScheme (@SchemeId as nvarchar(50), @miles as nvarchar(50), @discount as nvarchar(50)) as update schemes set miles=@miles, discount=@discount where Scheme_ID= @SchemeId Use Cases For Airlines Ticketing Guidance for Use Case Specification This section provides a description of each section in the use case. [...]

Similar documents you may be interested in reading.

Online airline reservation system

 Science & technology   |  Computer science   |  Thesis   |  04/16/2009   |   .doc   |   49 pages

Consumers' behaviour of 18-26 years old of the European Union and the low-cost European airline...

 Business & market   |  Marketing   |  Thesis   |  09/29/2010   |   .doc   |   53 pages

Recent documents in computer science category

Net neutrality in United States

 Science & technology   |  Computer science   |  Presentation   |  10/02/2018   |   .doc   |   3 pages

Reconstructing householder vectors from tall-skinny QR

 Science & technology   |  Computer science   |  Presentation   |  04/21/2017   |   .doc   |   4 pages