Database Reference
In-Depth Information
author : “Arkady Maydanchik”
},
{ titleName : “Data Modeling Theory and Practice”,
pageCount : 300,
publicationYear : “2008”,
author : “Graeme Simsion”
} ] )
Here is the statement to remove
FruITion
from the Title collection:
db.Title.remove( { titleName : “FruITion” } )
Here is the statement to update the page count for
Data Quality Assessment
to
350
:
db.Title.update ( { titleName : “Data Quality Assessment” }, { “$set” : { pageCount : 350 } } )
To view all of the data, run
db.Title.find( )
:
{ “_id” : ObjectId(“5367cdc79e6bbb07630a3a7a”), “titleName” : “Data Quality Assessment”, “pageCount” : 350, “pub-
licationYear” : “2009”, “author” : “Arkady Maydanchik” }
{ “_id” : ObjectId(“5367cdc79e6bbb07630a3a7b”), “titleName” : “Data Modeling Theory and Practice”, “pageCount” :
300, “publicationYear” : “2008”, “author” : “Graeme Simsion” }
EXERCISE
5:
C
ONCEPTUAL
D
ATA
M
ODELING
M
INDSET
Here are some of the conceptual data modeling questions I would ask based upon this doc-
ument:
•
What is an
Order
?
•
What is an
Order Line
?
•
What is a
Product
?
•
Can an
Order
contain more than one
Order Line
?
•
Can an
Order Line
belong to more than one
Order
?
•
Can an
Order
exist without an
Order Line
?
•
Can an
Order Line
exist without an
Order
?