Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Task 1 : Create a new database for a software company ( named SWCompany ) and a new collection ( named Employees ) . Task
Task : Create a new database for a software company named SWCompany and a new collection named EmployeesTask : Attached with this assignment is a text file named partII with JSONformatted data for employees. Each employeedata record is structured as follows: id: "FullName": "Email": "Salary": "Project": the employee can work in one of the following projects Frontend, CloudPlatform, ServerSide"StartDate": "month": "year": "Address": "street": "city": "state": "skills": array of softwarerelated skills Use Mongodb insert commands 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 : develop and run the following queries: Display employees with salaries between included and 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started