Write a MongoDB query to display all the restaurants from the borough Bronx. Task 3 – Determine the minimum and the maximum score achieved by any restaurant.

GET ALL YOUR ACADEMIC HELP AT ESSAYLINK.NET

NoSQL databases formative assignment –

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

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

2. Your step-by-step process supported by your original code. Each block of code needs to be accompanied by a short explanatory text.

3. 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.

Assessment Tasks – 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:

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

Task 2 – Write a MongoDB query to display all the restaurants from the borough Bronx.

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

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

Task 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.

GET ALL YOUR ACADEMIC HELP AT ESSAYLINK.NET