XXXXXXXXXXFor each situation presented below, illustrate a document as depicted in Figures 10-4 and 10-5 and specify whether it contains an a
ay, an embedded subdocument, relationships, or collections. Use hypothetical data and make necessary assumptions.
a. A document containing Book details: Title, Publisher, Year, and Edition.
. Add Author name: First name and Last name to the document and specify the type of document.
c. Now add “SalesRegion”, which has the subfields “Region” and “RCode”, and we can take values of “NorthEast”, “SouthWest”, “SouthEast”, and “01”, “02”, “03,” respectively. Is this an a
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.
10-25. Write two HIVE queries, the both to create a PRODUCT table with fields ProdID, Name, Seller, Price. Make all necessary assumptions.