Question: please share your screenshot Dimension Customer (PK) Attribute 1 Attribute 2 Question 1 (10 points) Context: Customers can use ATM machines to deposit cash. ATMs

please share your screenshot please share your screenshot Dimension Customer (PK) Attribute 1 Attribute 2 Question

Dimension Customer (PK) Attribute 1 Attribute 2 Question 1 (10 points) Context: Customers can use ATM machines to deposit cash. ATMs are located in various locations, such as inside supermarket, convenience store, bank branch. Some are located inside standalone facility that requires swiping cards to enter. Customers and related information are identified from their debit cards. A customer may have more than one account with the bank. The customer can choose which account he or she wants to deposit cash into. The ATM machine will then start a session to accept up to a certain number bills (for example, "insert up to 50 bills at a time"). The customer can then insert bills with various denominations (such as $20, $50, $100 StG). If the customer has more bills, ATM will start another deposit session after accepting all bills in the current session. During any sessions, damaged or fake notes are not accepted by ATMs and will be returned to customers, but such deposit attempts are recorded in database. For more details about ATMs, feel free to look up wiki or so some research online. Dimension Location (PK) Attribute 1 Attribute 2 Business Process 1: accept cash (consider only bill notes) deposit from customer who is using ATM machine Dimension Account Grain: per session of bills deposited into ATM machine (PK) Attribute 1 Attribute 2 Dimensions: Customer, Location, Account Come up with at least 50 attributes in total for dimension tables and fact table. You can use the template below: Fact DepositSession (PK) Attribute 1 Attribute 2

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 Databases Questions!