| ID | TypeName |
|---|---|
| 1 | Deluxe Suite |
| 2 | Executive Suite |
| 3 | Standard Double |
| 4 | Premium Twin |
| 5 | Luxury Triple |
| ID | CustomerID | CheckInDate | CheckOutDate | TotalAmount |
|---|---|---|---|---|
| (→ Customer.ID) | ||||
| 1 | 1 | 2023-01-01 | 2023-01-07 | 1000 |
| 2 | 2 | 2023-01-15 | 2023-01-21 | 900 |
| 3 | 3 | 2023-02-01 | 2023-02-07 | 600 |
| 4 | 4 | 2023-02-15 | 2023-02-21 | 500 |
| 5 | 5 | 2023-03-01 | 2023-03-07 | 800 |
| ID | RoomTypeID | Price |
|---|---|---|
| (→ RoomType.ID) | ||
| 1 | 1 | 150 |
| 2 | 2 | 200 |
| 3 | 3 | 150 |
| 4 | 4 | 200 |
| 5 | 5 | 150 |
| ID | RoomNumber | Capacity | Amenities |
|---|---|---|---|
| (→ PricePerNight.ID) | |||
| 1 | 1 | 5 | WiFi, Mini Fridge, Balcony |
| 2 | 2 | 5 | No WiFi, No Mini Fridge, No Balcony |
| 3 | 3 | 5 | WiFi, Mini Fridge, Balcony |
| 4 | 4 | 5 | No WiFi, No Mini Fridge, No Balcony |
| 5 | 5 | 5 | WiFi, Mini Fridge, Balcony |
| ID | RoomNumber | Capacity | Amenities |
|---|---|---|---|
| (→ PricePerNight.ID) | |||
| 1 | 1 | 1 | WiFi, Mini Fridge, Balcony |
| 2 | 2 | 1 | No WiFi, No Mini Fridge, No Balcony |
| 3 | 3 | 1 | WiFi, Mini Fridge, Balcony |
| 4 | 4 | 1 | No WiFi, No Mini Fridge, No Balcony |
| 5 | 5 | 1 | WiFi, Mini Fridge, Balcony |
| ID | Name | ContactInfo |
|---|---|---|
| 1 | John Doe | +1234567890 |
| 2 | Jane Smith | +9876543210 |
| 3 | Michael Johnson | +0987654321 |
| 4 | Emily Davis | +1357924680 |
| 5 | David Wilson | +2468013579 |