BC2402 Designing and Developing Databases – Week 9 Class Exercises

Pay Someone to Do My Homework

Week 9 Class Exercises – Basic noSQL 

Case: Box Office

Order ready-to-submit essays. No Plagiarism Guarantee!

Note:  All our papers are written from scratch by human writers to ensure authenticity and originality.

Need Help Writing an Essay?

Tell us about your assignment and we will find the best writer for your paper

Write My Essay For Me

Download and import boxoffice.json onto your MongoDB environment.

1. You can import the json file using MongoDB compass

Database Name: boxoffice

Collection Name: moviestarts

2. Click on Add Data. Select “Import JSON or CSV file”

3. Click on ADD DATA, then Import File

4. Specify your file location. Click IMPORT.

5. Click “Import”

Required:

Construct find() statements to generate answers for the following (you are encouraged to utilize NoSQLBooster to develop the scripts)

1. Display the first document
2. Search all movies that have a rating higher than 9.2 and a runtime lower than 100 minutes
3. Search all movies that have a genre of “drama” or “action”.
4. Search all movies that have a genre of “drama” and “action”. You must not use $and.
5. Search all movies where visitors exceeded expected visitors
6. Search all movies that have a title contains the letter “Su”
7. Search all movies that either have a genre of “action” and “thriller” or have a genre of “drama”, and at the same time, have more than 300000 visitors with a rating between 8 and 9.5 (inclusive).

The post BC2402 Designing and Developing Databases – Week 9 Class Exercises appeared first on My Assignment Help SG.

WRITE MY ESSAY FOR ME