Database Development

Database Development

1. Impacts

   • Personal
     • Safe data storage platform
   • Economic
     • Innovation
     • Job creation
   • Social
     • Efficiently managed platform to store records

2. User Problem

   • User Persona
     • User Persona 1
       • Wants
         • Platform containing records to store information
       • Needs
         • Easy to use
         • Look nice
       • Details
         • Requires safe platform containing records he can store what subjects to choose for next year
           • Login system for security
       • Name
         • Gray

3. Task Requirements

   • Constraints & Limitations
     • Time
       • 5 hour
     • Coding Environment
       • SQLite3
       • Python
       • HTML
       • CSS
     • Skills
       • Ability to understand basics of Python, HTML, CSS
   • Self Determined Criteria
     • SDC Description
       • SDC Requirement
         • Login system must be secure and safe
       • SDC Requirement
         • CRUD options should be obtainable in the members page
       • SDC Requirement
         • Username, email and password details after signing up should be saved in a database
       • SDC Requirement
         • There should be a logout button after signing in
   • Prescribed Criteria
     • PC1 Description
       • PC1 Requirement
         • CRUD website must be created
       • PC1 Requirement
         • HTML and Python code for CRUD must be created
       • PC1 Requirement
         • Database must be created for storing records
     • PC2 Description
       • PC2 Requirement
         • Flask Web Application must be working
       • PC2 Requirement
         • No errors that cause issues for displaying the required results
       • PC2 Requirement
         • CRUD options should be displayed in the flask web application
     • PC3 Description
       • PC3 Requirement
         • Records must make sense
       • PC3 Requirement
         • Records need to be based on user persona problem
       • PC3 Requirement
         • All records should show up in the read page of the CRUD application
     • PC4 Description
       • PC4 Requirement
         • Lots of CSS (images, background image, fonts, transitions, etc)
       • PC4 Requirement
         • The CSS must be helpful towards the user/user friendly
       • PC4 Requirement
         • The CSS must be good-looking

4. Developer Problem

   • User Interface
     • Features
       • Buttons
     • Usability Principles
       • Effectiveness
         • Easy to use
       • Utility
         • Useful for storing data
       • Accessibility
         • Easy to access your records
       • Learnability
         • Easy to learn
       • Safety
         • Requires login
     • User Interface Components
       • Sign in
       • Sign up
       • Create records
       • Read records
       • Update records
       • Delete records
       • Logout
   • Coding Environment
     • Key Algorithms
       • Login
       • Sign up
       • CRUD
       • Logout
     • Development Tools
       • SQLite3
       • Thonny
       • Visual Studio Code
   • Data
     • Required Data
       • User Database
         • ID
           • Integer
         • Username
           • Text
         • Email
           • Text
         • Password
           • Text
       • Records Database
         • ID
           • Integer
         • Usefulness
           • Text
         • Subject
           • Text
     • Data Storage and Retrival
       • SQL Database
       • Create Table Statement used
       • Login