GameBox
app
Developer Problem
Client Problem
User inteface
Data
Dataset 1) VideoGame
Dataset 2) VgSales
User Problem
Features
Code
Algorithms
Enviroment
Requirements
screens
Principles
Competitors
The dataset is very old compared to dataset 2, its most recent record is from 2010. For this dataset to be used it should be updated to date
This dataset has very few entries, limited to 1771 entries, this dataset needs to be edited such that it'll have more entries
The dataset has binary values for many game features, ex: third person, isometric
The dataset has no nil values in its table, therefore the dataset may be used for the deemed solution
Contains data about how certain games are sold based on the global market
Has ratings of games from different sources. Ex: Users, critics, Vgchartz company. These values can be used to rate each game and also a survey can be used to change these values.
Dataset has been last modified in 2020, therefore is very reliable because it is upto date, the dataset has over 55 000 entries, allowing many results for various queries.
The dataset includes links to the game website, therefore more info can be given without the direct use of the database
links to images in a file directory is given in this dataset, therefore will allow the UI to be more user friendly as an image will also be used to describe the game
This dataset will have to be normalised as many columns do not adhere to the 1-3 normalisation laws
This dataset can be easily normalised as most columns are already dependent on a primary key, Ex: GameName
Either one of the two datasets will be used as a part of the database for GameBox app
The dataset should be used to refer a game that is similar to the search criteria of the user
Score of the game should be updated when users do surveys based on different games
An algorithm to retrieve records from the database based on search criteria.
Being able to search up Games based on age rating
Should be able to find Games which have a certain user score or higher
An algorithm to update the user score based on surveys undertaken by users
Businesses should be able to find games that are been sold to may users, such that they can buy advertisements on popular games
Sql will be the database coding language, while sqlite3 will be the environment programmed in
The app will be designed for iOS platform therefore will be coded in swift, and built and tested on Xcode
A prototype model will be made on keynote to demonstrate how the app behaves when a user interacts with it
User A: Teenager
User B: Business man
Section 1) Startup
Game finder
App only built for android users, limiting usability for only apple users.
App contains ads, therefore reduces user friendliness as a subscription should be bought
Developers are constantly active and have good tech support, this section of the app we make should also be strong
Gamerlink
Sign in required to initialise the startup
The game categories only fall under 5 categories based on platform, the app to be made has access to data of games from more platforms
Ability to make a profile
Big Fish
Sign in not required
Both website and app available to be used
Provides a child friendly environment to search for games
Would use app to find a game suitable for him and his friends to play
Wouldn't waste time on the app, therefore, requires a user-friendly, fast method to access games
Could use app to gain loyalty points to play subscribed games for free
User C: 10 year old, parent
Needs a child-friendly environment while browsing games
startup page should have a section for 13 and under children where parents should sign in
Age restricted content should be always hidden
Would sign in with a business profile, therefore won't witness any of the interface made for normal users
A separate interface for these types of users, to analyse how games are selling, and an area where businesses can buy ads from the game site
Features like chatting with other gamers wouldn't be provided for business profiles.
Impacts
Economically
Social/Personal
Businesses will have an easier method to analyse selling data from indie games, and can purchase ads
Businesses will not have to spend too much effort to search for new games
Businesses will be exposed to newer community’s as they can purchase ads from newer games
Newer games will be funded as larger company's will have their attention on growing games
Gamers can find newer and fresh game to play
People can collaborate and make new realtionships
Disadvantage wise players can get addicted to this new platform and spend abnormal amounts of time on it
unhealthy relationships can be made
An innovative app that uses game data in a interesting way .
Should allow gamers to find games that suit them based on genre
Sort games based on year published, last update and platform
Allow businesses to analyse selling rates of minor games
Let businesses contact games through private business contacts
Let casual users use the app for free without ads, while businesses pay a monthly subscription for analysed data
Simple screen, shouldn't confuse the user
options between, Business, personal, 13 or under is present
Section 2) Personal page
This screen will be accessed by a personal user.
Content will be filtered according to their age when signing up
A dark theme will be used throughout the section to symbolise "gamerness"
Recommended games will be shown on the top
Search bar on top to search for games, this includes checkboxes for platform, and has advanced settings to choose year.
basic usability features like swiping both horizontal and vertical to increase effectiveness when sorting games will be implemented.
Sign in prompt
Section 3) Business screen
This screen can only be accessed by registered subscribed businesses, they can access the screen through the sign in promt
Includes graphs towards the center of the screen
Popular games and their relevant marketing stats will be shown towards the top of the screen
Section 4) Child friendly section
This section consists of child-friendly content
Explicit content and games will not be shown in this screen
A lighter background will be used to symbolise the chil friendly nature
Games for educational purposes and games with harmless plots will be recommended
The user can swipe left or right to switch between screens, this will increase easiness to move between screens
Checkboxes will be used to take in values when querying for, platform. this will reduce time waste when typing the full name of a platform
All text will be in one font, and base language will be set to english to avoid confusion with users
Consistent themes will used in each section to show how each part is different from the other
The app logo can be changed from settings based on which path selected when signup as this will increase the accessibility of the app as the logo defines the purpose of the app
Constraints
Mobile app
Database should be synced with the cloud, user information should be accessed from any device
Stores data in two main sections, business and personal based on user profile
User information should be stored in a seperate table
iPhone app
Shouldn't waste users time
Support iOS 13 and below
Base-app should rely on the database
Should run on old iPhones, (iPhone 5)