Disney Web App

Disney Web App

1. DATA

   • External Data Source
     • Provided Data
       • Movie title
       • Release date
       • Genre
       • Age Rating
       • Domestic total gross
       • Inflation adjusted gross
   • SQL Data base
     • Table 1 (using data from data source)
       • Name: movie_db
         • VARCHAR
           • Title
           • Studio
           • Release month
           • genre
           • age_rating
           • Imagefile
         • INTEGER
           • Release day
           • Release year
           • Rating (out of 5)
           • Domestic box office
           • Global box office
     • Table 2
       • saved_db
         • Userid
           • INTEGER
         • Saved movie title
           • VARCHAR

2. SOLUTION

   • Front-end Interface
     • Categories Page
       • Displays four major studio categories
       • Displays buttons for each genre
     • All Movies Page
       • Display all movies in grid layout
         • Each movie grid contains:
           • Thumbnail image of movie
           • Movie Title
           • Star Rating
           • Age Rating
         • Filtering and Sorting options at top of page
     • Search Page
       • Search Bar
       • Error message if no search results
       • Display search results in grid layout
     • Saved Page
       • Store saved movies in grid layout
         • Button on each movie grid that allows users to remove movie from saved list
   • Developing Environment
     • Python
       • Handles logic and processes
       • links all components in Flask system
     • HTML
       • Create structure for webpage
     • CSS
       • Styling webpage aesthetics
     • SQL
       • Handling Data storage

3. REQUIREMENTS

   • Solution Requirements
     • Use and display data from an external data source
       • Convert external data source to SQL database
     • Incorporate usability to enhance user experience
       • Effectiveness
       • Utility
       • Learnability
       • Safety
       • Accessibility
     • Include effective design elements such as colours and images
       • Dark blue colour scheme
       • Provide images for movie thumbnails
       • Provide an image for a scene from each movie
     • Provide users with filters and sorting options
       • Sort By
         • Highest Rated
         • Alphabetical Order
         • Release Date
       • Filter By
         • Studio
           • Marvel
           • Disney
           • Star Wars
           • Pixar
         • Genre
           • Action
           • Family
           • Musicals
           • Superhero
           • Sci Fi
           • Romance
           • Comedy
           • Fantasy
     • Allow users to enter search requests
       • Provide search bar for text input field
     • Allow users to save movie data
       • Save movie feature
         • Store in separate SQL table for saved movies
       • Remove saved movie feature
         • Delete from saved movie SQL table
   • User Requirements
     • Goals/Needs
       • Easy to find information about Disney movies
       • Aesthetically pleasing interface
       • Easy to read information about Disney Movies
     • Frustrations
       • Lack of up-to-date information on Disney Movies

4. POTENTIAL IMPACTS

   • Personal
     • Positive
       • Fostering Personal Interest
       • Efficiency Convenience
     • Negative
       • Privacy/Data Security Risks
   • Social
     • Positive
       • Increased Inclusivity
     • Negative
       • Social/Peer Pressures associated with a user's opinion on a movies
   • Economic
     • Positive
       • Increased Revenue for Disney
     • Negative
       • Cost of Maintenance