help create an ERD chart for this please.

Background: Gold Star Pizza & Brewery Gold Star Pizza & Brewery (GSPB) has been serving pizza, wings, and garlic bread as well as operating a small brewery for several years. With locations in Oshkosh, Appleton, and Green Bay, GSPB is very popular across Northeast Wisconsin. While popular, GSPB has not really adapted to the online world. While they have a strong social media presence, they do not allow any online ordering. There is no app. There is only a minimal website presence that directs users to their Facebook site. You were just promoted to shift supervisor and are very excited about your $1.00/hour raise. So much has changed in the past couple of weeks. The world has been besieged by a pandemic--Modelovirus--that causes severe respiratory problems. The government has ordered that all public gatherings and most businesses be closed down to avoid the spread of the virus. (I know, total science fiction, right?). GSPB is a mess. The loss of revenue (complete lack of revenue) is a problem. You do not have the technology to accept online orders or electronic payments. The stores are trying to keep up the telephone orders but orders are lost, totals are incorrect, supplies are not being tracked, and orders are being incorrectly handed to customers. Oh, and you can only accept an actual credit card or cash. Given this situation, GSPB has decided to shut down. Knowing that you have currently enrolled in Info Sys 311 Essentials of Information Systems, the owner has asked you and a small team to work together remotely to develop a software solution to save the company. You have only a few weeks (ironically, the same time as the remainder of the semester) to develop a plan to save the company. Your Team Assignment Save Gold Star Pizza & Brewery. Prepare a presentation that showcases your recommended technology solution(s). You will have to make this presentation on the date assigned in Canvas. This will be a live presentation at the time you are Data Analytics What business questions can you answer with the data collected from your website and updated information system? Your leaders will be looking to gain an edge on the competition: How can the data collected from this project help give them that edge? Can it be integrated with other data to gain further insights? Show them how the data are connected and what kinds of information they can reasonably extract from that data (ERD, list of 5 business questions). Create an ERD showing what data is collected in the solutions(s), how they are stored in tables, and how those data/tables relate to each other. ERD information may be seen in Unit 8. Write five (5) business questions important to the success of GSPB which can be answered directly from the data collected in the tables. Background: Gold Star Pizza & Brewery Gold Star Pizza & Brewery (GSPB) has been serving pizza, wings, and garlic bread as well as operating a small brewery for several years. With locations in Oshkosh, Appleton, and Green Bay, GSPB is very popular across Northeast Wisconsin. While popular, GSPB has not really adapted to the online world. While they have a strong social media presence, they do not allow any online ordering. There is no app. There is only a minimal website presence that directs users to their Facebook site. You were just promoted to shift supervisor and are very excited about your $1.00/hour raise. So much has changed in the past couple of weeks. The world has been besieged by a pandemic--Modelovirus--that causes severe respiratory problems. The government has ordered that all public gatherings and most businesses be closed down to avoid the spread of the virus. (I know, total science fiction, right?). GSPB is a mess. The loss of revenue (complete lack of revenue) is a problem. You do not have the technology to accept online orders or electronic payments. The stores are trying to keep up the telephone orders but orders are lost, totals are incorrect, supplies are not being tracked, and orders are being incorrectly handed to customers. Oh, and you can only accept an actual credit card or cash. Given this situation, GSPB has decided to shut down. Knowing that you have currently enrolled in Info Sys 311 Essentials of Information Systems, the owner has asked you and a small team to work together remotely to develop a software solution to save the company. You have only a few weeks (ironically, the same time as the remainder of the semester) to develop a plan to save the company. Your Team Assignment Save Gold Star Pizza & Brewery. Prepare a presentation that showcases your recommended technology solution(s). You will have to make this presentation on the date assigned in Canvas. This will be a live presentation at the time you are Data Analytics What business questions can you answer with the data collected from your website and updated information system? Your leaders will be looking to gain an edge on the competition: How can the data collected from this project help give them that edge? Can it be integrated with other data to gain further insights? Show them how the data are connected and what kinds of information they can reasonably extract from that data (ERD, list of 5 business questions). Create an ERD showing what data is collected in the solutions(s), how they are stored in tables, and how those data/tables relate to each other. ERD information may be seen in Unit 8. Write five (5) business questions important to the success of GSPB which can be answered directly from the data collected in the tables