Purchase Solution

Blue Skies Airline, Drawing data flow diagrams from the given situation.

Not what you're looking for?

Ask Custom Question

Reservation System

Blue Skies Airline, a fairly new airline, offers services between any two of the following cities:
Denver, Washington D.C., Los Angeles, New York City, Atlanta, and Cleveland. When a customer calls Blue Skies to make a flight reservation, the reservation agent first asks them for:
1. the desired travel dates,
2. the departure and destination cities, and
3. the seat grade desired (first class, business class, or economy).

The reservation agent then informs the customer of all available flights that meet their criteria; for each flight, the flight number, departure date and time, arrival date and time, and roundtrip price are communicated to the customer. If the customer finds any of the available flights acceptable, they may either pay for the ticket via credit card, or may request that the seat be held for 24 hours.

A limited number of seats on each flight are earmarked as frequent flyer seats. A customer who is a frequent flyer member may reserve and 'pay for' one of these seats by giving the agent their frequent flyer membership number; the agent then verifies that the appropriate balance is available in their account before the seat can be confirmed, at which point those miles are deducted from the account. (Note: therefore, the seat availabilities for regular customers and frequent flyers are different.)

The customer has two ticketing options: they may request that a conventional `paper' ticket be issued and mailed to their home address, or an electronic ticket (E-ticket) may instead be assigned, in which case the customer is simply informed of the E-ticket serial number by telephone.

Other simplifying assumptions:
1. Assume that all flights are round-trip between two cities (no three-legged itineraries are permitted.)

2. Disregard the complication that airlines sometimes have to switch aircrafts at the last minute due to mechanical difficulties, thus disrupting the seating assignments.

To help you draw the diagrams, the entities and their attributes are:
CUSTOMER(customer#, first name, last name, address)

FREQUENT FLYER(customer#, ®#, mileage balance)

FLIGHT(flight#, departure date, departure time, arrival date, arrival time, mileage)

SEAT(flight#, departure date, row, seat#, class, grade, status1)

TICKET(serial#, °ight#, departure date, row, seat#, customer#, type)

These entities are for your reference only. Your external entities, data stores, or classes do not need to conform all of these entities so that you have enough flexibility to design your own system.

Your tasks:

Please draw the data flow diagram by hand and document all the components. (external entities, data stores, processes, and data flows) in the DFDs.

Purchase this Solution

Solution Summary

The solution presents a colorful graphic design for the DFD (data flow diagram) which tracks decision points for the reservations system for Blue Skies Airlines.

Purchase this Solution


Free BrainMass Quizzes
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.