Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 1 : Create a new database for a software company ( named SWCompany ) and a new collection ( named Employees ) . Task

Task 1: Create a new database for a software company (named SWCompany) and a new collection (named Employees).Task 2: Attached with this assignment is a text file (named partII) with JSON-formatted data for 20 employees. Each employeedata record is structured as follows: {"_id": ....,"FullName": ....,"Email": ....,"Salary": ....,"Project": the employee can work in one of the following projects Frontend, Cloud_Platform, ServerSide"StartDate": { "month": ...., "year": },"Address": { "street": ..., "city": ...., "state": ....}, "skills": [ array of software-related skills ]} Use Mongodb insert command(s) to add such data records to the collection. You can copy the data records and paste them in the Mongodb command, then run the command. Important note: The data file attached to this assignment to be used in this part is randomly generated.Task 3: develop and run the following queries: Display employees with salaries between 80,000(included) and 100,000(excluded). Display employees who are from Indiana or Illinois, order the results by salary Display employees who have both Python and MongoDB in their skill sets. Display employees who started to work in the Frontend project in 2022

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Why the different requirement for negotiation?

Answered: 1 week ago

Question

When there was controversy, was it clear who had the final say?

Answered: 1 week ago