Databases Reference
In-Depth Information
SUPPLIER
SHIP
TOURED
PK
Supplier
Number
Supplier Name
Supplier
Address
Sales Rep
PK
Ship Number
Ship Name
Ship Builder
Launch Date
Gross Weight
PK
Passenger
Number
Cruise Number
Cabin Number
Fare
PK
Books
Booked by
Supplies
Used on
Uses
Includes
Included in
Supplied by
A
PROVISION
CRUISE
PASSENGER
B
PK
Supplier
Number
Product
Number
Cruise Number
Quantity
Date
Cost
PK
Cruise Number
Start Date
End Date
Cruise Director
PK
Passenger
Number
Passenger
Name
Home Address
Telephone
PK
PK
Visits
Visited by
Books
Booked by
Offers
Offered on
Uses
Used in
PRODUCT
VISIT
TOURED
PK
Product
Number
Product Number
Product
Category
Unit Price
PK
PK
PK
Cruise Number
Port Name
Country
Arrival Date
Departure Date
PK
PK
Passenger
Number
Cruise Number
Tour Number
Date
PK
Uses
Visits
Visited
Used in
Key to passenger unary
relationship
A: Head of family
B: In family
PORT
TOUR
PK
PK
Port Name
Country
Number of
Docks
Port Manager
PK
Tour Number
Tour Name
Duration
Price
Happy Cruise Lines entity-relationship diagram
Search WWH ::
Custom Search