Hong Kong Airlines Management System
Added on - 22 Sep 2019
INTRODUCTIONHong Kong Airlines management system is designed for busy city of Hong kong as there is enormousamount of travellers in and out of the city. It manages the passenger capacity of more than 70million and the runway capacity of the airport is 400 thousand. This system is setup in order to helpmanage this enormous amount of data that flows in and out everyday. It enables and helps inefficient storage and management of flight details, passenger details, schedule details, bookingdetails of flights, routes of flights, airport details, pilot details, etc. It helps in booking airline ticketsonline with bill payment. Customers may use the system to check schedule of flights and booktickets. The customer may also get his or her booking details.The management system also helps staff members of airlines by easing their job. The airline staffmembers can view and update flight schedules when required. The staff members can also get andupdate route details for flights. Staff members can also view airport details but cannot updateairport details. Flight schedules can also be updated by staff members. Staff member can also accesspassenger details from the system. The passenger details can also be updated by staff members ifrequired. The airline staff members may assign different pilots to each flight. The staff members mayalso view pilot details.The software manages the data by assigning each passenger and flights a unique ids with help ofwhich the bookings made in the system are tracked. The system also keeps tracks of each pilotassigned to flights. All the routes details for every flight is managed efficiently.The system is powerful, easy to use and flexible which is specifically designed to deliver realconceivable benefits to Hong kong airlines management system.BUSINESS RULESBusiness rules are certain aspects of a business that defines the functioning of business. These rulesspecify how the business works and the structure of the various aspects of business is. All theconstraints, definitions and operations that are applied to the business are included in the businessrules. These resolve to either true or false.The business rules for Hong kong airlines database management system are stated as follows –Rule 1 : A passenger can book flight. A passenger may have one or more flight bookings.Rule 2 : A flight will have many seats and a flight can have one or more than one bookings.Rule 3 : A pilot may be assigned to more than one flights.Rule 4 : A flight may have one or more than one pilots.Rule 5 : A route will be assigned to single flight.Rule 6 : A route will have two airports assigned to it, one departure airport and one arrival airport.
Rule 7 : An airport may be arrival airport or departure airport.The above business rules defines the functioning of the airlines system. The flight, booking, airport,pilot, passenger and routes data is managed with help of these rules. The system will be used by thestaff members of airlines to manage the fight details and by passengers to book flights tickets.CONCEPTUAL MODELThe entire system manages the airlines database by dividing the system into seven records. Theserecords are solely responsible for the management of flights, airports, and passenger data. Theconcept behind the development of this model is on the cardinality between records. As we know,there an be multiple airports in the hong kong city. The airport can have multiple flights. This is oneto many relationship.A single city can have many airport. So one to many relation. In similar manner, a single airport canhave many flights, so here alos the same relation that is one to many.Flights and Passenger have a many to may relation, as there can be many passenger on same flight,and one passenger can go on multiple filghts.The overall E-R diagram which is concluded over the conceptual thinking is shown below-Figure-1 :E-R ModelThe above shown diagram shows the relation between the seven tables. These tables follow thenormalizations rules, and are deployed in Microsoft access. These tables are implemented in the
software to check the queries and see the implementation. Also the user interface is made for allthe tables in the Microsoft access, which will be shown in the implementation part.LOGICAL DESIGNConceptual design for this system gave use the entity relation diagram, of how are tables going tobe. But to execute anything, or to know how our system is going to work, we must fix the use case.In this section use case is developed to make sure the logical use of the database, and how queriesare going to work.On observing the use of functionalities required by the airline system, the following use casediagram is obtained.Figure-2 : Use Case ModelThis use case diagram shows how data can be retrieved and who can retrieve. Admin can finddifferent types of data from this view. We will see three queries, one from admin, one frompassenger, and one from staff member.
Admin – Admin wants to get the idea of flights whose in total passengers are more than 10. Adminwants to find out the flight ids,Query 1-select flightID, count(ticketID) as PassengerCount from booking group by flightID havingPassengerCount>=10;The above query when run produces the following outputFigure-3 :Query-1 ResultThese are the flights numbers required by the admin.Passenger – A passenger simply want to know about the flights on a particular route (say 49017).Query 2–SELECT flightID,arrivalTime, arrivalDate, departureTime, departureDateFROM Flight where routeID = 49017The above query when executes gives the flight id with their arrival and departure information forthe route 49017.Figure-4 : Query-2 Result