1-Customers can use ATM machines to deposit cash. ATMs are located in various locations, such as inside...
Question:
1-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 etc). 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 (https://en.wikipedia.org/wiki/Automated_teller_machine) or so some research online.
Business Process 1: accept cash (consider only bill notes) deposit from customer who is using ATM machine
Grain: per session of bills deposited into ATM machine
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:
Dimension_Customer
(PK) Attribute 1
Attribute 2
.....
Dimension_Location
(PK) Attribute 1
Attribute 2
.....
Dimension_Account
(PK) Attribute 1
Attribute 2
.....
Fact_DepositSession
(PK) Attribute 1
Attribute 2
.....
2-Context: Describe a non-business context (for example, play a PC game, buy something from online shopping sites, watch a soccer game etc) based on your hobby or interests. Provide as much details as possible (just like question 1).
summarize the process in one sentence using action verb.
Select grain and describe it.
Come up with as many (at least 5) dimensions as possible. Then come up with at least 50 attributes in total for dimension tables and fact table.
You can use the templates below:
DimensionName1
(PK) Attribute 1
Attribute 2
.....
DimensionName2
(PK) Attribute 1
Attribute 2
.....
.......
DimensionNameX
(PK) Attribute 1
Attribute 2
.....
FactName
(PK) Attribute 1
Attribute 2
.....
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright