Mapa mental

Secure Database for Mr Banana

Najair Taseen Digital Technologies Year 9 Inglês

Conteúdo do mapa

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
Data Types
- INT
- VARCHAR
- CHAR
- FLOAT
User Persona Data Requirements
- Information stored in a database has to be encrypted
- The data has to be easy to access
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
Self-determined Criteria
- Have 2 data tables, one for members and one for employees
- To make a login system
Coding
- Python
- SQLite
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
Suggested Data Dictionary Attributes
- Name
- ID
- Email
- Password
- Position
- PIN
- Number of Purchases
- Money Spent
- Time spent being a member (days)