Please enable JavaScript.

Coggle requires JavaScript to display documents.

GameBank - Coggle Diagram

- - - - Pros
        
        Allows users to sort results by title, release date, price, metascore or date added (ascending or descending)
        
        has filters for platform, genre, number of players, user completion
        
        Has list view or table view for viewing games
        
        Includes image of game without clicking for more information
        
        Includes information for games: monetary value, metascore, game synopsis, in-game screenshots
        
        Has a bar for user completion of game from 0-100%
        
        Has upcoming games with dates
      - Cons
        
        Somewhat unappealing user interface design that doesn't feel as streamlined as others
        
        Does not have age rating information
    - - Pros
        
        Extremely appealing user interface design full of images
        
        Discover page with recommended games under subsections like "popular", "featured", "top rated"
        
        Includes all important information about a game
        
        Has a "related" tab when viewing game information that shows similar games
      - Cons
        
        Lacks personal recommendations
        
        Lacks a filter function in personal collection and search
- - - - video-game.csv
        
        Pros
        
        Games can belong to many genres and so search, filter and sort will be much more precise and specific to user desires
        
        Has used cost of each game
        
        Information on re-release/sequel availability
        
        Information on multiplayer (online and local)
        
        Cons
        
        Doesn't have URL of game
        
        Doesn't have link to image
        
        Only has data for 1771 games
      - vgsales.csv
        
        Cons
        
        Games only have one genre and so filter and search and sort will be less accurate
        
        Many fields missing and so lots of information will be incomplete
        
        Pros
        
        has link to images
        
        Has link to game
        
        Has a catalogue of 55793 games
    - - Title
      - Year released
      - Genre
      - Platform
      - Publisher
      - Rating
      - Image
      - Age rating
      - Global sales
    - - SQLite Database
      - Database uses data from provided vgsales.csv
  - - - Filter and sort search results and personal collection using different criteria (platform, genre, rating etc)
      - Recommended list of games based on preferences
      - Create and name personal collection of games
      - User can rate their own games and use that as a sort/filter criteria
      - Has a "discover" page that shows lists of games based on subtopics like "most popular", "highest rated", "recommended for you"
      - Results are shown in the form of an image with the game title inside, more information can be accessed by tapping the image
      - User can view games similar to the selected one
      - Showcase gaming through the ages by having collections of the best games of a certain era.
    - - Results are shown in the form of an image with the game title inside, more information can be accessed by tapping the image. This allows for a much more aesthetic and modern feel and makes information easier to digest for users (Effectiveness/Learnability)
      - Icons are standard and similar to other apps (Learnability/Effectiveness)
      - Placement of buttons are familiar and similar to other apps (Learnability/Effectiveness)
      - Back button for easy reversibility of actions (Safety/Effectiveness)
      - Consistent and simple dark colour theme to reduce eye strain and for aesthetic purposes (Accessibility, Effectiveness)
      - Menu bar with labelled icons at bottom for easy and fast navigation to key parts of app (Learnability, Effectiveness, Utility)
      - Search function in top right (Learnability, Utility)
      - Ability to change language, font size, image quality (Accessibility)
  - - - Search function
        
        Search function will incorporate filters and sort using the WHERE, AND/OR, LIKE operators
        
        Use wildcard character "%" on either side of inputted search result to ensure users can find games without searching for exact name
        
        For example, if a user wanted to find all call of duty games available on PS3/Xbox 360 the query would be: select Name, image_url from vgsales where Name LIKE '%call of duty%' AND Platform = X360 OR Platform = PS3;
        
        Check if filters are blank or not
      - Creating personal collection
        
        Create a new table with a name chosen by the user, then allow the user to add games to this table
      - Retrieving game information from personal collection
        
        Use inner join to search for names in main table that match up with names in personal collection.
      - Marking a game as completed and adding a personal rating
        
        Create new table with all games in it, and a column for each attribute (completion, personal rating). Update values in the two columns if user adds rating/marks as completed
    - - Xcode IDE
      - Swift