Reporting flight status. On demand, line-of-business executives also report the seat availability in the business and executive classes to passengers.

Confirmation of reservation. Line-of-business executives can confirm the ticket of a passenger 72 to 24 hours before the departure of the flight. The confirmation can be carried out over telephone as well as across the reservation counters at regional offices.

Having examined the role of business executives in SkyShark Airlines, you can understand the requirements of the airline portal easily. These requirements are explained in the next section.

Project Requirements

The airline portal required by the airline should be an integrated solution that allows all business executives and customers to access data that is pertinent to their roles. Notice the inclusion of customers that I made in the preceding sentence. By enabling customers to manage their information, such as their ticket status and the confirmation status of their reservation, the airline wants to reduce the workload of its line-of-business executives and enhance customer experience.

Based on the roles of executives discussed in the previous section, you can infer that the responsibilities of the airline executives are well defined. The airline portal uses the role of these executives as a framework for imparting its functionality. Thus, the portal enables different sets of tasks for business managers, network administrators, and line-of-business executives. In this section, I list all tasks that need to be accomplished in the airline portal and also examine how these tasks will be accomplished.

Creation and Deletion of User Accounts

The procedure of creating a new user account is given in the following list:

1.A business manager decides when a new user account needs to be created and uses the online portal to send an e-mail message to the network administrator. The username and the role of the user are specified in the e-mail message.

406 Project 4 CREATING AN AIRLINE RESERVATION PORTAL

on the scheduled date are offered to the passengers in the waiting list. To confirm their ticket, passengers can use the options given in the following list:

Use the ticket number to confirm the ticket with the line-of-business executive, either by telephone or in person.

Use the ticket number and e-mail ID to confirm the reservation on the online portal.

Creation of Reports

Business managers can generate reports to view the performance of flights. The types of reports supported by the airline portal are specified in the following list:

Monthly flight revenue. The monthly flight revenue report retrieves the total revenue generated from all the flights in a given month. The business manager needs to select the month and year to run the report.

Flight revenue report. The flight revenue report reports the total revenue generated from a flight. To run this report, the business manager needs to specify the flight number.

Customer affinity report. The customer affinity report retrieves the customers who have flown the flight maximum number of times or who have paid the maximum fare. To run this report, the business manager needs to specify how many customer records the application should retrieve. This report is used to launch the frequent fliers program.

Total revenue report. The total revenue report is used to retrieve the total revenue that has been generated by the airline since a given month and year.

Launch of Frequent Flier Programs

Business managers are responsible for launching frequent flier programs that are used for giving discounts to customers who frequently fly with the airline. Customers are given discounts if they specify either of the parameters specified in the following list:

Frequency of flight. Customers who frequently fly the airline are given a discount of a certain percent on their ticket fare. The business managers determine the frequency of flight and the discount percentage.