A real-world database design and implementation project Part 1

Get Expert's Help on SIT103 Data and Information Management IT

About Singapore Airline

Singapore Airline started its company at 1972 and now it has come a long way becoming a respected international airline. Now the network of Singapore airline is stretched to 90 cities and 40 countries. According to Australian polls, Singapore Airlines is the best customer support provider in the world for the second year in a row. Singapore's flag carrier operates from eight Australian airports (Adelaide, Brisbane, Canberra, Cairns, Darwin, Melbourne, Perth and Sydney) and is especially known for its long-haul routes to the Americas, Europe and Asia.

Singapore Airlines is a multinational corporation devoted to offering the best quality air transport services and optimizing profits for the good of its shareholders and staff. Singapore Airlines Limited ('the Company') is a limited liability company incorporated under the domicile of the Republic of Singapore. The Company is a subsidiary company of Temasek Holdings (Private) Limited, registered in the Republic of Singapore, and is listed on the Singapore Exchange Securities Trading Limited ('SGX-ST'). The company's registered office is Airline Building, 25 Airline Lane, Singapore 819829.

The Group's core operations are passenger and freight air travel, technical services, pilot training, air charter and tour wholesale services and related operations. The company's primary operation consists of air travel for passengers. Singapore Airlines is a member of the International Air Transport Association and the Star Alliance.

Service and related user

The primary service which is the air travel for passengers as it’s one of the main services provided by this company. The related users of this service are for definite Passengers as they provide their data such as their name, to and from and passport details. The company’s service providers are its travel agents such as airlines have branches where a person can physically visit then book the ticket while the travel agent will be giving information such as any deals, or is the current flight that the passenger wants to travel in have required seats available.

Operational Description

The first step is to book a flight and it requires input of different type of information. Data and time of the travel is the first information require in order to see whether at particular date flights would be operational or not. Then comes the city to and from or even specific airports. Now the personal information is taken from the passenger such as name, date of birth (to make sure person is above 18 if alone), email address, contact, number of people traveling and government official ID number. Passport number is also required as well date of expiry and country where it was issued. Finally, after meeting all the criteria and providing all the details comes the payment information. This then confirms the booking of a flight and then the passenger receive ticket or boarding pass. Then this information is passed to departure control system prior to 24 hours before the flight to initialize the boarding procedure.

Complete Solution

Hire Expert Tutors

Get Professional Tutoring at Low Price in Australia


Tutoring Services


Orders Delivered


5 Star Rating


PhD Experts


Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support