Rooms

RoomIDBuildingAreaSpaOccupiedRate
1Building AArea 10110299.99
2Building BArea 20101399.99
3Building CArea 30111499.99
4Building DArea 40100599.99
5Building EArea 50110699.99

Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+123456789
2JaneSmithjane.smith@example.com+987654321
3MichaelBrownmichael.brown@example.com+111222333
4EmilyWhiteemily.white@example.com+444555666
5DavidBlackdavid.black@example.com+777888999

Reservations

ReservationIDCustomerIDCheckInDateCheckOutDateTotalAmount
(→ Customers.CustomerID)
112023-01-012023-01-051000.0
222023-01-102023-01-151200.0
332023-01-202023-01-251400.0
442023-02-012023-02-051600.0
552023-02-102023-02-151800.0

Services

ServiceIDDescriptionPrice
1Room upgrade to suite150.0
2Extra bed50.0
3Late checkout100.0
4Breakfast buffet30.0
5Welcome drink at bar15.0

BookedServices

BookingIDReservationIDServiceIDQuantityTotalAmount
(→ Reservations.ReservationID)(→ Services.ServiceID)
1111150.0
212150.0
3131100.0
414130.0
515115.0