HotelID | Opening_Year | Opening_Month | Name | Address | City | Country |
---|---|---|---|---|---|---|
1 | 2000 | 1 | Grand Plaza | 123 Main St | New York | USA |
2 | 2018 | 6 | The Ritz | 456 Broadway | London | UK |
3 | 2005 | 9 | Ocean View | 789 Beach Ave | Miami | USA |
RoomID | HotelID | Type | Capacity | Rate |
---|---|---|---|---|
(→ Hotels.HotelID) | ||||
1 | 1 | Standard | 4 | 150.0 |
2 | 1 | Deluxe | 2 | 200.0 |
3 | 2 | Luxury | 1 | 300.0 |
4 | 2 | Suite | 2 | 400.0 |
5 | 3 | Sea View | 4 | 180.0 |
BookingID | GuestID | RoomID | CheckInDate | CheckOutDate | TotalCost |
---|---|---|---|---|---|
(→ Guests.GuestID) | (→ Rooms.RoomID) | ||||
1 | 1 | 1 | 2022-01-01 | 2022-01-05 | 600.0 |
2 | 2 | 2 | 2022-01-10 | 2022-01-14 | 800.0 |
3 | 3 | 3 | 2022-02-01 | 2022-02-05 | 720.0 |
4 | 4 | 4 | 2022-03-01 | 2022-03-05 | 960.0 |
5 | 5 | 5 | 2022-04-01 | 2022-04-05 | 840.0 |
GuestID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1234567890 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 |
3 | Alice | Brown | alice.brown@example.com | +1122334455 |
4 | Bob | White | bob.white@example.com | +2233445566 |
5 | Charlie | Black | charlie.black@example.com | +3344556677 |
StaffMemberID | FullName | Position | Department | HireDate |
---|---|---|---|---|
1 | Emma Jones | Receptionist | Front Desk | 2021-05-15 |
2 | Tom Smith | Housekeeping Supervisor | Housekeeping | 2021-06-01 |
3 | Ann Brown | Food and Beverage Manager | Restaurant | 2021-07-15 |
4 | Jack White | Maintenance Supervisor | Engineering | 2021-08-01 |
5 | Peter Black | Concierge | General Services | 2021-09-01 |
ServiceID | Description | Cost | Available |
---|---|---|---|
1 | Laundry service | 5.0 | 1 |
2 | Room cleaning | 10.0 | 1 |
3 | Shuttle to airport | 50.0 | 1 |
4 | Breakfast buffet | 20.0 | 1 |
5 | Gym access | 25.0 | 1 |