Database Assessment

Database Assessment

1. Task

   • Prescribed Criteria
     • You must use 4 different data types in your table
       • The data types must follow the user’s wants & needs
     • 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
   • Self-Determined Criteria
     • Use a variety of encryption techniques to store data
   • Make a database

2. Coding Options

   • Coding Language
     • SQL
       • UPDATE
       • DELETE
     • Python
       • Def

3. User Requirements

   • Interests
     • Data Security
       • Implemented using techniques like hashing and Caeser's cipher
   • Frustrations
     • When data is stolen

4. Coding Enviroment

   • Thonny
     • Coding Area
       • Colour coded
         • Variables are black
     • Output Area
       • Allows inputs which add themselves into the database
   • SQLite
     • Table
       • Data types
         • email
         • password
         • Id
       • Data Sample

5. Testing Game Logic

   • Desk Checking
   • Algorithm
     • Psuedocode
       • START
       • END