Saving data securely

Saving data securely

1. Criteria

   • Prescribed Criteria
     • You must use 4 different data types in your table
       • Do you have different data types in your table?
       • Do you have at least 4 different data types in your table?
       • Do you have INT, VARCHAR, DATE, TEXT in your table?
     • You must have 1 column that uses Hashing to securely store that information
       • Do you have a column that has only text?
       • Do you have a column that uses hashing to store data?
       • Are all the records in that column hashed?
     • You must have 1 column that uses Caesar Cipher to store secret information
       • Do you have columns that only has text? Other that the hashed one?
       • Do you have a column that uses the Caesar shift?
       • Do you have a specific shift for the text to cipher the text?
     • Your database must have at least 20 records
       • Do you have different data in each column and row?
       • Do you have data in your database?
       • Do you have at least 20 records in your database?
   • Self-determined Criteria
     • Your database must store passwords securely.
       • Do you have passwords stored in your database?
       • Are your passwords hashed securely?
       • Are your passwords ciphered before they are hashed for security?

2. Ideas for data storage

   • Encryption
     • Encryption changes the composition of a message or data so that only people who know how to return it to its original form can read it.
       • Ciphers are encyption methods
         • Caesar Cipher
         • Blowfish
         • symmetric encryption
   • Hashing
     • Hashing is the process of converting data — text, numbers, files, or anything, really — into a fixed-length string of letters and numbers.
       • Most common applications of hashing in cybersecurity
         • Message integrity
         • File integrity
         • Password validation
         • Blockchain and transaction validation
   • Hashing with Salt
     • A salt in hashing is a random piece of data that is added to the input of hash functions to create unique hashes for every input1

3. Resources

   • QLearn
   • Online Websites
     • https://www.codecademy.com/resources/blog/what-is-hashing/
     • https://builtin.com/articles/what-is-hashing
     • https://www.pingidentity.com/en/resources/blog/post/encryption-vs-hashing-vs-salting.html
   • Microsoft Teams
   • Teacher's Feedback
   • Stimulus

4. Assessment

   • User Persona
     • Aria
       • Needs & Expectations
         • Secure way to store passwords and usernames. No ways to leak out. Saved securely perfectly.
       • Fustrations
         • No secure platforms, where I can store all my passwords safely.
       • User Problem Summary
         • Need a secure and trusty platform to save all her usernames, passwords and dates of different websites, as she always forgets them.
   • Task
     • Create a database that provides secure storage for passwords and secret information. Use Caesar Ciphers and Hashing to appropriately store this data in a database.
   • Applications
     • Thonny
       • For Python coding
     • Sqlite 3
       • SQL coding for creating a database