RoomType

IDTypeNamePrice
1Standard99.99
2Deluxe129.99
3Luxury Suite309.99
4Presidential Suite609.99
5Family Suite279.99

Amenities

IDAmenityName
1Free WiFi
2Gym Access
3Concierge Service
4Room Service
5Parking Facilities

Booking

IDCheckInDateCheckOutDateTotalNightsCustomerID
(→ Customers.ID)
12022-08-012022-08-0761
22022-08-152022-08-2162
32022-08-302022-09-0563
42022-09-102022-09-1774
52022-09-252022-09-3065

Customers

IDNameEmailPhoneNumber
1John Doejohn@example.com+1234567890
2Jane Smithjane@example.com+0987654321
3Michael Johnsonmichael@example.com+1122334455
4Emily Davisemily@example.com+2233445566
5William Brownwilliam@example.com+3344556677

RelaxationOptions

IDOptionTypePrice
1Day Spa150.0
2Day Spa200.0
3Wellness Retreat150.0
4Wellness Retreat200.0

Packages

IDPackageNameDescriptionBasePriceExtraCost
(→ RelaxationOptions.Price)
1Honeymoon SpecialRomantic package includes champagne and rose petals on arrival.250.075.0
2Business TravellerSpecial package for business travellers including breakfast and free internet.300.050.0
3Fitness EnthusiastPerfect for fitness lovers including gym access and personal trainer sessions.350.0100.0
4Culinary DelightTailored packages for foodies including cooking classes and wine tasting.400.0150.0
5Entertainment SeekerPacked with entertainment options like tickets to local attractions and live shows.450.0200.0