10-24. 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 Book 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 “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 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.
10-25. Write two HIVE queries, the both to create a PRODUCT table with fields ProdID, Name, Seller, Price. Make all necessary assumptions.
Exercise 2: