Mind Map

Mind Map

1. Prescribed Criteria

   • Contains Student Information
     • Passwords
     • Email
     • School website Username
     • Phone number

2. Prescribed Criteria

   • You must use 4 different data types in your table
     • One data type will be VARBINARY
     • Each data type must be different
     • Use 4 different data types
     • One data type will be VARCHAR
   • You must have at least 1 column that uses Hashing to securely store that information
     • At least one column will be hashed
     • At least one column will contain passwords that will be hashed
     • At least one column will contain passwords that will be hashed
     • Hashing will use harshlib.sha256
   • You must have 1 column that uses Caesar Cipher to store secret information
     • One column will use Caesar Cipher
     • Caesar Cipher will be used to store secret information
     • Address will be stored using Caesar Cipher.
     • Code will contain an if statement that shifts the text but will not affect the numbers.
   • Your database must have at least 20 records
     • My database will contain at least 20 records
     • Each record will be unique
     • Each record will contain different information
     • Each record will have a unique email and unique password

3. Ciphers

   • Charan Chemara
     • Pfslfwtt xy 1
   • Blake Blockison
     • Hthpfytt wi 2
   • Ethan Bong
     • Qnefwi wi 3

4. Ideas For Storage Data

   • Student_Name
   • Email
   • Password
   • Phone_Number
   • Address

5. Data Types

   • CHAR
   • VARCHAR
   • VARBINARY

6. Sample data

   • Hashing
     • hashed_password = hashlib.sha256(password.encode()).hexdigest()
     • hashed_email = hashlib.sha256(email.encode()).hexdigest()
     • Student_Name = input("Enter a Student_Name: ")
     • password = input("Enter a password: ")
     • email = input("Enter a email: ")
   • SQL
     • CREATE TABLE STUDENT_DATA
       • Student_Name CHAR (255) NOT NULL,
       • Email VARCHAR (200) NOT NULL,
       • Password VARCHAR (150) NOT NULL,
       • Phone_Number VARBINARY (200) NOT NULL,
       • Address CHAR (100) NOT NULL
     • INSERT INTO STUDENT_DATA
       • Charan Chemara
         • Charan15@school.com
         • qwerty
         • 510 4501 40
         • Kangaroo st 1
       • Blake Blockison
         • Blake21@school.com
         • password321
         • 549 1285 187
         • Cockatoo rd 2
   • Caesar Cipher
     • shifted_text = "" #break each string into individual characters
     • for char in text: #test if the character is in the alphabet
     • if char.isalpha(): #convert each character to it's unicode number #In unicode, a = 97 so we need to subract the same number
     • char_number = ord(char.lower()) - 97 #Add the shift to the original letter
     • shifted_number = char_number + shift #use modular arithmetic to ensure that we wrap back to a #the % divides by a number and returns the reminder
     • shifted_number = shifted_number % 26 #Now we need to convert back to a letter. Remembering to add the 97 to use unicode characters
     • shifted_char = chr(shifted_number + 97) #now add the character to the encrypted string
     • shifted_text += shifted_char.upper() if char.isupper() else shifted_char else: #If character is not alphabetic, simply add it to the encrypted string shifted_text += char