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 |