RoomTypes

idtypeNamecapacitypricePerNight
1Standard3100.99
2Deluxe4150.99
3Suite6200.99
4Family Suite7250.99
5Executive Suite8300.99

Reservations

idcustomerIdroomTypeIdcheckInDatecheckOutDate
(→ Customers.id)(→ RoomTypes.id)
1112022-06-012022-06-05
2222022-06-052022-06-10
3332022-06-102022-06-14
4442022-06-142022-06-18
5552022-06-182022-06-22

Payments

idreservationIdamountPaidpaymentMethodtransactionTime
(→ Reservations.id)
11300Credit Card2022-06-01 10:00:00
22600Debit Card2022-06-05 14:00:00
33900PayPal2022-06-10 08:00:00
441200Wire Transfer2022-06-14 12:00:00
551500Cash2022-06-18 16:00:00

CruiseShips

portcityshipNamemaxCapacity
(→ Ports.name)(→ Cities.name)
PortMiamiMiamiQueen Mary II2620
World Trade Center BarcelonaBarcelonaAllure of the Seas5400
Terminal Passeggeri di VeneziaVeniceSeabourn Odyssey458
Kowloon DockyardHong KongGolden Era1400
HarbourFront CentreSingaporeMariner of the Seas3804

Ports

namecountry
PortMiamiUSA
World Trade Center BarcelonaSpain
Terminal Passeggeri di VeneziaItaly
Kowloon DockyardChina
HarbourFront CentreSingapore

Cities

namecountry
MiamiUSA
BarcelonaSpain
VeniceItaly
Hong KongChina
SingaporeSingapore