Secure Database

Secure Database

1. Coding

   • SQL
   • Python

2. Data dictionary

   • Table
     • A collection of rows and columns that stores data in a structured format.
   • Schema
     • Schema is the logical structure of a database, including tables, views, indexes, and relationships
   • SELECT * FROM
     • It specifies all the columns or data that you want from a table it also indicates the table from which the data should be retrieved.
   • Column
     • A column is a single field in a table that is representing an attribute of the data.
   • Primary Key
     • A unique identifier for each record in a table.

3. User personal data requirements

   • Does your database include a DATE datatype
   • Does your database have a VARCHAR datatype
   • Does your database include a CHAR datatype
   • Does your database contain an INT datatype
   • Is there a column in your database that uses hashing
   • Is your database able to securely store the users gaming data
   • Does your database have a column that uses the Caesar Cipher.
   • Does your database have a column that uses the Caesar Cipher.
   • Does your database have a column specifically for Ahmads password
   • Does your database have a column for the data that he purchased his game?
   • Does your database include a column for the games name?

4. SQL Data Types

   • INT
   • CHAR
   • VARCHAR
   • DATE

5. Security Measure

   • Hashing
     • Hashing is a technique used in data structures that efficiently stores and retrieves data in a way that allows for quick access.
   • Ceaser cipher
     • It scrambles the words around and also increases the character with variety of them used
   • Transposition cipher
     • Characters are reordered based on a predefined rule or key.
   • SALT
     • A cryptographic measure

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. Self- Determined criteria

   • Your database must include a variety of columns to securely contain personal information.