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 |