Database Reference
In-Depth Information
orderLineSequenceNumber
:
"2",
productId : "2842",
orderLineQuantity : 25
}
orderLineQuantity : 25
} ] }
Recall from this section's introduction that relational data modeling is the process of cap-
turing how the business
works
by precisely representing business rules, while dimensional
data modeling is the process of capturing how the business is
monitored
by precisely rep-
resenting business questions. The thought process for this step is the same for both rela-
tional and dimensional physical data modeling, so let's look at an example of each.
For Relational
On the facing page is our relational logical data model from
Chapter 6
. I would take a pen-
cil and start grouping the logical entities together that I think would make efficient collec-
tions.
