Scribd
Upload
111 views

Full Stack Assignment 1

The document contains 25 tasks to update employee data in a MongoDB collection, including changing designations, projects, salaries, bonuses, skills and more. It provides queries to find the relevant employees and update fields like name, department, skills, projects, hours and more. The tasks aim to standardize data, add new fields, increase compensation and make other administrative changes to the employee documents.

Uploaded by

Vidisha singhal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
111 views

Full Stack Assignment 1

The document contains 25 tasks to update employee data in a MongoDB collection, including changing designations, projects, salaries, bonuses, skills and more. It provides queries to find the relevant employees and update fields like name, department, skills, projects, hours and more. The tasks aim to standardize data, add new fields, increase compensation and make other administrative changes to the employee documents.

Uploaded by

Vidisha singhal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

Name - Vidisha Singhal

Section - D (71)

University Roll no – 201500782

Full Stack Using Node Js


Assignment 1

1. All Employee’s with the desg as ‘CLERK’ are now called as (AO)
Administrative Officers. Update the Employee collection for this.

2. Change the number of hours for project-1 to 5 for all employees with
designation analyst.

3. Add 2 projects project-3 and project-4 for employee whose name


starts with ”Deep” with 2 hrs
4. Add bonus rs 2000 for all employees with salary > 50000 and 1500 if
salary <50000 and > 30000 otherwise bonus will be 1000

5. Change manager name to Tushar for all employees whose manager is


currently “satish” And manager number to 3333

6. Increase salary of all employees from “purchase department” by


15000

7. Decrease number of hrs by 2 for all employees who are working on


project-2
8. Delete project-2 from all employee document if they are working on
the project for 4 hrs.

9. Change the salary of employees to 10000 only if their salary is <


10000

10. Increase bonus of all employees by 500 if the bonus is <2000 or


their salary is < 20000 or if employee belong to sales department

11. Add 2 new project at position 2 for all employees with designation
analyst or salary is equal to either 30000 or 33000 or 35000
12. Delete last project of all employees with department name is “HR”
and if the location is Mumbai

13.Change designation of all employees to senior programmer if they


are working on name:”Project-1” for 4 hrs

14.Add list of hobbies in all employees document whose manager is


Rajan or Revati

15.Add list of skillset in all employee documents who are working on


project-4 for 3 hrs or on project-3 for 4 hrs

16.Add a new hobby as blogging at 3 position in hobbies array for all


employees whose name starts with R or p and ends with j or s
17. 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

18. Remove all employees working on project-1

19. Replace document of employee with name “Deepak to some new


document

20. Change skill python to python 3.8 for all employees if python is
there in the skillset
21. Add 2 skills MongoDb and Perl at the end of skillset array for all
employees who are working at Pune location

22. Delete first hobby from hobby array for all employees who are
working on project-1 or project-2

23. 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
Ans
db.EmpDetail.updateMany({ project: { $size: 2 }, "Project-1.Hrs": 4 }, {
$pop: { hobbies: 1 } })

24. Add 2 new projects at the end of array for all employees whose
skillset contains Perl or python
Ans
db.employees.updateMany({ "skillset": { $in: ["Perl", "Python"] } },{ $push: {
"projects": { $each: ["New Project 1", "New Project 2"] } } })
25. 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.

Ans
db.EmpDetail.updateMany({ "project.name": "project-1",
"project.Hrs": { $lt: 6 } }, { $set: { "Hrs": 6 } })

You might also like