Conceptual Data Modeling - Data Modeling for MongoDB - page 112

Student Attrition is the business process shown in the center of the circle and all of the
different levels of detail we can view Student Attrition by are shown on the various axes.

STEP 5: 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 review-
ing the model we go back and make some changes and then show them the model again.
This iterative cycle continues until the model is agreed upon by the validator and deemed
correct so we can move on to the logical modeling phase.

EXERCISE 5: C ONCEPTUAL D ATA M ODELING M INDSET

Recall the MongoDB document below we discussed in Chapter 3 . Think of at least ten
questions that you would ask during the conceptual data modeling phase based upon the
data you see in this collection. See Appendix A for some of the questions I would ask.

Order:
{ orderNumber : “4839-02”,
orderShortDescription : “Professor review copies of several titles”,
orderScheduledDeliveryDate : ISODate(“2014-05-15”),
orderActualDeliveryDate : ISODate(“2014-05-17”),
orderWeight : 8.5,
orderTotalAmount : 19.85,
orderTypeCode : “02”,
orderTypeDescription : “Universities Sales”,
orderStatusCode : “D”,
orderStatusDescription : “Delivered”,
orderLine :
[ { productID : “9781935504375”,
orderLineQuantity : 1
},

{ productID : “9781935504511”,

orderLineQuantity : 3
},
{ productID : “9781935504535”,
orderLineQuantity : 2
} ] }