Please enable JavaScript.

Coggle requires JavaScript to display documents.

TVBuddy - Coggle Diagram

- - - - Recommends movies based on users' approval of previously watched movies
        
        Most likely keeps tracks of a previously watched movie's genres to continue recommending other movies to users
      - Has multiple watchlists
      - Many types of filters
    - - Kids Section
        
        Filter movies by their Content Ratings
      - Splits content into 'Movies' and 'Series'
        
        Only particularly useful if database includes TV shows
      - Sorts movies into popular franchises (If applicable)
        
        Marvel
        
        Star Wars
        
        Disney
        
        Pixar
  - - - Implement Search Bar (Uses select query)
    - - See 'Features' for relevant information
    - - Implement "Watch Later" button (Set field as Boolean)
      - Update the database if a movie has been selected into the watchlist
    - - Implement "Watch Later" screen (Displays all "Watch Later" movies chosen by the user)
- - - - Shows the movie's Name, Theatrical Poster and Rating on the Home Screen (Prescribed)
      - Search Bar that uses "select" query to search for results (Prescribed)
      - Show the selected movie's: (Prescribed)
        
        Runtime
        
        Genre(s)
        
        Language(s)
        
        Theatrical Poster
        
        Movie Name
        
        Director
        
        Rating out of 10
        
        Content Rating
        
        Year of Release
        
        Country of Release
        
        IMDB Link
      - Filter that uses "select" query to show specific results (Self Determined)
      - Allows users to select movies to "Watch Later" and put them onto a watchlist (Prescribed)
      - A watchlist that allows users to see all the movies they have chosen to "Watch Later" (Prescribed)
      - Allows users to change the order of the matrix shown in the Home Screen
      - Uses a Hamburger Menu to move between Home, Watchlist and Settings Screens (Self Determined)
      - Uses user preferences to recommend movies to them (Prescribed)
    - - Allow the user to choose the order of the grid in the Home Screen (Accessibility)
      - Have 4 screens (Home, Movie Details, Watchlist, Settings) for simplicity (Effectiveness, Utility)
      - No In App Purchases (Safety)
      - Allow users to filter the movies they want to watch (Effectiveness, Utility)
      - Icons used should be from SF symbols to allow users to recognise them better (Effectiveness)
      - Matrix order should be small enough to allow users to clearly identify the theatrical poster (Accessibility, Effectiveness, Safety)
    - - Movie Screen
        
        Entered by tapping on a theatrical poster
      - Watchlist
      - Home Screen
      - Settings
  - - - Search Query to find movies (select query)
      - Choose movies to "Watch Later" using a button (update query)
      - Filter by (Content Rating, Country, Genres, Language, Year) (select query)
      - Show only "Watch Later" movies (select query)
    - - Terminal
      - Language: SQL
      - Excel Spreadsheet
  - - - SQLite3 Database (moviemeta.db) (Digital Data Store)
      - Excel Database (movies.csv or movie_metadata.csv) (Transient Data Store)
    - - Fields (fieldName, datatype)
        
        movie_name, varchar(50)
        
        director_name, varchar(50)
        
        runtime, int
        
        genres, varchar(20)
        
        imdb_link, varchar(255)
        
        language, varchar(20)
        
        country, varchar(20)
        
        content_rating, varchar(5)
        
        year, varchar(4)
        
        imdb_score, float
        
        synopsis, text
      - Primary Keys
        
        movie_name
        
        year
    - - movies.csv
        
        Pros
        
        Less normalisation required due to having less fields and less redundancy
        
        Cons
        
        Does not have all the fields that the developer would prefer to use
      - movie_metadata.csv
        
        Pros
        
        Has more fields that allows for more filtering options for the user
        
        Includes the same fields as movies.csv and has even more
        
        Cons
        
        A lot of unnecessary fields and data that will be deleted during normalisation
- - - - Wants to be able to see more Korean movies (Implement a filter that can sort by country)
    - - Wants some way to save which movies he wants to see (Implement a watch list)
    - - Implement Usability Principles for Elderly and Younger Children
  - - - Require movie ratings (PG-13)