Databases

Databases

1. Prescribed Criteria

   • • You must use 4 different data types in your table
     • Use the INTEGER data type to store data in the table
     • Use the VARCHAR data type to store data in the table
     • Use the TEXT data type to store data in the table
     • Use the DATE data type to store data in the table
   • • You must have 1 column that uses Hashing to securely store that information
     • The table must have one column of information that uses Hashing.
   • • You must have 1 column that uses Caesar Cipher to store secret information
     • The table must have one column of information that uses Caesar Cipher.
   • • Your database must have at least 5 records
     • The database must have a table with at least 20 records stored in it

2. Security measure

   • Hashing
     • Used on password
   • Hash + Salt
   • Caesar cipher
     • Used on Email

3. User persona data requirements

   • Needs a secure database that can hold all his game account details
   • He should be able to easily access
   • Should be secure from hackers and unwanted people trying to access

4. Data types

   • VARCHAR
     • Used for Username/Password/Email
   • CHAR
     • Used for Game name
   • INT
     • Used for id
   • Date
     • Used to show the last date that the details were updated

5. Coding

   • SQL
     • Used for making and storing in database
   • Python
     • Used to Hash/Hash + Salt information
     • Used to Caesar Cipher information

6. Suggested Data dictionary attributes

   • ID
   • Game
   • Linked_Email
   • Username
   • Password
   • Last_Updated

7. Sample data

   • ID: 1
   • Game: Fortnite
   • Linked_Email: CooperS@gmail.com
   • Username: CoolCooper44
   • Password: Potatoes8356
   • Last_Updated: 2022/06/17

8. Self Determined Criteria

   • The table must have a id column that acts as the PRIMARY KEY and is automatically generated for each row.
     • The id must be automatically generated when the row is created
     • Set id as primary key
   • The table must include a last_updated column that automatically records the current
     • Record the current date when a new row is added
     • Automatically update date when a row is modified