secure database

secure database

1. prescribed criteria

   • • You must use 4 different data types in your table
     • Implement a hashable password
     • Hash a password
   • • 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
     • Create a database for the user
     • create a table
     • Use at least 4 data types
     • Use 4 different data types
   • • Your database must have at least 5 records

2. self determined criteria

3. coding

   • SQL
     • useful for allowing users to constructs, manage and investigate data from a database
     • will be used to create the database
   • python
     • will be used for Caeser ciphers and hashing

4. security measure

   • hashing
   • salt
   • Ceaser cypher

5. user requirements

6. suggested data dictionary attributes

   • id
     • username
       • name
         • date_of_birth
           • time_started
             • hashed_password
               • secret_info
                 • data type - VARCHAR
                   • word length/format = 255
                 • gender
                   • data type - CHAR
                     • word length/format = 6
               • data type VARCHAR
                 • word length/format = 255
             • data type - TIME
               • word length/format = N/A
           • data type - DATE
             • word length/format = N/A
         • data type - VARCHAR
           • word length/format = 255
       • data type - VARCHAR
         • word length/format = 255
     • data type - INTEGER
       • word length/format = 100

7. data types

   • VARCHAR
     • INTEGER
       • DATE
         • BOOLEAN
           • a form of data with only 2 possible options
         • the day, month, and year of a specific day
       • whole numbers
     • FLOAT
       • TIME
         • the current time
       • a number with a decimal point
     • variable character

8. sample data