AIRLINE MANAGEMENT DATABASE CONCEPTUAL DESIGN Course: Database Systems Course ID: CSCI-760 Instructor: Dr Adly Elzoheary Student: Jagmit Singh School ID: 0653535 Table of contents: 1) Airline Industry at a Glance 2) Arms and Legs of an airline industry 3) Project requirements 4) Business Rules and Function Rules 5) UML diagram 6) Database dependency diagram (DDD) 7) Snapshots
Premium Airline Aircraft
Kelleher at Southwest Airlines “You shouldn’t get too heady about anything‚ because the greatest thing you do is not big in the universe. It’s not saying it doesn’t matter. It matters all the more. You’re fighting against nothingness. But you don’t give up. Therein lies the heroism.” -Kelleher (p.156) Although many have a great respect for Southwest Airlines and their disciplined business decisions. I have a greater respect for their “family like” environment and how they encourage their
Premium Southwest Airlines Airline
American Airlines. The reorganization took effect on Oct. 1‚ 1982. The formation of AMR had no effect on day-to-day operations of American‚ but it did – and still does – provide the company with access to sources of financing that otherwise might not be available. The holding company structure also allows the company to take advantage of appropriate new opportunities. The name “AMR” was taken from the airline’s three-letter New York Stock Exchange
Premium Corporation Airline American Airlines
about the values of their family. In Alice Walker’s “Everyday Use” and Amy Tan’s “A Pair of Tickets”‚ the author’s seem to explore a common theme of heritage. Alice Walker is exploring the concept of heritage as it applies to an African-American family. Amy Tan is displaying the theme of heritage as it relates to Chinese and a Chinese-American family. Dee‚ from Everyday Use‚ and Jing-Mei‚ from A Pair of Tickets‚ have different adaptations of their heritage‚ but ironically it takes a trip back home to
Free China Han Chinese Overseas Chinese
Strategy in the Market Place: Malaysia Airlines (MAS) has announced their new business plan for year 2012‚ aiming to restore their profitability on the premium sector‚ as to become the preferred premium carrier. (Business Plan‚ Our Way Forward‚ December 2011‚ page7) By achieving the vision as to become the preferred premium carrier‚ they will be launching a new regional premium airline. In the first half of 2012‚ they will launch new short-haul brand‚ flying an entirely new Boeing 737-800 fleet
Premium Airline Low-cost carrier Malaysia Airlines
Strategic Management “American Airlines ” Case Study Strategic Management Prepared By Fathi Salem Mohammed Abdulla 2009 37 Introduction American Airlines‚ Inc. (AA) is a major airline of the United States. It is the world ’s largest airline in passenger miles transported and passenger fleet size; second largest‚ behind FedEx Express‚ in aircraft operated; and second behind Air France-KLM in operating revenues. A subsidiary of the AMR Corporation‚ the airline is headquartered in Fort Worth
Premium Financial ratio American Airlines Financial ratios
“A Pair of Tickets” The short story “A pair of Tickets” by Amy Tan is really an interesting story to read. This short story is about June‚ a Chinese girl who travels to China with her father after the death of her mother. June was struggling with herself identity‚ but traveling to China and meting her twin sisters make her realize how much she was missing on her culture. I have experienced many things in life that are identical to this story. June was struggling with her identity because she looks
Premium United States Family Short story
AEA 11‚5 9‚4 8‚3 TK 26‚6 35‚3 29‚9 2009 AEA -5‚8 -4‚2 -4‚5 TK 15‚8 15‚2 19‚0 2010 PAX Middle East 2007 4‚1 4‚2 5‚1 15‚5 11‚6 13‚8 -1‚7 3‚0 1‚2 12‚3 19‚7 24‚3 AEA TK AEA TK 2008 2009 AEA TK 2010 PAX Source: AEA= Association of European Airlines (Scheduled Traffic) AEA 7‚6 12‚6 6‚1 14‚0 13‚6 15‚7 8‚2 0‚8 3‚8 TK ASK 2‚7 0‚0 2‚6 8‚9 1H’11 22‚0 17‚4 AEA RPK AEA TK AEA -10 20 9‚9 11‚8 9‚2 30 11‚7 17‚4 18‚0 50 ASK 1H’11 RPK 9‚0 10‚4 9‚1 10 20 30 -10 0
Premium Turkish Airlines Revenue Star Alliance
Singapore Airlines (SIA) began in 1947 as Malayan Airlines in a joint venture between the Malaysia and Singapore governments. However‚ due to political disagreements between Singapore and Malaysia in 1965‚ the two governments agreed to set up separated airlines‚ resulting in the formation of two bodies namely‚ Singapore Airlines and Malaysian Airlines System. Thus‚ Singapore Airlines was established in 1972 after the Republic of Singapore’s Independence from the Malaysia Federation. Singapore
Premium Singapore Airlines Singapore
The airline was formed by the Dubai Government under a management agreement with Pakistan International Airlines (PIA) Using a PIA leased 737 and A300. On 25th October 1985‚ Emirates flew its first routes out of Dubai. In 1987 flights were started to London‚ Frankfurt and Istanbul. In 1992 Emirates Airlines expanded its services to Djakarta‚ Paris‚ Rome and Zurich. With a fleet of 113 aircraft‚ Emirates currently fly to over 100 destinations in 62 countries around the world. Unlike many other
Premium Emirates Pakistan International Airlines United Arab Emirates