Create an ER DIagram with the requirements listed below. They must also include the database relationship based on the diagram

The owners of Moonshot wishes to record all purchases in a computer system to track sales. They want to create a membership system to increase customer loyalty. Another plan is to introduce a system where customers can pay using their membership card, which can be loaded with money in the store. But the first order of business is simply to ensure proper tracking of purchases in order to make sure the business will be profitable.

Here are some of the features they are looking to implement in the system:

• Track purchases to determine various cash flow and accounting questions
• Analyze the product portfolio to determine which products are selling well and which ones could be eliminated
• Determine most popular times of day for staff scheduling purposes.
• Implement a customer loyalty program that would provide rewards to customers based on the purchases they have made. The expectation is that the kinds of rewards will evolve over time, but may include a number of badges such as
  • Crossing various volume thresholds ($10, $50, $200 etc in total purchases)
  • Three-of-kind - when a customer bought the same drink three times
  • Five-different - purchased five different products
  • Etc.
• Various analyses of product sales
• The purchases should also be linked to specific employees. This may be for reward purposes, but could also be used to determine if any problems came up with a particular order who was on staff who made the sale.
• If you are feeling ambitious, you can consider how Moonshot Express might track their expenses, including raw materials, wages etc.

List of products and prices:

	Small	Medium	Large
Black coffee	1.59	1.79	1.99
Decaf Coffee	1.59	1.79	1.99
Americano	1.89	1.99	2.19
Cappuchino	2.49	3.29	3.79
Iced Tea (non-caffeine)	1.19	1.39	1.59

• Extra shot of espresso: $0.50
• Flavored syrup: $0.25 per flavor added
• 25% discount on all caffeinated beverages after 5pm.