For each situation presented below, illustrate a document as depicted in Figures 10-4 and 10-5 and specify
Question:
For each situation presented below, illustrate a document as depicted in Figures 10-4 and 10-5 and specify whether it contains an array, an embedded subdocument, relationships, or collections. Use hypothetical data and make necessary assumptions.
a. A document containing Books details: Title, Publisher, Year, and Edition.
b. Add Author name: First name and Last name to the document and specify the type of document.
c. Now add “Sales Region,” which has the subfields “Region” and “RCode” and can take values of “NorthEast,” “SouthWest,” “SouthEast,” and “01,” “02,” “03,” respectively. Is this an array?
d. Assume that each book is reviewed by many Reviewers. Reviewer details—ID, Name (First and Last), Experience—are in a separate document. Present this relationship in a document.
Figure 10-4
(a)
(b)
Figure 10-5
(a)
(b)
Step by Step Answer:
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman