ICT704 Non-Relational Database Systems

Create a MongoDB database using the data provided to you in the
GameData_Task3.xls spreadsheet. (There should only be one collection).
Insert data from the provided .xlsx file into MongoDB using the insert command.
NOTE: the gameId should be the identifier (_id)
Create the following queries (all output should be easily read): o List all the games in the collection (including all fields)
List only the game titles for all games. o List only the game titles that are free.
List only the game title and developer name for every game
List only the distinct names of every developer
Count the number of games in the collection
List only the game title and price for games that are less than $4
List only the game title, release date for the games that were released before 2016