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.

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.

Question Build an ERD. Include the attributes like ProductID and ProductName & Include the attributes from IngredientID and IngredientName

Question Translate the above ERD into a relational schema.