Name- Ankur Gautam Section: D-(10) University Roll-No: 201500102
Full Stack Assignment
Q1. All Employee’s with the desg as ‘CLERK’ are now called as (AO)
Administrative Officers. Update the Employee collection for this.
Sol. db.Employee.updateMany({ designation: "CLERK" },{ $set: { designation:
"AO" } })
Q2. Change the number of hours for project-1 to 5 for all employees
with designation analyst.
Sol. db.employees.updateMany({ "designation": "analyst" },{ $set: { "project-
1.hours": 5 } })
Q3. Add 2 projects project-3 and project-4 for employee whose name
starts with ”Deep” with 2 hrs
Sol. db.employees.updateMany({ name: { $regex: /^Deep/ } },{ $push: {
projects: { name: "project-3", hours: 2 } } },{ $push: { projects: { name:
"project-4", hours: 2 } } })
Q4. Add bonus rs 2000 for all employees with salary > 50000 and
1500 if salary <50000 and > 30000 otherwise bonus will be 1000
Sol. db.employees.updateMany({}, [{$set: {bonus: {$cond: {if: { $gte:
["$salary", 50000] },then: 2000, else: {$cond: {if: { $gte: ["$salary", 30000]
},then: 1500, else: 1000}}}}}}])
Q5. Change manager name to Tushar for all employees whose
manager is currently “satish” And manager number to 3333
Sol. db.employees.updateMany({ manager: "satish" },{ $set: { manager:
"Tushar", managerNumber: 3333 } })
Q6. Increase salary of all employees from “purchase department” by
15000
Sol. db.employees.updateMany({ department: "purchase department" },{ $inc:
{ salary: 15000 } })
Q7. Decrease number of hrs by 2 for all employees who are working
on project-2
Sol. db.employee.updateMany({ project: "project-2" },{ $inc: { hrs: -2 } })
Q8. Delete project-2 from all employee document if they are working
on the project for 4 hrs.
Sol. db.employees.updateMany( { "projects.projectName": "project-2",
"projects.hoursWorked": 4 },{ $pull: { projects: { projectName: "project-2" } }
})
Q9. Change the salary of employees to 10000 only if their salary is <
10000
Sol. db.employees.updateMany({ salary: { $lt: 10000 } },{ $set: { salary:
10000 } })
Q10. Increase bonus of all employees by 500 if the bonus is <2000 or
their salary is < 20000 or if employee belong to sales department
Sol. db.employee.updateMany({$or: [{ bonus: { $lt: 2000 } },{ salary: { $lt:
20000 } },{ department: "Sales" }]},{ $inc: { bonus: 500 } })
Q11. Add 2 new project at position 2 for all employees with
designation analyst or salary is equal to either 30000 or 33000 or
35000
Sol. db.employees.updateMany({$or: [{ designation: "analyst" },{ salary: { $in:
[30000, 33000, 35000] } }] },{$push: {projects: {$each: [{ name: "New Project
1", position: 2 }, { name: "New Project 2", position: 2 }],$position: 2}}})
Q12. Delete last project of all employees with department name is
“HR” and if the location is Mumbai
Sol. db.collection.updateMany({ department: "HR", location: "Mumbai" },{
$pop: { projects: 1 } })
Q13. Change designation of all employees to senior programmer if
they are working on name:”Project-1” for 4 hrs
Sol. db.collection.updateMany({ name: "Project-1", hours_worked: { $gte: 4 }
},{ $set: { designation: "Senior Programmer" } })
Q14. Add list of hobbies in all employees document whose manager is
Rajan or Revati
Sol. db.employees.updateMany( { $or: [ { manager: "Rajan" }, { manager:
"Revati" } ] }, { $set: { hobbies: [ "hobby1", "hobby2", "hobby3" ] } })
Q15. Add list of skillset in all employee documents who are working
on project-4 for 3 hrs or on project-3 for 4 hrs
Sol. db.employees.updateMany({$or: [{"projects.name": “Project-3”,
"projects.hours": 4},{"projects.name": “Project-4”, "projects.hours":
3}]},{$addToSet: {skills: {$each: ["MongoDB", "AngularJS"]}}})
Q16. Add a new hobby as blogging at 3 position in hobbies array for
all employess whose name starts with R or p and ends with j or s
Sol. db.employees.updateMany({$and: [{ name: { $regex: /^R|^P/ } },{ name: {
$regex: /j$|s$/ } }] }, { $push: { hobbies: { $each: [ "blogging" ], $position: 2 }
} })
Q17. Increase salary by 10000 for all employees who are working on
project-2 or project-3 or project-1 Decrease bonus by 1000 rs And
increase salary by 1000rs for all employees whose department
location is Mumbai
Sol. db.employees.updateMany({ projects: { $in: ["project-1", "project-2",
"project-3"] } },{ $inc: { salary: 10000 } })
db.employees.updateMany({ departmentLocation: "Mumbai" },{ $inc: { bonus:
-1000, salary: 1000 } })
Q18. Remove all employees working on project-1
Sol. db.employees.deleteMany({ “projects.name”: "project-1" })
Q19. Replace document of employee with name “Deepak to some new
document
Sol. db.employees.updateOne({ name: "Deepak" },{$set: {name: "New
Name",age: 25,department: "New Department"}})
Q20. Change skill python to python 3.8 for all employees if python is
there in the skillset
Sol. db.employees.updateMany({ skills: "python" },{ $set: { "skills.$": "python
3.8" } })
Q21. Add 2 skills MongoDb and Perl at the end of skillset array for all
employees who are working at Pune location
Sol. db.employees.updateMany({ location: "Pune" },{ $push: { skillset: {
$each: ["MongoDb", "Perl"] } } })
Q22. Delete first hobby from hobby array for all employees who are
working on project-1 or project-2
Sol. db.employee.updateMany({"projects": {"$elemMatch": {"name": {"$in":
["project-1","project-2"]}}}},{"$pop": {"hobbies": -1}})
Q23. Delete last hobby from hobbies array for all employees who are
working on project which is at 2 nd position in projects array for 4
hrs
Sol. db.collection.updateMAny({projects: { $size: 2 }, "projects.1.hours": 4},{
$pop: { hobbies: 1 } })
Q24. Add 2 new projects at the end of array for all employees whose
skillset contains Perl or python
Sol. db.employees.updateMany({ "skillset": { $in: ["Perl", "Python"] } },{
$push: { "projects": { $each: ["New Project 1", "New Project 2"] } } })
Q25. Change hrs to 6 for project-1 for all employees if they working
on the project-1 for < 6 hrs. otherwise keep the existing value.
Sol. db.employees.updateMany({ "project": "project-1", "hrs": { $lt: 6 } },{
$set: { "hrs": 6 } })
