Guests

IDFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohn.doe@example.com123-456-7890
2JaneSmithjane.smith@example.com098-765-4321
3AliceBrownalice.brown@example.com555-123-4567
4CharlieGreencharlie.green@example.com555-555-5555
5DavidWhitedavid.white@example.com555-555-5556

Rooms

RoomIDTypeOfRoomOvernightStayServiceID
(→ Services.ServiceID)
1Guestroom2021-10-01 10:00:001
2Guestroom2021-10-02 10:00:002
3Suite2021-10-03 10:00:003
4Suite2021-10-04 10:00:004

Bookings

BookingIDCheckInDateCheckOutDateNumberOfAdultsNumberOfChildrenGuestIDROOMID
(→ Guests.ID)(→ Rooms.RoomID)
12021-10-01 14:00:002021-10-02 11:00:002011
22021-10-02 14:00:002021-10-03 11:00:003122
32021-10-03 14:00:002021-10-04 11:00:002133
42021-10-04 14:00:002021-10-05 11:00:001044
52021-10-01 14:00:002021-10-02 11:00:001111

Services

ServiceIDAmenityDescription
1Air ConditioningCentral air conditioning system.
2No Air ConditioningNo air conditioning available.
3Air ConditioningCentral air conditioning system.
4No Air ConditioningNo air conditioning available.