Secure Databases

Secure Databases

1. Security Measures

   • Hashing
   • Hashing+SALT
   • Caesar Cypher

2. DATA Types

   • VARCHAR
   • CHAR
   • Integer
   • Primary Key

3. Coding

   • SQL
     • Data Insertion
     • Table Creation
     • Data Alter
     • Data Select
   • Python
     • Hash insert (Table)
     • Hash+SALT insert (Table)
     • Hash/+SALT formation

4. User Persona Requirements

   • Secure/Encrypted Database
   • A database that can store data neatly
   • A database that is easy to see

5. Prescribed Criteria

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

6. Data Dictionary Attributes

   • ID
   • FirstName
   • LastName
   • DOB
   • Card_Type
   • Card_Number