Database Reference
In-Depth Information
confirm step where we need go back to Step 1 and refine our concepts. Expect iteration
through these steps, until the logical data model is confirmed and then we can start the
physical. Let's talk more about each of these four steps.
STEP 1: FILL IN THE CDM
We fill in the CDM by identifying and defining the properties of each concept. The two
templates we complete at this step, the Properties Template and Property Characteristics
Template, are useful for both relational and dimensional efforts.
The Properties Template captures the properties (also known as attributes or data elements)
of each conceptual entity:
Properties Template
Entity A Entity B Entity C
Name
Text
Amount
Date
Code
Quantity
Number
Identifier
Indicator
