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