| id | typeName | capacity | pricePerNight |
|---|---|---|---|
| 1 | Standard | 3 | 100.99 |
| 2 | Deluxe | 4 | 150.99 |
| 3 | Suite | 6 | 200.99 |
| 4 | Family Suite | 7 | 250.99 |
| 5 | Executive Suite | 8 | 300.99 |
| id | customerId | roomTypeId | checkInDate | checkOutDate |
|---|---|---|---|---|
| (→ Customers.id) | (→ RoomTypes.id) | |||
| 1 | 1 | 1 | 2022-06-01 | 2022-06-05 |
| 2 | 2 | 2 | 2022-06-05 | 2022-06-10 |
| 3 | 3 | 3 | 2022-06-10 | 2022-06-14 |
| 4 | 4 | 4 | 2022-06-14 | 2022-06-18 |
| 5 | 5 | 5 | 2022-06-18 | 2022-06-22 |
| id | reservationId | amountPaid | paymentMethod | transactionTime |
|---|---|---|---|---|
| (→ Reservations.id) | ||||
| 1 | 1 | 300 | Credit Card | 2022-06-01 10:00:00 |
| 2 | 2 | 600 | Debit Card | 2022-06-05 14:00:00 |
| 3 | 3 | 900 | PayPal | 2022-06-10 08:00:00 |
| 4 | 4 | 1200 | Wire Transfer | 2022-06-14 12:00:00 |
| 5 | 5 | 1500 | Cash | 2022-06-18 16:00:00 |
| port | city | shipName | maxCapacity |
|---|---|---|---|
| (→ Ports.name) | (→ Cities.name) | ||
| PortMiami | Miami | Queen Mary II | 2620 |
| World Trade Center Barcelona | Barcelona | Allure of the Seas | 5400 |
| Terminal Passeggeri di Venezia | Venice | Seabourn Odyssey | 458 |
| Kowloon Dockyard | Hong Kong | Golden Era | 1400 |
| HarbourFront Centre | Singapore | Mariner of the Seas | 3804 |
| name | country |
|---|---|
| PortMiami | USA |
| World Trade Center Barcelona | Spain |
| Terminal Passeggeri di Venezia | Italy |
| Kowloon Dockyard | China |
| HarbourFront Centre | Singapore |
| name | country |
|---|---|
| Miami | USA |
| Barcelona | Spain |
| Venice | Italy |
| Hong Kong | China |
| Singapore | Singapore |