Question: please answer fast thank u Long Answers: (70 points) 1. You are being recruited as a Systems Analyst in the newly opened coffee shop called
please answer fast thank u
Long Answers: (70 points) 1. You are being recruited as a Systems Analyst in the newly opened coffee shop called Urban Bean. They want to build a new Point of Sale system where the customers can purchase items from their shop and checkout. The shop sells the following items: 1. Beverages 2. Bakery goods 3. Bean cards - customers can load their coffee cards with any amount and use it for the purchase. A customer can buy one or more beverages or baked good and a beverage or baked good can be bought by 1 or more customers. A customer places an order to buy different items. A customer can be purchase a bean card of any amount and a bean card is assigned only for 1 customer. A customer can use different payment methods including a bean card. For the above system: a. Draw an ERD by identifying the entities, attributes and their relationships. ( 20 points) b. Decompose the system into sub components and draw a Level-0 DFD ( 30 points) 2. For the below Un-normalized table, apply the normalization forms and list all the Normalized tables ( 20 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
