Database Reference
In-Depth Information
The unique number assigned to
each account. This number is
unique across branches. Our
bank employees and our custom-
ers have knowledge of this num-
ber.
Account
Number
New Accoun-
tSystem
17382-112
Char
8
Not applicable
The favorite sports team of the
customer, which is captured to
allow the bank employees to
have casual conversations with
the customer.
Favorite
Sports
Team
Mets
Giants
Flyers
Char
100
CRM
Not applicable
Look at today's date and
the customer's last trans-
action date. If the differ-
ence is greater than ten
years, insert today's date.
The date captured for the point
where a customer has not had
any transactions for a ten-year
period.
Inactive
Date
03-12-2014
Date
Not applicable
The unique number assigned to
each check within a checking
account. This is the number pre-
printed on the upper right hand
corner of the check.
Check
Number
123
134
Num
3
Acct Txn App
Not applicable
With-
drawal
Amount
The amount taken out of an ac-
count as initiated by completing
a withdrawal slip.
$50.29
Dec
15,2
Acct Txn App
Not applicable
For Dimensional
The same two templates we just described for relational also apply to dimensional. Recall
our dimensional CDM from the last chapter:
