Accommodations

idNameAddressCityCountry
1Family Suite123 Main StNew YorkUSA
2Another Family Suite456 Second AveLos AngelesUSA
3Single Room789 Third StMiamiUSA
4Different Single Room777 Fourth StChicagoUSA

Rooms

idAccommodationIDType
(→ Accommodations.id)
11Standard Double
22Luxury Twin
33Deluxe Triple
44Premium Quad
55Superior Double
66Executive Twin
77Ultra Deluxe Triple
88Presidential Quad

Prices

idRoomIDPrice_Per_NightAvailableFromAvailableTo
(→ Rooms.id)
111502023-01-012023-12-31
221602023-01-012023-12-31
331502023-01-012023-12-31
441602023-01-012023-12-31

Bookings

idCustomerNameArrivalDateDepartureDateRoomIDTotalCost
(→ Rooms.id)
1John Doe2023-05-012023-05-051650
2Jane Smith2023-05-012023-05-052700
3Alice Johnson2023-05-012023-05-053650
4Bob Brown2023-05-012023-05-054700

Customers

idFirstNameLastNameEmailPhoneNumber
1JonathanSmithjsmith@email.com123-456-7890
2EmilyJohnsonejohnson@email.com098-765-4321
3DavidWilliamsdwilliams@email.com555-555-5555
4SamanthaMartinsmartin@email.com555-555-5556