Exercise: A Food Ordering System Create an ER diagram Wright Pizza is loved by college students and faculty. The restaurant uses a Food Ordering System to manage its operations among customers, the restaurant manager, and the kitchen. Every time a customer orders food, the Food Processing System takes the customer's order and gives a receipt to the customer, and sends the food order to the kitchen. The system also generates reports for managers. More specifically, when an order comes in, the system first receives and transforms the food order, and sends the order to the kitchen. At the same time, the system updates the Goods Sold file, which sends Formatted Goods Sold data to the database named Goods Sold. The system also updates the Inventory File, which sends Formatted Inventory Data to the database named Inventory. The system produces Management Reports based on the data of Daily Goods Sold Amounts from the database of Goods Sold and the data from the Daily Inventory Depletion Amounts from the database of Inventory. Once generated, the Management Reports are sent to the Restaurant Manager. Exercise: A Food Ordering System Create an ER diagram Wright Pizza is loved by college students and faculty. The restaurant uses a Food Ordering System to manage its operations among customers, the restaurant manager, and the kitchen. Every time a customer orders food, the Food Processing System takes the customer's order and gives a receipt to the customer, and sends the food order to the kitchen. The system also generates reports for managers. More specifically, when an order comes in, the system first receives and transforms the food order, and sends the order to the kitchen. At the same time, the system updates the Goods Sold file, which sends Formatted Goods Sold data to the database named Goods Sold. The system also updates the Inventory File, which sends Formatted Inventory Data to the database named Inventory. The system produces Management Reports based on the data of Daily Goods Sold Amounts from the database of Goods Sold and the data from the Daily Inventory Depletion Amounts from the database of Inventory. Once generated, the Management Reports are sent to the Restaurant Manager