Database Reference
In-Depth Information
Note that often during the process of building the logical data model, we refine (and some-
times correct) rules we identified during the conceptual data modeling stage. For example,
upon examining the primary key to
MonthlyStatementFee
, we learned that it shared the
same primary key as
BankAccountStatement
. After further analysis, we moved the fee
amount to
BankAccountStatement
and removed
MonthlyStatementFee
. We also learned
that there is a one-to-many relationship between
Account
and
BankAccountStatement
,
not a many-to-many relationship. We also uncovered the new property,
monthlyState-
mentDate
, which is needed to distinguish
BankAccountStatements
belonging to the same
Account
.
For Dimensional
Similar to relational, there are multiple notations we can choose for the dimensional logical.
Here is our University dimensional LDM using the traditional information engineering
notation: