Design a restaurant database with 5 tables :
- Employee
- Menu
- order_tx
- order_tx_item
- customer
- Sorting menu items by descending order of popularity
- Calculating revenue, profit, and cost for each transaction
- Identifying the employee responsible for each transaction
- Tracking customer spending
- Summarizing daily revenue, cost, and profit."