Create a database with required tables in an industry standard tool, MongoDB.

Question

Create a database with required tables in an industry standard tool, MongoDB.

Search the database to find answers to specific queries.

Write a report for professional data analyst and submit a document file containing all answers and screenshots via the submission point.

First you create a database and populate the database with data provided to you (see Practical 1 Questions file). You need to write database creation statements in your report.

Then you write statements to perform 3 tasks on your database. These 3 tasks are provided to you (see Practical 1 Questions file). You need to write the query statements in your report and include screenshot of the output after executing the statements to perform those tasks.

Microsoft Word - Practical 1 Questions.docx Database Question (Eateries database to be Created and Populated with the below data) Entries for the Eateries collection follow. { "Name": "La Farina", "Location": "Melbourne", "Cuisine": ["Italian", "Vegetarian"], "Owner": "Jaime Holiber", "Seating": 35, "BYO": "wine", "Style": "café", "Vegetarian options": true, "Vegan options": false } { "Name": "Kool Afriqa", "Location": "Adelaide", "Cuisine": "Kenyan", "Parking": 50, "Owner": "Peter Bowkewz", "Seating": 120, "BYO": "beer", "Style": "restaurant", "Vegetarian options": true, "Vegan options": true } { "Name": "Le Dodo", "Location": "Perth", "Cuisine": "Mauritian", "Parking": 5, "Owner": "Marie l'Ange", "Seating": 50, "Style": "fine-dining", "Vegetarian options": false, "Vegan options": false } { "Name": "Croquant", "Location": "Sydney", "Cuisine": "French", "Parking": "", "Owner": "Jacques le Lapin", "Seating": 15, "Style": "pâtisserie", "Vegetarian options": false, "Vegan options": false } { "Name": "Dough a Dear", "Location": "Melbourne", "Cuisine": "English bakery", "Owner": "George Longbottom", "Seating": 12, "Style": "bakery", "Vegetarian options": true, "Vegan options": true } { "Name": "Pita Peter", "Location": "Melbourne", "Cuisine": "Greek", "Parking": 100, "Owner": "Boutros Akrivos", "Seating": 250, "BYO": "wine", "Style": "restaurant", "Vegetarian options": true, "Vegan options": true } { "Name": "Linke Masche", "Location": "Melbourne", "Cuisine": "German", "Parking": 20, "Owner": "Helmet Kopfschutz", "Seating": 100, "BYO": "wine", "Style": "restaurant", "Vegetarian options": false } { "Name": "Cedar Forest", "Location": "Sydney", "Cuisine": "Lebanese", "Parking": 10, "Owner": "Akalt Aklan Kamilan", "Seating": 85, "BYO": "wine", "Style": "restaurant", "Vegetarian options": true, "Vegan options": true } { "Name": "The Bounding Hart", "Location": "Adelaide", "Cuisine": "British", "Owner": "Seumas Mac an t-Saoir", "Seating": 105, "Style": "bar", "Vegetarian options": true, "Vegan options": true } { "Name": "Pademelon Grove", "Location": "Melbourne", "Cuisine": "Australian", "Parking": 12, "Owner": "Margaret Wilson", "Seating": 75, "Style": "fine-dining", "Vegetarian options": true, "Vegan options": true } { "Name": "Vanilla Cud", "Location": "Sydney", "Cuisine": "Scandinavian", "Owner": "Ingrid Gundersdotter", "Seating": 45, "Style": "parlour", "Vegetarian options": false } { "Name": "Orejas y otras cosas", "Location": "Cartagena", "Cuisine": "Murcian", "Parking": 5, "Owner": "Maria Menor", "Seating": 65, "BYO": "beer", "Style": "restaurant", "Vegetarian options": true, "Vegan options": false } Query Questions to be Answered 1. Find the eateries that are to be found in Adelaide. 2. Find the names of the eateries and their owners, for those that offer Vegetarian food and allow parking for more than twenty vehicles. 3. Find the name and cuisine of each eatery, which is not classed as a restaurant.

tfth-rbqemgea.pdf

Ali Asgar · Accepted Answer

Introduction
MongoDB is a document-based NoSQL database program. MongoDB uses JSON-like documents.
MongoDB like other NoSQL databases differ from traditional SQL database engines like MS SQL, Oracle or MySQL. The primary difference is in the way data is stored in the database repository. In a traditional SQL database, the data is stored in rows and columns arranged as a table in a strict schema that is same for all records in a table. While in a NoSQL database, the data is stored in various ways like a graph, row-column format and document-based model.
MongoDB is a NoSQL database that uses Document-oriented model to store the data. The data for each row of a traditional database is stored as a document in the MongoDB.
The table in MongoDB is called a “Collection”. Each row of a traditional database is called a “Document”. The fields are called “fields” in MongoDB also. The field name is attached with the value in each document and thus instead of a table header in traditional setup, the field names are present in each document. Unlike a row in SQL database, where each row has to be of same length in the memory even if the value for some fields is empty, the document length in MongoDB can vary and thus each document length is only as much as is required.
Database Setup and creation
We have used MongoDB Atlas, a free cloud-based MongoDB engine that can use multiple cloud setups like Azure, GCP or Amazon AWS. We have used AWS for our setup and created a cluster in the one of the free trial tiers available. We then created a Database named “Eateries”.
To connect to the database, we use MongoDB shell, or mongosh,

Create a database with required tables in an industry standard tool, MongoDB. Search the database to find answers to specific queries. Write a report for professional data analyst and submit a...

Answer To: Create a database with required tables in an industry standard tool, MongoDB. Search the database to...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment