If you have additional time, consider the following exercises:
- Create a Python script to insert new entries into the menu.food and menu.prices tables. Hint: use the transaction methods of the Connection object to ensure that none or both of the tables get updated.
- Reflecting your menu's commercial advantage by size, create a trigger that automatically increments the price of all items in the menu.prices table every time a new food item is inserted, and which decrements the price every time a food item is deleted.
- For an additional challenge, ensure that the trigger only operates on every item other than the item being inserted or deleted.