ID | Name | Position | Hotel_ID |
---|---|---|---|
1 | John Doe | 186e16">Housekeeper | 1 |
2 | Jane Smith | Housekeeper | 2 |
3 | Mike Johnson | 186e16">Laundry Attendant | 1 |
4 | Emily Davis | Laundry Attendant | 2 |
5 | William Brown | Room Attendant | 3 |
6 | Anna Wilson | Porter | 4 |
7 | David Miller | Manager | 1 |
8 | Sarah Jones | Assistant Manager | 2 |
ID | Number | Type | Floor | Hotel_ID |
---|---|---|---|---|
1 | 101 | Deluxe Suite | 1 | 1 |
2 | 202 | Standard Room | 2 | 1 |
3 | 303 | Family Suite | 3 | 2 |
4 | 404 | Executive Room | 4 | 3 |
5 | 505 | Superior Room | 5 | 4 |
6 | 606 | Budget Room | 6 | 1 |
7 | 707 | Standard Suite | 7 | 2 |
8 | 808 | Economy Room | 8 | 3 |
ID | Name | Location | Manager_Name |
---|---|---|---|
1 | The Grand Hotel | Downtown | David Miller |
2 | City Center Inn | Uptown | Sarah Jones |
3 | Waterfront View | Seaside | None |
4 | Cozy Inn | Suburbia | None |
ID | Service_Type | Description | Price |
---|---|---|---|
1 | Accommodation | Comfortable stay at our hotel. | 99.99 |
2 | Breakfast | Full English breakfast included. | 15.0 |
3 | Transport | Shuttle service available. | 20.0 |
4 | Entertainment | Live music on weekends. | 10.0 |
5 | Fitness Centre | State of the art gymnasium. | 5.0 |