Survey Data Entry - Data Modeling for MongoDB - page 199

Industry and Organization have similar usage and therefore can be combined. Also, a
number of the survey entities can be combined. The subtypes Pending Survey , Active
Survey , and Retired Survey can be rolled up into Survey . Survey Section is dependent
on Survey and can be rolled up as well. In addition, because Survey Category and Survey
have similar volatility, they can be combined.
Survey Respondent and Completed Survey are close to a one-to-one relationship; there
appears to be little if any way to identify when the same person completes more than one
survey because we know very little about the respondent. Also, most likely both Survey
Respondent and Completed Survey experience little if any changes over time and there-
fore have similar volatility.
Survey Question Possible Answer is dependent upon Possible Answer and Survey
Question , yet because there is another relationship from Survey Question , we can leave
Survey Question intact and embed Possible Answer into Survey Question Possible An-
swer .