## Guests

ID | FirstName | LastName | EmailAddress | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 123-456-7890
2 | Jane | Smith | jane.smith@example.com | 098-765-4321
3 | Alice | Brown | alice.brown@example.com | 555-123-4567
4 | Charlie | Green | charlie.green@example.com | 555-555-5555
5 | David | White | david.white@example.com | 555-555-5556

## Rooms

RoomID | TypeOfRoom | OvernightStay | ServiceID
--- | --- | --- | ---
|  |  | (→ Services.ServiceID)
1 | Guestroom | 2021-10-01 10:00:00 | 1
2 | Guestroom | 2021-10-02 10:00:00 | 2
3 | Suite | 2021-10-03 10:00:00 | 3
4 | Suite | 2021-10-04 10:00:00 | 4

## Bookings

BookingID | CheckInDate | CheckOutDate | NumberOfAdults | NumberOfChildren | GuestID | ROOMID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Guests.ID) | (→ Rooms.RoomID)
1 | 2021-10-01 14:00:00 | 2021-10-02 11:00:00 | 2 | 0 | 1 | 1
2 | 2021-10-02 14:00:00 | 2021-10-03 11:00:00 | 3 | 1 | 2 | 2
3 | 2021-10-03 14:00:00 | 2021-10-04 11:00:00 | 2 | 1 | 3 | 3
4 | 2021-10-04 14:00:00 | 2021-10-05 11:00:00 | 1 | 0 | 4 | 4
5 | 2021-10-01 14:00:00 | 2021-10-02 11:00:00 | 1 | 1 | 1 | 1

## Services

ServiceID | Amenity | Description
--- | --- | ---
1 | Air Conditioning | Central air conditioning system.
2 | No Air Conditioning | No air conditioning available.
3 | Air Conditioning | Central air conditioning system.
4 | No Air Conditioning | No air conditioning available.