|
Date
|
|
|
|
Teller
|
|
Date Key
Date
Day of Week
Quarter
Year
|
|
|
Branch
|
|
Branch Key
Branch Number ID
Branch City
Branch State
Branch Supervisor
|
|
|
Teller Key
Teller ID
Teller Name
Teller working hour
Teller Address
Teller Phone Number
|
|
|
|
Transaction_Type
|
|
|
|
|
|
Transaction Type Key
Transaction ID
Deposit
Withdrawal
Loan Pmt
Loan Origination
Credit Card
Debit Card
Open Account
Close Account
Transaction Amount
|
|
|
|
Customer
|
|
|
|
Account_Type
|
|
Customer Key
Customer ID
Customer Name
Customer Address
Customer City
Customer Zip code
Customer Sate
Customer Phone Number
|
|
|
|
Account Type Key
Account ID
Checking
Savings
Car Loan
Mortgage Loan
Home Equity Line
of Credit
Certificate of Deposit
Business
Personal
|
|
|