Hotels

HotelIDNameAddressCity
1Grand Plaza123 Main StNew York
2Luxury Suites456 BroadwayLos Angeles
3Cozy Inn789 Park AveChicago

Rooms

RoomIDHotelIDRoomTypeNumberOfSeats
(→ Hotels.HotelID)
11Deluxe Suite4
21Standard Room2
32Premium Suite5
42Economy Room2
53Family Suite6

Patios

PatioIDRoomIDAreaSize
(→ Rooms.RoomID)
11100 sqm
22200 sqm
33150 sqm

Verandas

VerandaIDRoomIDLengthWidth
(→ Rooms.RoomID)
1120 m10 m
2230 m10 m
3325 m10 m

Reservations

ReservationIDGuestIDCheckInDateCheckOutDateRoomID
(→ Guests.GuestID)(→ Rooms.RoomID)
112021-07-012021-07-051
222021-07-102021-07-142
332021-07-152021-07-193

Guests

GuestIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321
3AliceBrownalice.brown@example.com+1112223334
4MikeGreenmike.green@example.com+4445556667
5EmmaWhiteemma.white@example.com+7778889990