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
