Database

Database

1. Prescribed Criteria

   • Prescribed Criteria 1
     • You must use 4 different data types in your table
       • To meet this criterion, a VARCHAR value must be used.
       • To meet this criterion, an integer value must be used.
       • To meet this criterion, a float value must be used
       • To meet this criterion, a CHAR value must be used
   • Prescribed Criteria 2
     • You must have 1 column that uses Hashing to securely store that information
       • A python code will be used to apply hashing onto the data that needs encryption
       • A python code will be used to put the encrypted (hashed) data into the desired database and column
       • My database will have a column named ‘player_name’ that stores the encrypted data
   • Prescribed Critiera 3
     • You must have 1 column that uses Caesar Cipher to store secret information
       • A python code will be used to apply a Caesar cipher onto data that needs encryption
       • A python code will be used to put the encrypted data into the desired database and column
       • My database will have a column named ‘height’ that stores the encrypted data
   • Prescribed Criteria 4
     • Your database must include at least 20 records
       • My database will contain at least 20 different records

2. Self Determined Criteria

   • Some data in the database should not be able to be understood for encryption purposes.
     • Caesar Cipher will be used to shift letters so that they cannot be understood (using python)
     • Hashing will be used to randomize letters so that they cannot be understood (using python)

3. Ciphers

   • Caesar cipher
   • Combined Cipher
   • One time pad
   • Ciphertext
   • Transposition
   • Homophonic substitution
   • Vigenere Cipher
   • Monoalphabetic cipher
   • Play fair cipher
   • Four Square Cipher
   • Beaufort Cipher
   • Polygraphic Substitution
   • Railfence Cipher

4. Ideas for data storage

   • Emails
   • Athlete Rankings
   • Passwords
   • Gaming Characters
   • Stocks/Crypto
   • Names
   • Height
   • MVP Winners

5. Data Types

   • CHAR
   • VARCHAR
   • BINARY
   • VARBINARY
   • TINYBLOB
   • TINYTEXT
   • TEXT
   • BLOB
   • MEDIUM TEXT
   • LONGTEXT
   • ENUM
   • BIT
   • TINYINT
   • BOOL
   • BOOLEAN
   • SMALLINT
   • MEDIUMINT
   • DATETIME
   • TIMESTAMP
   • TIME
   • YEAR

6. Sample Data