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)
o List only the game titles for all games. o List only the game titles that are free.
o List only the game title and developer name for every game
o List only the distinct names of every developer
o Count the number of games in the collection
o List only the game title and price for games that are less than $4
o List only the game title, release date for the games that were released before 2016
The post ICT704 Non-Relational Database Systems appeared first on My Assignment Online.