Database Reference
In-Depth Information
as
Survey Respondent
or
Organization
. But what value would abstracting into
Party
provide us here? We would lose precision and the model would become more difficult to
read, and it is difficult to come up with a business scenario where the
Party
concept would
be valuable.
STEP 3: DETERMINE THE MOST USEFUL FORM
We determine that the traditional data modeling form would work well for our users, so
here is our fully normalized data model, which is the same as our 2NF model:
STEP 4: REVIEW AND CONFIRM
Previously, we identified the person or group responsible for validating the model. Now we
need to show them the model and make sure it is correct. Often at this stage after reviewing
the model, we go back to Step 1 and make some changes and then show the validators the
model again. This iterative cycle continues until the model is agreed upon by the validators
and deemed correct so that we can move on to the physical modeling phase.