Data App
Developer Problems
Impacts
Client Problems
User Problems
Constraints
3 Weeks
Mobile app
Competitors
Requirements
User 1 (Reginald and Florence)
User 2 (Yoo-min)
User 3 (Ali)
User Interface
Usability principles
Features
Coding Environment
Key Algorithms
Development tools
Data
Required app data
Data storage and retrieval
Data source options
Retrieve and display movie records based on search criteria
Update movie records to indicate if a movie is on a user’s watch list or not
Display all movies currently on a user’s watch list
Be accessible on mobile devices
Responsive interface that meets the usability and accessibility requirements on the intended user group
An algorithm to retrieve records from the movie database based on search criteria
An algorithm to update the movie database with watch list data
Retired senior citizens
Very social and often get recommendations on what to watch from their friends. Unfortunately remembering these recommendations is often difficult.
Korean immigrant who is fluent in English and Korean
Would love to watch popular Korean movies such as “Train to Busan” but finds that these movies are often not shown in her “recommended for you” list and may get missed. Yoo-min generally likes action movies in any language.
Time poor business executive and movie buff
Is finding that work demands are making it difficult to find time to watch movies
Ali would like to keep a record of “must see” movies to watch when he has time to. Does not want to waste valuable free time watching sub-standard cinema.
movie_metadata.csv
movie.csv
Pros
Cons
Pros
Cons
Key words regarding plot
Home Screen including all recommended movies
Menu sliding from side of screen, can access your watch list, search and categories from this
Watch list includes all movies that the user has elected to watch
Search bar searches for key words to find movies that match
In the menu you can access categories which split the movies into their genre
Increases the views of movies as this app increases the ease of selecting movies without hassle
Does not reduce sales of other movie platforms as it is not a streaming platform
Struggles to produce revenue as there is no direct revenue stream produced from this application
Produces an application that is hardly seen on the current market, which means there is limited competitors
Could easily be sold to a streaming app so they can use the features so their customer base can easily select movies, this makes money for the developer
Shows movie info
When browsing a movie it displays all info such as genre, runtime etc.
Multiple actors for each movie
Multiple genres for each movie
Ordered in chronological order
doesn't display any keywords
Unnecessary data
imbd link and scoring
Language and colour
does not display what language the film is in or the colour
shows the writer
only displays one genre and star for each movie
SQLite database
databases to be created using excel and saved as a .csv which will be used in the SQLite
Keywords
Directors
Actors
General info
all screens are accessible by a drop in menu system (utility)
consistent and simplistic UI design (effectiveness)
inclusive language options through apple settings (accessibility)
all icons are placed logically and consistently (utility/learnability)
accessibility settings will align with the apple accessibility (accessibility)
data storage will be efficiently sized to ensure the app runs smoothly (effectiveness/safety)
SQLite
Sketches for UI
Excel to normalise data
SQLite querying and sub querying to retrieve data for users
inner joins to use data from the multiple tables
Reelgood
Filtering system through genre, type and IMDB score
randomises movie selection
shows the movie name, image, IMDB score, release data, length, genre and bio for the selected movie
PickAMovieForMe
Conducts a survey to select a movie that is good for you
Displays the name and cover of the movie selected for you. Also hyperlinks the trailer and purchase on amazon movies
algorithm to display data based off the search of key words
algorithm to display items that were selected as watch later
Search queries
where query
insert into query
sub query