## RoomType

ID | TypeName | Price
--- | --- | ---
1 | Standard | 99.99
2 | Deluxe | 129.99
3 | Luxury Suite | 309.99
4 | Presidential Suite | 609.99
5 | Family Suite | 279.99

## Amenities

ID | AmenityName
--- | ---
1 | Free WiFi
2 | Gym Access
3 | Concierge Service
4 | Room Service
5 | Parking Facilities

## Booking

ID | CheckInDate | CheckOutDate | TotalNights | CustomerID
--- | --- | --- | --- | ---
|  |  |  | (→ Customers.ID)
1 | 2022-08-01 | 2022-08-07 | 6 | 1
2 | 2022-08-15 | 2022-08-21 | 6 | 2
3 | 2022-08-30 | 2022-09-05 | 6 | 3
4 | 2022-09-10 | 2022-09-17 | 7 | 4
5 | 2022-09-25 | 2022-09-30 | 6 | 5

## Customers

ID | Name | Email | PhoneNumber
--- | --- | --- | ---
1 | John Doe | john@example.com | +1234567890
2 | Jane Smith | jane@example.com | +0987654321
3 | Michael Johnson | michael@example.com | +1122334455
4 | Emily Davis | emily@example.com | +2233445566
5 | William Brown | william@example.com | +3344556677

## RelaxationOptions

ID | OptionType | Price
--- | --- | ---
1 | Day Spa | 150.0
2 | Day Spa | 200.0
3 | Wellness Retreat | 150.0
4 | Wellness Retreat | 200.0

## Packages

ID | PackageName | Description | BasePrice | ExtraCost
--- | --- | --- | --- | ---
|  |  |  | (→ RelaxationOptions.Price)
1 | Honeymoon Special | Romantic package includes champagne and rose petals on arrival. | 250.0 | 75.0
2 | Business Traveller | Special package for business travellers including breakfast and free internet. | 300.0 | 50.0
3 | Fitness Enthusiast | Perfect for fitness lovers including gym access and personal trainer sessions. | 350.0 | 100.0
4 | Culinary Delight | Tailored packages for foodies including cooking classes and wine tasting. | 400.0 | 150.0
5 | Entertainment Seeker | Packed with entertainment options like tickets to local attractions and live shows. | 450.0 | 200.0