1. Identify the entities and their relationships. Then create an ERD for the reservations system. 2. Create 3NF table designs for the system. 3. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys. 4. Use sample data to populate the fields for three records. Data items must include reservation number, Route Number, Date, Origin, Destinations, Departure Time, Arrival Time, Passenger
Words: 573 - Pages: 3
FACTORS AFFECTING BEHAVIORAL INTENTION TO PURCHASE LOW–COST AIRLINE E-TICKET IN YHAILAND by Piyanath Maneechot School of Business, University of the Thai Chamber of Commerce and Suthawan Chirapanda School of Business, University of the Thai Chamber of Commerce E-mail: suthawan_chi@utcc.ac.th 41 FACTORS AFFECTING BEHAVIORAL INTENTION TO PURCHASE LOW–COST AIRLINE E-TICKET IN YHAILAND by Piyanath Maneechot School of Business, University of the Thai Chamber of Commerce and Suthawan
Words: 5995 - Pages: 24
AirAsia was set up by Dato' Tony Fernandes in 2001. In December 2001, Fernandes and his partners set up Tune Air Sdn Bhd (Tune Air), an airline holding company then bought over AirAsia. Now, AirAsia has become one of the most successful airlines in the Southeast Asian region and the pioneer of low cost and no frills travel in Malaysia. The leading low fare airline in the Asia - AirAsia has been expanding rapidly since 2001, to become an award winning and the largest low cost carrier in Asia. With
Words: 3109 - Pages: 13
NORTH SOUTH UNIVERSITY Southwest airlines: staying ahead in the pricing game ASSINGMENT NO: 3 NAME: RIFFAT AL IMAM ID: 1030234530 COURSE: MKT 202 SECTION: 1 SUBMISSION DATE: 8-3-11 SUBMIT TO: M.A. SADAT SHIMUL ANS TO QUESTION NO 1 Southwest airline is one of America’s most successful air lines. It started its journey in 1970s.From the very beginning it has paid special attention to its pricing strategy. Southwest’s traditional pricing strategy has been low price strategy
Words: 737 - Pages: 3
Marketing and Reservation Report Evaluation of the main marketing tools available to tour operators The use of brochures and printed material is one of the most effective and widely used means of marketing tourism operations and establishments. A great deal of planning goes into brochures, and as a result, their credibility is often far higher than a value based statement on a website. In general, brochures are replaced and revised on an annual basis and attempt to provide as much information
Words: 1490 - Pages: 6
Air Asia – Strategic IT Initiative Submitted by: Charles Kho Sandy Hofman Aruan Christian Tjitrahardja Ramaratnam Narayanaswamy Faculty of Economics and Commerce University of Melbourne 2005 306-669 Strategic Enterprise Systems Group Project Executive Summary IT is one of the major enablers of AirAsia’s successful low cost business model. Based on the environmental scanning performed, the demand for Low Cost Carrier (LCC) is expected to expand rapidly attracting more players to
Words: 7166 - Pages: 29
ONLINE VEHICLE RESERVATION AND RENTAL SYSTEM CHAPTER 1 INTRODUCTION The advantage of having a car is that you can travel anywhere you want at any time without having to transfer from one vehicle to another. But it is not easy for an individual to have a car. Mainly because all cars are expensive and not affordable. That’s why some organizations offer a rent a vehicle service. Customers can call or walk-in in order to rent or reserve a vehicle. The current system is maybe error prone and customers
Words: 834 - Pages: 4
The Air Transportation System and several key subsystems including the Aircraft, Airline, and Air Traffic Management are modeled as interacting control loops. The impact of Information Technologies on each of these subsystems is evaluated through the performance of these control loops. Information technologies are seen to have a significant impact on the safety, efficiency, capability, capacity, environmental impact and financial performance of the Air Transportation System and its components.
Words: 6025 - Pages: 25
will be able to compete with other similar markets. Once the market is decided such as the airline industry, then the business has to decide how it will perform better than the competition and what item(s) it will bring to the market in order to be assorted from the competition. JetBlue Airways founding father, David Neeleman wanted to start an airline “that would combine the low fares of a discount airline carrier with the comforts of a small cozy den in people’s homes” (Rovenpor & Michel, 2009)
Words: 2984 - Pages: 12
Classic Airlines Marketing Solution Jeanine M. Taylor MKT 571 April 9, 2012 Michael Wilson, MBA Classic Airlines Marketing Solution Classic Airlines is the fifth largest airline in the world with a fleet of more than 375 jets that serve over 240 cities with over 2,300 daily flights. Since it was incepted 25 years ago, the airline has grown to 32,000 employees. Though currently profitable, Classic has not gone unscathed by the challenges faced by the airline industry. Financially, increased
Words: 4807 - Pages: 20
