## Staff

id | firstName | lastName | position
--- | --- | --- | ---
1 | John | Doe | Manager
2 | Jane | Smith | Assistant Manager

## Chefs

id | staffId | experience
--- | --- | ---
| (→ Staff.id) |
1 | 1 | 5 years
2 | 2 | 3 years

## Sous_Chef

id | chefId
--- | ---
| (→ Chefs.id)
1 | 1
2 | 2

## Cooks

id | chefId
--- | ---
| (→ Chefs.id)
1 | 1
2 | 2

## MenuItems

id | itemName | preparationTime | price
--- | --- | --- | ---
1 | Burger | 10 | 9.99
2 | Pizza | 15 | 12.99

## Orders

orderId | sousChefId | cookId | totalPrice
--- | --- | --- | ---
| (→ Sous_Chef.id) | (→ Cooks.id) |
1 | 1 | 1 | 28.97
2 | 2 | 2 | 26.98