NoSQL Database Exercises
Purpose
This assignment will assess your ability to
1. Compare NoSQL databases to relational databases
2. Conduct basic data operations in MongoDB
Specification
You will set up a simple database in a MongoDB Web Shell, insert some sample data and solve a few
queries.
Task1:
1. Go to this tutorial to study the basic MongoDB CRUD operations:
https://docs.mongodb.com/manual/crud/
2. When you complete the tutorial, click the MongoDB Web Shell to practice the commands.
https://docs.mongodb.com/manual/tutorial/insert-documents/
You can use the MongoDB in Ed to complete the tasks below:
3. When you are connected, use the command line to create a new collection named as comp630.
Include your command and output result in the submission.
4. Write a command to insert the following documents into you comp630 collection. Include your
commands and output result in the submission.
{no:1,name:”ST”,salary:4000,role:”OB”},
{no:2,name:”MSD”,salary:2500,role:”WK”},
{no:3,name:”YS”,salary:3000,role:”ALR”},
{no:4,name:”RD”,salary:2500,role:”MOB”},
{no:5,name:”RS”,salary:4000,role:”OB”},
{no:6,name:”BK”,salary:500,role:”MOB”},
{no:7,name:”VK”,salary:300,role:”BW”},
{no:8,name:”JB”,salary:400,role:”BW”},
{no:9,name:”HP”,salary:2400,role:”ALR”},
{no:10,name:”VS”,salary:3000,role:”OB”}
COMP630
5. Solve the following queries (you may need to learn some of the MongoDB Operators
https://docs.mongodb.com/manual/reference/operator/). You must include the query commands as
text and the result screen shots in your submission.
1.
2.
value
3.
Find all employees whose salary > 2000
Update the salary of the employee whose name is “VK” by adding 1600 to its current
Add a new field phone to document with name “YS” and set phone value as
±42391234 ask 2: Briefly answer the following questions:
1. What are the major differences between MongoDB and relational databases?
2. What type of situation using MongoDB is better than relational databases? Why? Provide an
example of use case to support your argument. You must explain with details.
3. What type of situation using relational databases is better? Why? Provide a particular example
of use case to support your argument. You must explain with details.

Purchase answer to see full
attachment