Secure database

Secure database

1. Data Dictionary

   • Elements to access database
   • Format of Data
   • Structure of database

2. Coding

   • Python
   • Java Script
   • SQL
   • Script
   • Pseudocode
   • VARCHAR
   • INT
   • Variants

3. SQL types

   • INT (Integer)
   • Binary
   • Decimal
   • Numerics
   • Time/Date
     • DD/MM/YY

4. User Persona Data Requirements

   • Needs/Expectations
     • James Expects to receive a secure database to help protect his passwords
   • Education
     • Year 9
   • Interests and Occupation
     • coding and Gaming
   • Age
     • 14 years old
   • Name
     • James Parry
   • Frustrations
   • User Problem Summary
   • Goals
   • User Problem Summary
     • The problem of James’s passwords being leaked out into the internet can be solved by creating a secure and safe database to protect any personal information from being leaked out.

5. Self Determined Criteria

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

6. 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

7. Security Measure

   • HASHING
   • SALT
     • TEXTS
     • NUMBERS
     • SYMBOLS
     • RANDOM