Database Reference
In-Depth Information
This iterative cycle continues until the model is agreed upon by the validator and deemed
correct so that we can move on to the physical modeling phase.
EXERCISE
6:
L
OGICAL
D
ATA
M
ODELING
M
INDSET
Recall the MongoDB document below, which we discussed in our last chapter. Think of at
least ten questions that you would ask during the logical 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
} ] }
Key Points
