Question: Hello, I understand the one question per post rule, but this problem kind of needs the previous answers to answer the next question. I feel
Hello, I understand the one question per post rule, but this problem kind of needs the previous answers to answer the next question. I feel like I got most of it done, so 4 & 5 are the only ones I'm stuck on. Thanks!

For the following set of problems, use the fact database and patron collection created in the text for use with MongoDB. 1. Create a new document in the patron collection. The document should satisfy the following requirements: First name is "Rachel" Last name is "Cunningham" Display name is "Rachel Cunningham" Patron type is student Rachel is 24 years old Rachel has never checked out a book Be certain to use the same keys as already exist in the collection. Be certain capitalization is consistent with the documents already in the collection. Do not store any keys that do not have a value (in other words, no NULLs). 2. Modify the document entered in the previous question with the following data. Do not replace the current document. Rachel has checked out two books on January 25,2018. The id of the first checkout is "95000" The first book checked out was book number 5237 Book 5237 is titled "Mastering the database environment" Book 5237 was published in 2015 and is in the "database" subject The id of the second checkout is "95001" The second book checked out was book number 5240 Book 5240 is titled "iOS Programming" Book 5240 was published in 2015 and is in the "programming" subject Use the same keys as already exist within the collection. Conform to the existing documents in terms of capitalization. 3. Write a query to retrieve the id, display name and age of students that have checked out a book in the cloud subject. 4. Write a query to retrieve only the first name, last name, and type of faculty patrons that have checked out at least one book with the subject "programming". 5. Write a query to retrieve the documents of patrons that are faculty and checked out book 5235 , or that are students under the age of 30 that have checked out book 5240. Display the documents in a readable format. 6. Write a query to display the only the first name, last name, and age of students that are between the ages of 22 and 26
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
