Databases Reference
In-Depth Information
Figure 1-1
Customer
data
Ascertain customer's requirements
Find discounted plans
Flight
locations
Check routing/connecting flights
Discount
plans
Verify seat availability
CORE BUSINESS
Provide
air
transportation
Reserve seats on selected routes
Fare
schedule
Record preferences
Available
seats
Issue ticket
Collect airfare
Payment
options
Print itinerary
Required
information
PROCESS: ticketing and reservation
Information needed for ticketing and seat reservation.
Figure 1-2
Business
Process
Business
Process
CORE BUSINESS
Provide
air
transportation
Business
Process
Business
Process
DATABASE SYSTEM
airports
airplane
types
airfares
INFORMATION ABOUT
discount
plans
airplanes
flight
legs
flights
seats
customers
reservations
Database system needed to support airline
company core business activities.
