BC2402 Designing and Developing Databases – Week 9 Class Exercises, Singapore

Week 9 Class Exercises – Basic noSQL 

Case: Box Office

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