Database

Database

1. User

   • Alexis Sunset (gaychi)
     • Brainrot
     • Taiwanese
     • Employed full time fried rice maker
     • Likes anime
   • Frustrations
     • Alex has short term memory loss, meaning he can’t remember his apex login details and account details
   • 14
   • Interests
     • Apex legends
     • Being #1 in everything
   • Occupation
     • Parents restaurant
   • Needs and expectations
     • Complete and secure storage of all apex Accounts, passwords, number, activity and date created.

2. Existing solutions

   • 1password
     • 2016
     • Agile bits inc.
   • Nordpass
     • Creator
       • Nord security group
     • Year
       • 2019
   • Roboform
     • Sibersystem
     • 1999
   • Keeper

3. Task

   • Scaffold
     • Prescribed criteria
       • Database must have at least 20 records
       • Use 4 different data types in table
       • Must have 1 column that uses Caesar cipher to store secret information
     • User persona
       • User PFP
       • Education
       • Goals
       • Needs and expectations
       • Age
       • Occupation
       • Interests
       • Frustrations
       • Location
       • User problem summary
       • Must have 1 column that uses hashing to securely store information
     • Mind map
       • Gonconqr
     • Data dictionary
       • Column name
       • Data type
       • Datatype length
       • Sample data
       • Must include all data types required
     • SQL and code used
       • Must have code comments and annotations
     • Algorithm for Caesar Cipher
     • Desk check
       • Ensures accuracy and reliability
     • User survey
     • Evaluation
     • References
   • Database
     • Account names
     • Password
     • Date created
     • Number
     • Activity

4. Coding tools

   • SQLite3
     • Database facility
     • Year released
       • Y2K
     • Creator
       • D. Richard Hipp
   • Thonny
     • Creator
       • Aivar Annamaa
     • Year released
       • 2023
     • Python coding language