Digitech Assessment Term 3

Digitech Assessment Term 3

1. Task requirements

   • 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 20 records
   • Self-determined criteria
     • 1
       • Ensure there is equal to or more than 4 columns
     • 2
       • Must use Thonny to encrypt the hashed passwords and insert them in sqlite

2. Program software

   • Sqlite
     • Code sentences
       • Create table
         • Creates a new table to insert data into
       • Insert values
         • Used to insert data into tables and columns
       • SELECT*FROM
         • Selects a certain part of the table for the viewer to read
       • Time Stamp
         • Creates a timestamp of when the data was inserted into the table
       • VARCHAR
         • Sets the word limit for rows and columns inside table
       • Not Null
         • Doesn't allow the user to not enter anything in the column when displaying apart of the table
       • Unique not null
         • Used to make sure any attempt to enter the same information
   • Thonny
     • Code sentences
       • Start
       • Break
       • End
       • def
       • return
       • If and else
       • for and in
       • input

3. User persona

   • What they're looking for
     • Needs a secure database for storing the books he has read
   • Frustrations
     • Many databases aren’t numbered and other people online find out the books he read and would rather keep his books unknown.
     • they are not time stamped to know when he finished reading them.
   • Wants
     • A secure database to store books
     • the books in the database needs to be encrypted

4. Ideas for data storage

   • Create a table
     • VARCHAR
       • Sets the word limit for the amount of words you can use
     • UNIQUE NOT NULL
       • Makes it so you cant enter the same thing twice in the one column
     • NOT NULL
       • Doesn't allow you to leave this blank when using select from
     • PRIMARY KEY
       • Is used for the database to distinguish between rows
     • Timestamp
       • Used to know when you inserted something into the table
   • Hashing passwords
   • Use one table for both
     • Non-fiction column
       • If non-fiction then yes
     • Fiction column
       • If is fiction then yes

5. Ciphers

   • Caesars Ciphers
     • Randomises numbers by changing each letter by 1-26 paces
       • Type of encryption