Secure Database for Mr Banana

Secure Database for Mr Banana

1. Sample Data

   • Employee
     • ID: 28338
       • Name: Terry_Tomato
         • Email: terryt@hotmail.com
           • Password: terrhatescarrots123
             • Position: Manager
   • Member
     • Name: Cameron_Cherry
       • Email: camcherry@gmail.com
         • PIN: 239029
           • Money Spent (dollars): 293.56
             • Time spent being a member (days): 234

2. Data Types

   • INT
   • VARCHAR
   • CHAR
   • FLOAT

3. User Persona Data Requirements

   • Information stored in a database has to be encrypted
   • The data has to be easy to access

4. Security Measures

   • I will Caesar Cipher everything in the table
   • An additional sha256 hash will be given to more sensitive information like Pins, and passwords
   • A login system has been created

5. Self-determined Criteria

   • Have 2 data tables, one for members and one for employees
   • To make a login system

6. Coding

   • Python
   • SQLite

7. Prescribed Criteria

   • Have at least 4 different data types
   • Have 1 column that uses hashing
   • Have 1 colum that uses caesar ciphering
   • Database must have at least 5 records

8. Suggested Data Dictionary Attributes

   • Name
   • ID
   • Email
   • Password
   • Position
   • PIN
   • Number of Purchases
   • Money Spent
   • Time spent being a member (days)