AAE

Location

-location name PK-location map #$%-standard undiscounted slot fee-distance between locations

Expedition Sale

-expedition ticket # PK-count of slots on this ticket-guest name-discounted slot charge-total $ amount of supply items

Employee

-employee # PK

Booking Agent

-employee # PK-agent commission rate

Aircraft

-aircraft engine # PK-aircraft name CK-seating capacity-fuel capacity-date manufactured

Expedition Type

-expedition type name PK-expedition type capacity-expedition expected time length

Supply Item Type

-supply item type # PK-SI price QOH

Pilot

-employee # PK-date of initial pilot license

Cash Account

-cash account # PK-cash account balance

Expedition Schedule

-expedition # PK-expedition timestamp CK-actual duration-scheduled expedition date-slots filled for scheduled expedition

Client Segment

-Client segment PK-Advertising service voucher

Advertising cost

-Ad. service voucher PK-amount

Count

count of employee type

Advertising type

-ad. type name PKamount available

Credit card

-credit card # PK-card Type-expiration date

Advertising Service Voucher

Advertising Service Voucher ?

Guide

-employee # PK--date qualified as a guide

Employee Type

-employee type name PK-starting wage for employee type

item on ticket

-quantity of item on this ticket

Aircraft Type

-aircraft type name PK

Client

Client # PKClient NameClient address

Pilot fly track

-hours flown in aircraft by pilot

sequence of locations

Revenue Receipt

-remittance timestamp PK-$ amount