The Atrs Airlines Company

Published Date: 02 Nov 2017

The proposed system allows customer can more close to the company with the promotion and event of the company, it also can help the company improve their services and minimize the percentage of complaint.

With the new system, the staff will feel that the company are take care and responsible to their employee because with this system the employee no need to working more than normal working hour and have a lot of time to accompany family members. At the same time, the company also can invest more in the employee policies like giving a free holiday package to them or invest more insurance them then the employee will feeling like the working in a home and continue working in this company in future.

The system will help company saving the operation cost because the existing system is manually record then need the more people to handled and record the daily operation. During the holiday time, the company needs more people to handle the business process then the company will recruit more people and provide the training to them. After the system is developing, the company no need recruit more people and provide the training to the staff.

The customer will receive the e-mail when the airlines company facing are having any promotion. For example, when the flight schedule need to delay because of the bad weather instead of the customer already in the counter then just inform the customer the flight schedule have to delay because of the bad weather.

From the existing manual system, the staffs need to updates package promotion immediately but the staff will manually type in Microsoft Excel made the data inconsistency. Sometimes, the data that needed are no clear and maybe the data are losing or no record during the peak time like school holiday and Chinese New Year. With the new system, the staff no need manually update the package promotion information with a lot of data and to provide accurate data. In addition, the report can make the management faster making decision.

ATRS Airlines company is a new start-up company since 2011that provides a service to customer for make reservation for local flight ticket. The company using paper-based system which means that all the information is record in the record book. The sales of the company are decrease because some of the record of customer are lost until make the customer feel unsatisfactory and go to the other airlines company to buy airline ticket or online buying airline ticket.

The main aim of the company is to provide good services to the customer and provide a good working environment to employee. Besides that, the information of the customer is well protected and not selling to the company partner because more of the customer will feel that the company is not well protected the customer privacy.

Airline e-Ticketing System is use to gain competitor advantage from the competitor from other airline company like Air Asia, Malaysia Airline (MAS) and Fire Fly.

More of the airline have own selling airline ticketing system to increase more customer and company sales. ATRS Airlines company propose to have their own Airline e-Ticketing System to increase sales of the company.

The company approximately around 100 more people includes manager and staff. The amount of transaction will be increase for business process. Therefore, ATRS Airlines company will propose the system to decreased the complaint from customer.

In this module, customer allows register as a member to get the latest news of the company and making reservation for airline ticket. At the same time, it allows customer to send their feedback to help the company improve their services.

The customer can register as a member to get the latest news of the company. Customer required to provide a details information because use to prepared for emergency purpose. At the same time, staff or administrator can help the customer register as a member.

If the customer are moving to the other place like Penang to Kuala Lumpur. The customer allows updating details like home address and phone number. In addition, customer also can change their password for the security purpose. Staff and administrator allows to help customer updates their information by searching the customer ID or last name.

Customer is allows to send their feedback to help the company improve their services.

Customer can using ATRS Airlines company website through using Internet to making a reservation for airlines ticketing which include the number of seat.

If the customer wanted to cancel the reservation, ATRS Airline will not return the deposit to the customer when cancel their reservation. Customer is allowed to search their flight ticket ID while staff and administrator also allow help customer cancel their flight ticket.

If the company has received any feedback from customer then the company will try as soon as possible to reply to customer. It also can function as promote the package to customer.

The management can view the report then after to decide need to print the report for the backup purpose.

The management can request for print out the report for using as a meeting material.

The report is about the list of the customer’s information to easier contact during emergency time.

The package report is use as a show the new package to customer when update the package.

This module is about the company management can give any promotion like discount to customer to attract more customer during the normal day.

The management can adding the promotion package when the sales of the company are decrease or near the special days like Christmas giving discount.

The management can add the promotion like the holidays package to some place and adding more details about the promotion package. Staff or administrator can search the package by package ID.

After the certain duration of promotion or the holidays and specials days are over, the management can delete the package and return to the normal price of the airline ticket. Staff or administrator can search the package by package ID.

Customer will receive the package promotion through e-mail.

his module allows staff or administrator to update the price or adding the cabin type.

The management can update the cabin price when the holiday coming. Staff or administrator is allowed to update the cabin price or type by searching by cabin ID.

The staff can add more the cabin type like normal cabin, economy, and business to the flight.

The staff or administrator is allows to delete the cabin type by searching the cabin ID.

Microsoft Visual Studio 2010 Ultimate is the latest product of the Microsoft. Developer using management tools to ensure this tool provide a quality results from design to deployment. It also allows developer using the C# language work together to simplify with the Microsoft Office APIs. At the same times, the management tools also support Visual Basic Language that shorten syntax and enable developer to write code faster.

Windows 7 takes up less memory and run background services only when the developer needs to use it. It’s designed to run the programs faster and to sleep, and resume.

Microsoft Project helps the developer to manage their task and make sure their task finish on time because when the increases of the delivery the system will also affect the cost of the development. Besides that, it enables the developer easily experiment with the project plan and perform what-if analysis.

Microsoft SQL Server support high-performance transformations out-of-the-box. It obtains a scalable transformation engine that works with 32-bit and 64-bit architectures. Besides, developer can help the developer saving a lot of time because it can manage conditional operation for partitioning and filtering and the data can be sorting, aggregation, and merges.

Microsoft Office Visio is used for drawing a architecture floor plan. The software also provides the template for drawing the architecture floor plan. Besides, by using a visual format, barriers to communication are reduced and minimized the misunderstanding between the developer and user.

Microsoft Office Word are the most recently use by every people. It allows creating the documentation of the system because in the future, the other developer easily making any update of the system.

Windows 7 provides a quickly and more securely to both wired and wireless domain networks by connect with a server. It also helps the company make the everyday task are streamlined and simplified and intuitive enhancements to the Windows Aero desktop help the user to navigate, arrange, and work with multiple open windows on the desktop.

Internet Explorer 7(IE 7) is a latest product of Microsoft for Windows 7. IE 7 provides a new streamlined interface and a greater improvement in performance (including hardware acceleration).

Figure 1.6.3 shows that the system architecture of Airline e-ticketing system. The main server will use as to stored the all the data or record for daily process. At the same time, the backup server is use as to storing the data for backup purpose to prevent the data losing when the power failure. In addition, the room temperature for the server must maintain between -40℃ ~ 70℃. In this system architecture the most important is a firewall because it used to prevent any malicious entries to the server and also prevent any unauthorized user get the data from the server and sell it to the competitor. In this illustration, client can use the mobile computer or mobile to make the reservation airline ticket through the ATRS Airlines Company. The staff and manager can use printer to print the report or any company document.

The project aims and an objective, company background has been introduced to let readers familiarize with the existing situation. Also, the functionality of module of ATRS Airline e-Ticketing System had been discussed. Overview and summary diagram are shown to let reader to have better understand on the proposed system; yet project schedule in Gantt chart, project team and module allocation had been show to let readers to understand the allocation of time and work load among a group of members.

Next chapter would be Requirement Analysis of ATRS Airline e-Ticketing System.

This chapter will discuss about the requirement analysis which included Fact-Finding, development environment, operational environment, software and hardware requirement, functional requirements. It will list out the minimum requirements required for the project to have and to ensure that meet the user requirement within over budget. In addition, the Unified Modelling Language (UML) diagrams are used to show the actor should carry out the task an briefly describe how the actor and the system interact.

To study the system the analyst needs to do collect fact.

The methods used in this project are the observation and background reading. This is to find out what are the requirements can be improved from the current system, in order to improve the effectiveness and efficiency of the system.

Observation is used to identify problems that currently faced by the company. Purpose of this method is to fully understand problem that currently faced by staff and customers.

Besides that, it will help us more easily to get familiar to the business flow of the system and solve all the limitations in the new system.

Research is another fact-finding method that author used to understand more about the new system needed to develop. In addition, author researched on the popular local airline such as Malaysia Airline System (MAS) and Air Asia to get more information about how airline website works. This is to make sure the requirements and quality of the system is met.

User login security is mandatory module that must include into a business operational system. It is to secure that no anonymous or unauthorized people can access to the system.

In this system, the user are categorize into two groups which are customer and administrator. Customer must register as a member then just can access to the system according their role. Otherwise, administrator can help the customer register and help the customer to booking a flight ticket.

Customer would not feel safety if their information are leaks or using by other people.

Every data in the system are important to the company and required to store in server. In ATRS Airline e-Ticketing System also required to store the data in server.

While more data are need to store in the server. The database will need to be maintained and to able to expand whenever is necessary. Thus, database maintainability is required to the system.

ATRS Airline e-Ticketing System is a system that provides users good analysis. In other words, report is important in the system which able to produce useful reports that help company gains the competitive advantage.

The system will help to reduce the error which created by human errors, it should be able to prompt a message to notify the users. In addition, the error message should clear and easy to understand.

The system must easy to let customer understand the function of each button. At the same time the user interface of system must not messy.

All customer’s data are protected and not to give the data to the company partner. The system also not easily gets hacked by unauthorized user.

The system process cannot load more than 3 seconds to avoid the wasting a lot of time.

For example, customer will not surf the company again if the process is too slow than other airline company website.

The company system must be operating in 24 hours per 7 days to support every transaction, therefore the system must provide the accurate result. For example, the system will provide the accurate and actual monthly sales report.

After 3 month, the system must function properly in ATRS Airline Company. In the future, the system must update without close down the system for maintenance purpose.

During the development time, the system must be developed in C# and VB.Net programming language because the tools for development easy to find out and the programming language are easy to learn.

The diagram above is the use case diagram for the Customer Maintenance Module. This module allows the customer to register as a member and update their information. At the same time, staff and manager also can search member details, view member details and help customer to update their details.

The diagram above is the use case diagram for the Ticket Reservation Module. These modules allow the customer to booking air flight ticket and view their reservation details. However, this module also allows the customer cancel their reservation. In addition, staff also can view ticket reservation, search ticket reservation and help customer to make ticket reservation. At the same time, customer will receive the message when the flight schedule delay.

The diagram above is the use case diagram for the Package Maintenance Module. These modules allow manager and staff to add the package details, search the package, update the package details and delete the package details when the special day is over. In addition, staff allows sending the package promotion through e-mail.

The diagram above is the use case diagram for the Report Module. These modules allow manager and staff to select the type of report. However, print report is not requiring when the management not requested for report.

The diagram above is the use case diagram for the Cabin Maintenance Module. These modules allow manager and staff to add the cabin type, update the cabin type details and delete the cabin type details when the special day is over.

This chapter has listed out the minimum requirement need to build this project. This is to avoid any unnecessary compatibility issues. Functional requirements are listed out the functions that is provided in this project and who are the person going to carry out the function. Unified Modelling Language (UML) diagrams are used to show the interaction between the actor and the functions to enable easier way to design the system.

Next chapter would be the System Design of ATRS Airline e-Ticketing System.

In this chapter, the system design of ATRS Airline e-Ticketing System will be discussed using use case diagrams, sequence diagrams, and activity diagrams. The database design will be shown in ERD diagram, and explain together with data dictionary and normalization. Besides, some print screen of the proposed system will be included in this chapter to let reader to familiar with ATRS Airline e-Tick

The ATRS Airline e-Ticketing System contain front end and back end system. The front end system mainly consists of the information of the company while the back end system is functional of the system.

Customer can access to the system when register as a member in the front end page. It is design for the customer who wants to reserve the flight ticket and receive the e-mail of promotion. At the same time, customer also can give the feedback to help the company improve their services.

The manager or administrator can add the package to attract more customers to reserve the flight ticket. At the same time, manager or administrator also can update or delete the package. In addition, the manager or administrator also can send the package promotion to customer through e-mail.

The manager or administrator can insert, update and delete the cabin type. In addition, the manager or administrator can update the price of the cabin.

Figure 3.6.1.5 and Figure 3.6.1.6 allows the customer to reserve their flight ticket. At the same time customer also allow to choose their seat places and cancel their flight ticket. In addition, customer also allows uploading the medical document in pdf, txt, and docx format.

Package Updated Report is design to let the staff and the customer know the package promotion during the holiday when the customer walk in to the company to reserve the flight ticket. In addition, the report can save in excel, word and pdf format.

Customer Report is designed to give the information of the customer who is birthday of the month and the company will give the voucher to the customer to increase the loyalty of customer.

This chapter has listed out the design for user interface and the database design. While creating the class diagram, sequence diagram and activity diagram, Microsoft Office Visio 2007 is used to design the diagram. For each table, attributes need to consider and make sure that each table has the relevant and proper attribute needed without missing out any necessary attributes.

Another part of the challenging tasks in this chapter is that produce a Web-based system that is standardize among members yet user-friendly to the users had spent most of the author’s time in doing researches and studies. Fortunately, author managed to solve the problem by study the other airline privacy policy and using the CSS StyleSheet and ASP.NET AJAX Toolkit. These toolkit and methods are helped developer to create the standardized interface yet reusing some part of the codes. By using CSS StyleSheet had been reused in every web form designed and every form looks alike.

In this chapter, the Object-oriented Analysis Design (OOAD) approach used to produce ATRS Airline e-Ticketing System will be recalled from chapter 1. In addition, the other approach used in ATRS Airline e-Ticketing System, verification and validation are included in the chapter.

To produce ATRS Airline e-Ticketing System, we using programming language C# to develop system because.In addition, Windows 7 Ultimate as a platform to produce ATRS Airline e-Ticketing System.

Microsoft Visual Studio 2010 Ultimate is the latest product of the Microsoft. Developer using management tools to ensure this tool provide a quality results from design to deployment. It also allows developer using the C# language work together to simplify with the Microsoft Office APIs. At the same times, the management tools also support Visual Basic Language that shorten syntax and enable developer to write code faster

The major problem for the author and his team member is lack of time to develop the system when the new semester starts and many assignments is coming. At the same time, the author also starting to look a job for the industrial training.

Since the final semester is important to author, the author just try to start the system development before the semester start and try to design the system with the master page. With the little knowledge about design a good master page also is difficult to for the author because author major focus on programming and not in designing but author try their best try to design and learns it by himself from the online tutorial. Finally, author did it with the stratified design but still need to have some improvement.

During the development time, author also met many problems in creating reports using Report Viewer because the reporting tool is totally new for the author and needs time to learn to use it. Besides that, author also need to think that which data must be in the report and useful for the company.

In addition, during the combination the project is also another issue because the database are using is the same to ensure all parts of the project can works well between each other is not easy with the totally difference version development software.

At last, the development team has completed the front-end system and back-end system successfully.

The reason choosing the two-tier programming is simplicity because it reduced the development time. In addition, the more of the development tools provide the tools are commonly use because the available tools are robust and lend themselves to fast prototyping to insure user needs a met accurately and completely. The benefit of using two-tier programming is it conducive to environments with homogeneous clients, homogeneous applications, and static business rules.

In this topic, only the special codes will be discussed to show author’s efforts on producing quality system and the knowledge gained the knowledge and programming skills through the produce the ATRS Airline e-Ticketing System.

This send email function becomes popular in the web application because it can reply the feedback to the customer. Author implements this features Customer Maintenance Module.

Below is the source code is used to sending the e-mail with attachment to the customer by using Simple Mail Transfer Protocol (SMTP) when the company having any promotion like Christmas Day and Public Holiday.

Some of the user like pregnant or some medical problem need a special take care when reserve the flight ticket, author had put an upload document function in Ticket Reservation module. It just allows customer upload the medical document in .txt, .pdf and .docx format only.

Validation and the verification are important in ATRS Airline e-Ticketing System to reduce some human error. Please note that some of the validation that repeated in other forms.

In this chapter, the programming tools and programming technique used to produce ATRS Airline e-Ticketing System had been revise and the special features in the project. In addition, this chapter also describe the problem faced by author and team member and overcome the solutions.

In addition, in this chapter the validation and verification had been introduced.

Next, will be the software testing in next chapter.

For example, the software bugs cause the China Airline Airbus A300 crashing due to software bug in April 26, 1994 killing 264 innocent lives.

In this project, we use verification and validation strategies to testing the system.

The verification strategies include the testing and the deliverable of that phase testing which include:

The Validation Strategies involved in the testing and the deliverable of the phase of testing is described in below:

Unit testing of software application

ATRS Airline e-Ticketing system is using Top-down approach and Bottom-up approach as a testing process to testing the system.

The top-down approach remains extremely popular in project management. The "top-down" means that all the directions come from the top. the sub module but when adding any module which can satisfies the Golden Rule of top-down software testing which are in order to test a unit, the tester must have tested at least one module which calls it.

The advantages of this approach are the top-down down testing process provides an early working model of the program. This model can be presented to the user for an early test of the system. Design flaws can thus be detected early and corrected. When testing, it also to make sure that stubs have to be written while automated tools do exist which ease the writing of both stubs and drivers, stub tools are harder to find. As well, stubs are difficult to write since they must simulate the setting of output parameters in a way meaningful enough to avoid introducing new errors yet simple enough to be a stub and not the real thing.

Bottom up integration also uses test drivers to drive and pass appropriate data to the lower level modules. As and when for other module get ready, these drivers are replaced with the actual module. In this approach, lower level modules are tested extensively thus make sure that highest used module is tested properly.

The advantages of using this approach are behaviour of the interaction points are crystal clear, as components are added in the controlled manner and tested repetitively. In addition, these approach suitable for applications where bottom up design methodology is used.

- This function is to test the capability of the system successfully navigate one page to another page.

- All the navigation actions are successfully navigated from one page to another page.

- This function is to test the capability to upload the file such as medical document.

-Result: All the upload file function is successfully uploaded.

- This function is to test the capability of the system whether successfully sending to the customer.

- The e-mail will successfully send to the customer with attachment.

This chapter discussed the all the testing plan that use to test each modules with the task name, test objective, expected result, actual result, and remarks.

Next, will be conclusion in next chapter.

This chapter will discuss about how to apply author seminar title into the project. Besides that this chapter also evaluates the project objective such as strengths and weaknesses. In addition, this chapter also discusses the future improvement on the system and personal reflection on this project.

There have a lot of the database in to the ATRS System that important for the company. As we know, no matter the information is important or not, it still can steal by other people. So in author’s seminar, author does a research in cyber security for the e-commerce website.

Cyber security is important for the project. For the ATRS Airline e-Ticketing System will categorize the user into two groups which are staff or administrator and the customer or member. These two groups of user have the different roles and authentication. For the normal user it the can view the information of the flight schedule and the information of the company. If the normal user tries to access to enter the username and password which does not exist in the database, the system will prompt out the error message to the normal user. The normal user just can access to the system when register as the member. After the normal user register as a member, user just can update their profile, book the flight ticket and cancel their flight ticket. For the staff and administrator can access to the system which can help the customer booking flight ticket and cancel the flight ticket. At the same time, staff and admin can update the cabin, package, customer details and view the report. The report will print out when the top management requested. In addition, the username for the member and staff or administrator are totally difference. For the member it just uses their own name as the username and for the staff using their staff’s ID as a username.

When the member and staff or administrator forgot their password and wanted to access to the system, the user just need to enter their e-mail address when register as a member. If the user try to e-mail the e-mail address which is does not exist in the database, the user also can’t get the information and password through the e-mail.

In the process of producing ATRS Airline e-Ticketing System, Object-Oriented Analysis and Design (OOAD) was chosen for the methodology and Two Tier Programming (Two Tier Application) are more like to describe the programming paradigm.

Object-oriented analysis and design (OOAD) approach is a software engineering approach that models a system as a group interacting object represents some entity or attribute in this system and its object defined by its class, its state, and its behaviour. In other definition, we can say that OOAD is a methodology which helps (Rebecca Macken, 2012)

model has a user-friendly interface. In Two-Tier model, it has two separate layers namely Client and Server. This application date to be shared within homogeneous environment.

The objectives are important for the developer because it can determine the system whether meet the user basic requirement which mentioned in the beginning of the project. The following fulfilling objective that mentioned in the beginning of the project:

The ATRS Airline e-Ticketing System helps the company to provide the new working environment to the employee with the new system. The system will help the user store the all information into the database to prevent lose the data again as compare to the existing manual system.

ATRS Airline e-Ticketing System provides the useful report to the management. The management can easily making decision to give the latest promotion to the customer.

ATRS Airline e-Ticketing System also helps the company to save the manpower because the man power is expensive. For example, if the company hired more people to working in the company then the company must paid more of the salary to employee and government tax.

ATRS Airline e-Ticketing System can help the company maintain the customer loyalty because the management can view the customer’s feedback and improve their services and increase the effectiveness of the staff.

With the ATRS e-Ticketing System, the customer is able to get the latest promotion’s information of the company and the latest the flight schedule information instead in the airport just knowing the delay of the flight schedule due to weather problem.

ATRS Airline e-Ticketing System cannot considered as a successful system because the user interface of the system is look like stand the point of the programmer and storage capacity is not enough for the system. But, the system can successfully deliver on time and meet the objective. Below are the evaluation of the strengths and the weaknesses of the ATRS Airline e-Ticketing System:

The system will have all the accurate information from the database. So it will easily to let the customer to making the decision to booking the flight ticket.

The customer can booking the flight ticket through online via online and updates their information instead physical drive to the company to booking the flight ticket and wasting a lot of time in the road and queue.

The customer can get the latest promotion through the e-mail which registers as a member. Besides that, the system also available in anytime (24 hours per 7 days) with any internet connection.

The user interface of the system is only with the little colour and can’t attract the customer after the customer access to the system. In the future, will be improve more in design to attract more customers.

The security of the system is not so advance because the system currently just categorizes the user in two main groups which are member and the employee which can access to the system. In the future, the system will be implementing the security code to the user before access to the system.

The system are able run in the website or the internet browser but can’t gain any competitive advantage in business because more of the airline try to implement the system in to the mobile application because more of the user is like to using mobile to surf the internet.

ATRS Airline e-Ticketing System release by this stage is a system that serves only basic but core functionalities to the users. It needs further enhancements on the system with the functionalities of the system to improve the services.

Below is the suggestion for future improvement:

It can be improved by adding some nice flash graphics to attract the user.

In the future, the system wills automatic send the Short Message Service (SMS) to the passenger if the flight schedule got any delay due to weather problem.

Currently, the system only supports one language. In the future, this system will be improved to support multi-language properties. The user can change the website language based on their preferences.

Starting from the planning stage until the testing stage, it takes author one year to prepare the project. During the semester holiday, it takes a lot of time to thinking and learn the new programming skills until the new semester start it become worst because need so many things to do like attend the interview, seminars, course work and exam make the author learned to manage time well.

During developing this project, author faced many problems such as the programming skills and worries the database in the SQL Server crash. Author had spent their time to find the solution and posting the problem to the forum. Finally, author solves the problem such as sending the e-mail with attachment and uploads the file in document.

With the help and the support from author’s friend, author solves the problem and completes the project in time. Author also would like to thanks his team member because always spent a lot of time to discuss with author. Author would like to express his sincere gratitude to his project supervisor, Ms Lee Seah Fang always to giving her opinion and feedback on author project and guided slowly to finish the project.

In this final chapter, the linking of seminar research with project had been discussed. Evaluation had been made against the project objective and on the project itself. A few improvements suggested enhancing the system and some good project management to make the project perfect.

As a conclusion to this project, author thinks that although it is tough for the students without the industrial experiences for the system, it is still worth to have this project in college because it can help student to gain more experience and try to using the toolkit that provided in internet in the future. In addition, the project also helps student to gain the knowledge in the business flow in certain industrial.