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 areplease 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!