Assignment4_W2024

doc

School

Centennial College *

*We aren’t endorsed by this school

Course

214

Subject

Computer Science

Date

Apr 3, 2024

Type

doc

Pages

Uploaded by SuperHumanBraveryKomodoDragon48

Advanced Database COMP214 Assignment #4 – MongoDb Agregation Due Date: As per dropbox Purpose: The purpose of this assignment is to help you: 1. Become familiar with Mongo DB Agregation Instructions : Be sure to read the following general instructions carefully: This assignment should be completed individually by all the students. Submit your solution through the dropbox. Your submission should include code , the submission must be named according to the following rule: studentID(yourlastname)_Assignment#number.txt . e.g., 300123456( smith)_Assignment#4 .txt Questions [10 marks] Answer Questions 1-4 related using aggregation to Mongodb exercise in Lab Week 11,12 Your files must be in txt script format so that full commands can be run in MongoDB shell (4.2 database) for presenting results. Submit code in in .txt file Marks are and will entirely based only on correct result of code submitted . 1. Find the movies released in the year with the lowest average IMDb rating with different ratings (e.g., 'PG', 'R', 'G') from the 'movies' collection. 2. Write a MongoDB query to find the borough with the highest number of restaurants that have a grade of "B" in Brooklyn. 3. Find the top 10 directors with the most movies from the 'movies' collection in MongoDB in every different ratings (e.g., 'PG', 'R', 'G') from the 'movies' collection. 4. Write a MongoDB query to find the cuisine types that is most likely to receive a "C" or “B” grade. Assignment #4 Page 1 of 1

Discover more documents: Sign up today!

Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

LAB 8 - Partitioning and Cloning Storage Devices.doc

LAB 9 - RAID.docx

M1 Instructions.pdf

Lab 2-8.docx

SCS 100 Module One Activity-Deanna Kennedy.docx

SCS 100 Module Three Activity - Deanna Kennedy.docx

Exam 3 Review Questions.doc

SCS 100 - Module two Activity - Deanna Kennedy.docx

CIS 241- Unit 1 Assignment.docx

GEN499_Wk2Assignment.docx

Packet Tracer - Verify Single-Area OSPFv2 done.docx

Assignment solution sample.pdf

Recommended textbooks for you

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:9781337102124

Author:Diane Zak

Publisher:Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:9780357392676

Author:FREUND, Steven

Publisher:CENGAGE L

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

CMPTR

Computer Science

ISBN:9781337681872

Author:PINARD

Publisher:Cengage

SEE MORE TEXTBOOKS

Recommended textbooks for you

Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage