Salads
id | Name | Price | Quantity | BuffetName |
1 | Greek Salad | 9.99 | 30 | Hilton |
2 | Caesar Salad | 8.99 | 25 | Marriott |
3 | Mixed Greens Salad | 7.99 | 20 | Hyatt |
4 | Veggie Delight | 6.99 | 15 | Wyndham |
5 | Quinoa Salad | 7.99 | 20 | Intercontinental |
Soups
id | Name | Price | Quantity | BuffetName |
1 | Tomato Bisque | 5.99 | 25 | Hilton |
2 | Chicken Noodle | 4.99 | 30 | Marriott |
3 | Minestrone | 6.99 | 20 | Hyatt |
4 | Lobster Bisque | 9.99 | 15 | Wyndham |
5 | Vegetable Beef Barley | 6.99 | 20 | Intercontinental |
Desserts
id | Name | Price | Quantity | BuffetName |
1 | Cheesecake | 4.99 | 25 | Hilton |
2 | Tiramisu | 5.99 | 30 | Marriott |
3 | Banana Split | 6.99 | 20 | Hyatt |
4 | Apple Pie | 5.99 | 15 | Wyndham |
5 | Red Velvet Cake | 7.99 | 20 | Intercontinental |
Beverages
id | Name | Price | Quantity | BuffetName |
1 | Cola | 1.99 | 50 | Hilton |
2 | Espresso | 3.99 | 40 | Marriott |
3 | Orange Juice | 2.99 | 35 | Hyatt |
4 | Sparkling Water | 1.99 | 40 | Wyndham |
5 | Tea | 2.99 | 30 | Intercontinental |
Staffs
id | FirstName | LastName | Position | HireDate |
1 | John | Doe | Manager | 2021-05-01 |
2 | Jane | Smith | Waiter | 2021-06-01 |
3 | Alice | Johnson | Host | 2021-07-01 |
4 | Bob | Williams | Chef | 2021-08-01 |
5 | Emily | Davis | Busser | 2021-09-01 |
Customers
id | FirstName | LastName | ContactNumber | Email |
1 | Samuel | Anderson | +1234567890 | sam@example.com |
2 | David | Miller | +1234567891 | david@example.com |
3 | Rachel | Thomas | +1234567892 | rachel@example.com |
4 | James | Jackson | +1234567893 | james@example.com |
5 | Laura | White | +1234567894 | laura@example.com |