1. Create an ER diagram (similar to Figure 238 in the book) for the system. 2. Create a list of database requirements based on the diagram (e.g. each order must have at least one product) 3. Develop at least three User Stories for the system. Each user story should follow the format described in the slides to explain how users will "use" the system in support of a particular activity. Be sure to include acceptance criteria. 4. Prototype screens: For each user story, include at least one sketch of a screen and/or report showing how that part of the system will work. Screens can be hand drawn or use a tool such as LucidChart. 5. Assuming the database is hosted on Azure, draw an architectural diagram for how the system could be implemented, showing where the various parts of Figure 1.4 will actually run or be stored. Include a description of which client platforms will actually be used. Description of Moonshot Express Coffee Shop Moonshot Express Coffee Shop This small coffee shop with three stores in the greater Oshkosh area is looking to implement a new information systems and has asked for your help to design the database and write some queries as the basis for the system. 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-ditferent' - purchased five different products - Etr - 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: - Extra shot of espresso: 50.50 - Favored syrupi 5025 per flavor added - 257 discount on all caffeinated beverages after 5 pm