Reference no: EM132424481
ICT704 - Non-Relational Database Systems - University of the Sunshine Coast
Background
World of Words (WoW) is a site which lists top charts of iTunes word games. They have asked you to come up with a database using MongoDB to be able to store the top word game apps to allow viewers to easily search for top word games.
Some game details
• Every game has a unique identifier
• Every game has at least 1 genre identified, but can have up to 4
• Some games support all platforms, while others don't
• Every game has at least 1 language identified, but can have up to 8
• Developer details include ID, Name and URL
• Latest version details are stored, which include Version No, Release date, Notes, and user ratings.
• Games also have an overall rating (which includes the latest version ratings)
• Ratings are out of 5. Comments are not stored.
Part A - Database
• 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
o Return the average price each advisory rating (i.e. 4+ and 12+)
o Return the game titles that do not support the Apple Watch device
o Return the game title and the number of days/months since the latest update
o Return the game title and the file size in MB
• Update the following game:
o Word Warp - A Word Puzzle Game has a new update:
o Version: 3.3.5
o Version notes: Bug fixes and stability improvements
o Release date: 2019-08-16T10:08:56Z
o Avg user rating: 4
o User rating count: 14
o Add a new field called developerCountry to the developer PeopleFun, Inc. and update to US
Part B - Report
For the report you are required to explain the structure of the database you created. You need to describe how the relationships were handled in the database. In your report, discuss potential alternatives to how the relationships could have been modeled and implemented in MongoDB and the benefits/issues of each. Provide recommendations to World of Words for any additional future functionality for the database. You should write approx. 750 words for the report
Specific Instructions
For Part A you are to submit a single plain text file, named
<studentNumber>_mongoDB.txt.
In this file you are to include all the commands for your implementation. For Part B you are to submit a report in a word document or PDF.
Referencing -Harvard
Attachment:- NoSQL Database Assignment.rar
|
Explain the direct impact agencies have had on your life
: Choose three administrative agencies and explain the direct impact these have had on your life. From the e-Activity, Sturm, Ruger & Company, Inc.
|
|
Describe the judicial functions of government
: Assess the effectiveness of the constitutional principle that the legislative, executive, and judicial functions of government should not exist within the same.
|
|
How will issues in the corrections system affect you
: How will issues in the corrections system affect you as a criminal justice professional? What aspects of the corrections system will be most important.
|
|
Identify the legal rights the plaintiff are seeking
: the specific law(s) they used (if the case has been finally decided) or are using (if the case is still in the courts) to support their lawsuit.
|
|
ICT704 Non-Relational Database Systems Assignment
: ICT704 Non-Relational Database Systems Assignment Help and Solution, University of the Sunshine Coast - Assessment Writing Service
|
|
Difference between juvenile justice and adult justice system
: List and discuss at least three similarities and three differences between the juvenile justice and the adult justice systems as presented by the author.
|
|
Describe your plan in working on terrorism related matters
: How would you incorporated technology into policing? What is the appropriate use of technology and what are its goals? How does technology complement human.
|
|
How does the court decision reinforce ethical behavior
: Jasper robs the home of Peter and Carly, two meth dealers. He steals expensive jewelry, meth equipment, and meth. You are the assigned detective to the robbery.
|
|
Status of women in the united states
: Problem: Write a 750 to 1,050- word paper answering the following questions: What has been the status of women in the United States throughout history?
|