Airline Reservation System

[attachment=17373]
SYSTEM DESIGN


In this phase initially I had designed E-R diagram of the processes , in order to identify various entities and relation ship set ,entity set ,attributers, page link attributes The 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 out come of this step


ALGORITHM

In this phase further I had designed algorithms for various technical sub problem a few than are enclosed here with.

RESERVATION

• A PERSON COME TO RESERVED ATICKET.



CANCELLATION

• A PASSENGER COME TO CANCEL THE TICKET

• THEN THE SYSTEM OPEN THE DELET FORM

• THEN CLICK SHOE COMMAND

• IT DISPLAY ALL THE PASSENGER LIST

• THEN SELECT THE PNR NUMBER AND CLICK DELET OPTION

• THE SYSTEM SHOW RECORD IS DELETED.


WHEN PASSENGER COME TO RESERVED A TICKET THEN SYSTEM FIND OUT THE FLIGHT DETAILS.

SYSTEM CLICK FLIGHT DETAILS OPTION THEN THE FLIGHT DETAILS FORM OPEN

THOSE SYSTEM ARE FOLLOWED .

FLIGHT_DETALS:-

• . IN FLIGHT DEAILS WE FIRST CREATE A FORM.

• . THEN WE MAKE ALL TEXT BOX.

• . WE CREATE COMMAN BOX..
• . IN THIS FORM WE ARE USE VARIOUS COMMAND BOX THOSE ARE


• PREVIOUS,FIRST,NEXT, ADD,NEW,UPDATE, DELETE, SAVE

• . IN THIS FORM WE ADD NEW FLIGHT RECORD AND UPDATE IT THEN THE

• VALU IS GO TO THE DATABASE.

• .WHEN WE CLICK NEXT , LAST , PREVIOUS, FIRST COMMAND BUTTON

• THEN IT SHOW VARIOUS THING SERIALLY.


• THEN HE GIVES HIS FULL DETAILS

• IN CUSTOMER FORM THOSE DETAILS WERE WRITTEN.

• THEN COMPUTER CHEQUE THE DATE WHAT DATE THE PERSON RESER VED

• DATE WISE IT CHEQUE THE FLIGHTS

• IF THE FLIGHT IS FLING THAT DAY

• THEN SYSTEM JUSTIFY THE SPECIFIC FLIGHT ID

• IT CHEQUE ITS SEAT CLASS.