Question

Consider the following scenario: You are the owner of a coffee shop. You need a way to track all of your customers, orders, and any sales you may be running. with the data you store, you will be running reports each month to gain insight into the overall wellbeing of the coffee shop. Things like, the number of customers per day, what they order, and how often they return are important to you. Provide the following:

1. Create an ER diagram that depicts a database that could handle the situation described above. The ER diagram MUST be in PDF format.

2. Put together a script file (.SQL) that will create the database, create the tables and columns, create the relationships, and insert some sample data.

3. Run the script file to be sure it works

Please submit only TWO items: A PDF file containing the ER diagram A .sql file containing the script to build the database