## RoomType

ID | TypeName
--- | ---
1 | Deluxe Suite
2 | Executive Suite
3 | Standard Double
4 | Premium Twin
5 | Luxury Triple

## Booking

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

## PricePerNight

ID | RoomTypeID | Price
--- | --- | ---
| (→ RoomType.ID) |
1 | 1 | 150
2 | 2 | 200
3 | 3 | 150
4 | 4 | 200
5 | 5 | 150

## FamilySuites

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

## SingleRooms

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

## Customers

ID | Name | ContactInfo
--- | --- | ---
1 | John Doe | +1234567890
2 | Jane Smith | +9876543210
3 | Michael Johnson | +0987654321
4 | Emily Davis | +1357924680
5 | David Wilson | +2468013579