Survey Data Entry - Data Modeling for MongoDB - page 186

Bob Jones

Survey
Respondent
Name

The name the survey respondent writes on the completed
survey. This name is not validated and can just contain the
first name, just the last name, or both.

Jones Char 100

Bob

Survey
Respondent
ID

A unique and required system-generated value for each sur-
vey respondent.

123456 Num 6

Completed
Survey Free
Form Re-
sponse Text

Captures the responses to those questions that do not require
a fixed response such as the answer to “What was your favor-
ite dessert?”

Brownie Sundae Char 255

Completed
Survey Fixed
Response
Answer

Male

Captures the responses to those questions that require a fixed
response such as the gender question.

Char 100

Female

The date the survey respondent completed the survey. If this
date is unknown, this will be the date the survey data is re-
ceived by the application.

Completed
Survey Date

Apr-15-2014 Date

STEP 2: NORMALIZE AND ABSTRACT (RELATIONAL ONLY)

The model we are building is relational, and therefore we will need to normalize and also
decide where (if at all) to apply abstraction.

First Normal Form (1NF)
For first normal form, we need to move repeating attributes to a new entity and also separ-
ate multi-valued attributes. Following the question templates from Chapter 6 , we asked the
business analysts these questions and received answers for each:

Question Yes? No?