| 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 |
| ID | AmenityName |
|---|---|
| 1 | Free WiFi |
| 2 | Gym Access |
| 3 | Concierge Service |
| 4 | Room Service |
| 5 | Parking Facilities |
| 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 |
| ID | Name | 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 |
| ID | OptionType | Price |
|---|---|---|
| 1 | Day Spa | 150.0 |
| 2 | Day Spa | 200.0 |
| 3 | Wellness Retreat | 150.0 |
| 4 | Wellness Retreat | 200.0 |
| 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 |