## Accommodations

id | Name | Address | City | Country
--- | --- | --- | --- | ---
1 | Family Suite | 123 Main St | New York | USA
2 | Another Family Suite | 456 Second Ave | Los Angeles | USA
3 | Single Room | 789 Third St | Miami | USA
4 | Different Single Room | 777 Fourth St | Chicago | USA

## Rooms

id | AccommodationID | Type
--- | --- | ---
| (→ Accommodations.id) |
1 | 1 | Standard Double
2 | 2 | Luxury Twin
3 | 3 | Deluxe Triple
4 | 4 | Premium Quad
5 | 5 | Superior Double
6 | 6 | Executive Twin
7 | 7 | Ultra Deluxe Triple
8 | 8 | Presidential Quad

## Prices

id | RoomID | Price_Per_Night | AvailableFrom | AvailableTo
--- | --- | --- | --- | ---
| (→ Rooms.id) |  |  |
1 | 1 | 150 | 2023-01-01 | 2023-12-31
2 | 2 | 160 | 2023-01-01 | 2023-12-31
3 | 3 | 150 | 2023-01-01 | 2023-12-31
4 | 4 | 160 | 2023-01-01 | 2023-12-31

## Bookings

id | CustomerName | ArrivalDate | DepartureDate | RoomID | TotalCost
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Rooms.id) |
1 | John Doe | 2023-05-01 | 2023-05-05 | 1 | 650
2 | Jane Smith | 2023-05-01 | 2023-05-05 | 2 | 700
3 | Alice Johnson | 2023-05-01 | 2023-05-05 | 3 | 650
4 | Bob Brown | 2023-05-01 | 2023-05-05 | 4 | 700

## Customers

id | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | Jonathan | Smith | jsmith@email.com | 123-456-7890
2 | Emily | Johnson | ejohnson@email.com | 098-765-4321
3 | David | Williams | dwilliams@email.com | 555-555-5555
4 | Samantha | Martin | smartin@email.com | 555-555-5556