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().

Aggregation and Data manipulations on BSON documents If you have not doneit yet, start mongo client and connect to the MongoDB database server.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!