Secure database

Secure database

1. Data Dictionary

   • Attributes
     • Username
     • Password
     • Email
     • Creation date
     • USER_id

2. Coding

   • SQL
     • SQL LITE3
   • PYTHON
     • Thonny

3. SQL Data Types

   • INT
   • VARCHAR
   • DATE
   • DATE VARCHAR

4. 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
       • You must have 1 column that uses Caesar Cipher to store secret information
         • Your database must have at least 20 records

5. Self determined Criteria

   • Create a criteria that links to the user problem developed in the User Persona Table

6. Security measure

   • Hashing
   • Caesar Cipher

7. User personal data requirements

   • Username
   • Email
   • Password
   • Service_name
   • User_ID