## FamilySuites

SuiteID | RoomNumber | OccupancyLimit | Amenities | Price_per_night
--- | --- | --- | --- | ---
1 | A123 | 6 | Air conditioning, TV, WiFi, Mini fridge | 150.0
2 | B456 | 8 | Air conditioning, TV, WiFi, Balcony, Microwave | 200.0
3 | C789 | 10 | Air conditioning, TV, WiFi, Kitchenette | 250.0
4 | D012 | 12 | Air conditioning, TV, WiFi, Safe, Bathtub | 300.0
5 | E345 | 14 | Air conditioning, TV, WiFi, Kitchenette, Terrace | 350.0

## SingleRooms

RoomID | NumberOfBeds | View | Services | Price_per_night
--- | --- | --- | --- | ---
1 | 1 | City view | TV, WiFi, Air conditioning | 150.0
2 | 1 | Mountain view | TV, WiFi, Minibar | 100.0
3 | 2 | Garden view | TV, WiFi, Air conditioning, Coffee/Tea maker | 120.0
4 | 2 | Pool view | TV, WiFi, Hairdryer, Ironing facilities | 130.0
5 | 1 | Sea view | TV, WiFi, Air conditioning, Refrigerator | 180.0

## Guests

GuestID | FullName | PhoneNumber | EmailAddress
--- | --- | --- | ---
1 | John Doe | +1234567890 | johndoe@example.com
2 | Jane Smith | +0987654321 | janesmith@example.com
3 | Michael Johnson | +1234567890 | michaeljohnson@example.com
4 | Emily Davis | +0987654321 | emilydavis@example.com
5 | David Brown | +1234567890 | davidbrown@example.com

## Bookings

BookingID | CheckInDate | CheckOutDate | TotalCost | GuestID
--- | --- | --- | --- | ---
|  |  |  | (→ Guests.GuestID)
1 | 2023-01-01 | 2023-01-05 | 600.0 | 1
2 | 2023-01-10 | 2023-01-15 | 1000.0 | 2
3 | 2023-01-15 | 2023-01-20 | 1500.0 | 3
4 | 2023-02-01 | 2023-02-05 | 400.0 | 4
5 | 2023-02-08 | 2023-02-12 | 750.0 | 5

## Payments

PaymentID | Amount | DatePaid | CardType | BookingID
--- | --- | --- | --- | ---
|  |  |  | (→ Bookings.BookingID)
1 | 600 | 2023-01-02 | Visa | 1
2 | 1000 | 2023-01-07 | Mastercard | 2
3 | 1500 | 2023-01-14 | American Express | 3
4 | 400 | 2023-02-01 | Visa | 4
5 | 750 | 2023-02-08 | Mastercard | 5

## Reviews

ReviewID | Rating | Comment | SubmissionDate | GuestID
--- | --- | --- | --- | ---
|  |  |  | (→ Guests.GuestID)
1 | 5 | Great stay! Excellent service. | 2023-01-06 | 1
2 | 4 | Very comfortable room, good location. | 2023-01-12 | 2
3 | 3 | The suite was nice but a bit expensive. | 2023-01-18 | 3
4 | 5 | Amazing experience! Highly recommended. | 2023-02-05 | 4
5 | 4 | Good value for money, would return. | 2023-02-15 | 5