Databasing and security and privacy of data

Databasing and security and privacy of data

1. developing languages

   • Python
     • connect to database
     • hash passwords and encrypt
   • SQL
     • insert into add records.
     • use scheme to view table data.
     • use to develop databases

2. Prescribed criteria

   • You must use 4 different data types in your table
   • You must have 1 column that uses Hashing to securely store that information
   • Your database must have at least 20 records
   • You must have 1 column that uses Caesar Cipher to store secret information

3. self-determined criteria

   • table must have titles for each column

4. Ciphers

   • encrypting
   • decrypting
   • Caeser cipher

5. Ideas for data storage

   • bank accounts
   • sales transactions
   • customers data
   • surveys data
   • employees data
   • users data
   • financial information
   • product information

6. data types

   • char(size)
   • VARCHAR(size)
   • INT(size)
   • DATE

7. Sample data

8. security options

   • hashing
   • cipher
   • Caeser cipher
   • encryption