| 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 |
| 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 |
| 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 |
| 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. |