Question: 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

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!