Instructions: You are tasked with providing database support to a small local ice cream shop. You will need to create an Entity Relationship diagram for the business and answer the below questions describing the data you are going to store. You will provide some answers in this document which you should SAVE AS and name your file as HW1_LastName_FirstName. You need to use an ERD software product (i.e., MS Visio, ERwin, draw.io, etc.). You can save your ERD and relational schema as .jpg files and insert them into the end of this document. Alternatively, you can submit a PDF of your ERD and relational schema named as HW1_Figures_ LastName_FirstName. Please make sure the resolution of your ERD is sufficient to read. The assignment is meant to test your thought process on thinking about how to store data, the scenario is meant to be missing a few pieces which youll want to think about. At the end of this document, you can provide any additional notes that you want to include on how you developed your ERD.

Assignment: The Ice Cream shop keeps data on their customers, which includes an email address and the customers first and last name, and a phone number, not all customers have this information, and can only have 1 email, name, and phone number on record for each customer. The Ice Cream shop is run by Employees with more veteran employees being classified as Managers. Using a database, the shop would like to store the full name, address, phone number and hourly wage of each employee. The shop only has 3 locations, an Employee can only work at one location at a time. However, each location has multiple employees. Each Location sells on average 20 different kinds of ice creams, gelatos, or sorbets. Each type of product has multiple ingredients that are used to produce the product. A customer can purchase a product at any location. Not all products are sold at all locations. Employees can only have one manager, while Managers have multiple employees.