Question: need guidance on this mongodb query I've tried many variations but they did not work. I believe this query uses aggregate(). empeProject.js: *Note that coursehero
need guidance on this mongodb query
I've tried many variations but they did not work. I believe this query uses aggregate().


empeProject.js:
*Note that coursehero blocks emails so do replace "at" with the @ symbol.
db.empeProject.insert([ { "Employee": [ { "empeId": "e001", "fName": "James", "lName": "Bond", "email": "..d"at"hotmail.com", "experience": [ "Database Design", "SQL", "Java" ] }, { "empeId": "e002", "fName": "Harry", "lName": "Potter", "experience": [ "Data Warehouse", "SQL", "Spark Scala", "Java Scripts" ] } ], "Project": [ { "projectId": "p001", "projectTitle": "Install MongoDB" }, {"projectId": "p002", "projectTitle": "Install Oracle" }, {"projectId": "p003", "projectTitle": "Install Hadoop" } ], "EmployeeProject": [ { "empeId": "e001", "projectId": "p001", "hoursWorked": 4 }, { "empeId": "e001", "projectId": "p003", "hoursWorked": 2 }, { "empeId": "e002", "projectId": "p003", "hoursWorked": 5 } ] } ] );Aggregation and Data manipulations on BSON documents If you have not done it yet, start mongo client and connect to the MongoDB database server. Next, process a script file empeProject.js to insert BSON documents into a collection empeProject. Make yourself familiar with the contents of the collection. Use either a method find or a method aggregate ( available in MongoDB to write the implementations of the following queries. Implementation of each query is worth 1 mark.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
