Hotels

HotelIDOpening_YearOpening_MonthNameAddressCityCountry
120001Grand Plaza123 Main StNew YorkUSA
220186The Ritz456 BroadwayLondonUK
320059Ocean View789 Beach AveMiamiUSA

Rooms

RoomIDHotelIDTypeCapacityRate
(→ Hotels.HotelID)
11Standard4150.0
21Deluxe2200.0
32Luxury1300.0
42Suite2400.0
53Sea View4180.0

Bookings

BookingIDGuestIDRoomIDCheckInDateCheckOutDateTotalCost
(→ Guests.GuestID)(→ Rooms.RoomID)
1112022-01-012022-01-05600.0
2222022-01-102022-01-14800.0
3332022-02-012022-02-05720.0
4442022-03-012022-03-05960.0
5552022-04-012022-04-05840.0

Guests

GuestIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321
3AliceBrownalice.brown@example.com+1122334455
4BobWhitebob.white@example.com+2233445566
5CharlieBlackcharlie.black@example.com+3344556677

StaffMembers

StaffMemberIDFullNamePositionDepartmentHireDate
1Emma JonesReceptionistFront Desk2021-05-15
2Tom SmithHousekeeping SupervisorHousekeeping2021-06-01
3Ann BrownFood and Beverage ManagerRestaurant2021-07-15
4Jack WhiteMaintenance SupervisorEngineering2021-08-01
5Peter BlackConciergeGeneral Services2021-09-01

Services

ServiceIDDescriptionCostAvailable
1Laundry service5.01
2Room cleaning10.01
3Shuttle to airport50.01
4Breakfast buffet20.01
5Gym access25.01