Reference no: EM132481859

CST4070 Individual Assignment

NoSQL databases, formative assignment.

General information

You are required to solve the tasks illustrated below. Each task should be accompanied by:

A short introduction where you describe the problem and your high level solution.

Your step-by-step process supported by your original code. Each block of code needs to be accompanied by a short explanatory text.
Eventually, if necessary, conclude each task with brief summary of what you have done.

As individual submission, you need to export your individual R Notebook (or Python Jupyter Notebook, at your choice) into a PDF file. Your submission needs to be a single PDF file.

Your submission needs to be unique

When solving your tasks, you need to make your submission and comments unique.

Assignment Task

Follow the lab instructions to install MongoDB into your (virtual or local) environment. Once you have MongoDB installed and running, install mongolite library in R or Pymongo library in Python at your choice. Use either R or Python to execute the following tasks:

Part 1. Unzip the file restaurants.zip and extract the content. Import the file into a MongoDB collection called restaurants .

Part 2. Write a MongoDB query to display all the restaurants from the borough .

Part 3. Determine the minimum and the maximum score achieved by any restaurant.

Part 4. Visualise the frequency distribution of the average scores achieved by any restaurant.

Part 5. Select all the restaurants and save them into csv (comma separated value) table. The structure of the table needs to be: name, borough, average_score, where average_score contains the average numerical score of each corresponding restaurant.

Attachment:- formative assignment - FormativeMongoDB.rar