Please enable JavaScript.

Coggle requires JavaScript to display documents.

Data App - Coggle Diagram

- - - - 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)
    - - 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
      - When browsing a movie it displays all info such as genre, runtime etc.
  - - - SQLite querying and sub querying to retrieve data for users
      - inner joins to use data from the multiple tables
      - algorithm to display data based off the search of key words
      - algorithm to display items that were selected as watch later
    - - SQLite
      - Sketches for UI
      - Excel to normalise data
  - - - Keywords
      - Directors
      - Actors
      - General info
    - - SQLite database
      - databases to be created using excel and saved as a .csv which will be used in the SQLite
    - - movie_metadata.csv
        
        Pros
        
        Key words regarding plot
        
        Multiple actors for each movie
        
        Multiple genres for each movie
        
        imbd link and scoring
        
        Language and colour
        
        Cons
        
        Unnecessary data
      - movie.csv
        
        Pros
        
        Ordered in chronological order
        
        shows the writer
        
        Cons
        
        doesn't display any keywords
        
        does not display what language the film is in or the colour
        
        only displays one genre and star for each movie
    - - where query
      - insert into query
      - sub query
- - - - 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
    - - 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