Please enable JavaScript.

Coggle requires JavaScript to display documents.

Video Game Database App - Coggle Diagram

- - - - Utilises database to present accurate pictures of video games spread across multiple consoles.
      - Users can add games from database to represent their own collection.
      - Requires an account.
    - - User can add personal details to games within their list.
      - Utilises database to present accurate pictures of video games spread across multiple consoles.
      - Requires paid subscription.
- - - - App contains easily accessible button that transitions between only two screens. (Learnability, Effectiveness, Accessibility, Safety)
      - Numerous search parameters allow user to speficially find exactly what results they want. (Effectiveness, Utility)
      - The “Video Games Through The Ages” search query shows users via statistics how video games have changed each year without the user having to input their own specific query. (Utility, Effectiveness, Accessibility)
      - Display screen features images of user-selected games displayed on wooden cabinet. (Accessibility, Effectiveness)
      - An addition to the personal collection via the plus button can be undone by selecting the minus button. (Safety, Accessibility, Effectiveness, Learnability)
    - - Display Screen
        
        Initial Boot-Up Screen
        
        Visual representation of game collection
        
        Search button in top right corner transitions to Search Screen
        
        Wooden cabinet background
      - Search Screen
        
        Numerous search terms
        
        Search by name
        
        Search by genre
        
        Search by release date
        
        Search by age rating
        
        Search by global sales
        
        Search by review scores
        
        Special search parameter known as “Video Games Through The Ages”
        
        Displays the most popular game (in terms of global sales) for each year between 1980 and 2020.
        
        Displays box cover, name, genre, release date, age rating, global sales and review score for each available game.
        
        Plus button adds game to collection, becomes a minus button that can undo that addition.
        
        Home button in top right corner transitions to Display Screen
        
        Each game also has a website link that provides further information.
  - - - ign.csv
        
        Strengths
        
        Each game has a "Score Phrase" for easier searching.
        
        Has release dates, with days, months and years for every game.
        
        Has an "Editor's Choice" award for select great games.
        
        Has review scores for every game.
        
        Website link included for additional information.
        
        Limitations
        
        No images for any game.
        
        No description for any game.
        
        No sales data for any game.
        
        No age rating system for any game.
      - vgsales.csv (VGChartz)
        
        Limitations
        
        Review scores and user scores are missing from multiple games.
        
        Year value is in decimal, requires data type conversion.
        
        Status column appears redundant.
        
        No description for any game.
        
        Each game only has one genre.
        
        Strengths
        
        Has images of respective games via URL.
        
        Has detailed statistics on regional sales.
        
        Has ESRB Ratings for most games.
        
        Features official review scores and user scores.
        
        Website link included for additional information.
    - - Name
      - Genre
      - Age Rating
      - Release Date
      - Global Sales
      - Review Score
  - - - Retrieve data from selected database via SQLite3 interface to display filtered results based on user search query.
      - Display images of favourited games based on retrieved data from selected database.
      - Process pre-determined search query “Video Games Through the Ages” via SQLite3 interface.
      - Update database accordingly when user adds game to collection.