Secure Data Base

Secure Data Base

1. Coding

   • SQL
     • Allows users to peform tasks such as querying data, updating records and managing ddatabase structures
     • We are going to create the databse for the recipies and customers using Sql
   • Python
     • Used for ceaser cipher and is used for hashing passwords
     • It is used for a variety of applications including some like web development, data analysis, artificial intelligence and more

2. Prescribed Criteria

   • You must use 4 different data types in your table
     • Create a data base for the user which works
     • At least 4 different types of data
     • Create a table for the phone numbers so we can later text them
     • All 4 data types must be in the data dictionary.
   • You must have 1 column that uses Hashing to securely store that information
     • The table must enquire that one column that maintains the names of customers
     • These names must be hashed, and not stored in its original form
   • You must have 1 column that uses Caesar Cipher to store secret information
     • Caesar Cipher will be used to encrypt this information which can be retrieved later onwards. Caesar Cipher must be greater than 0
   • Your database must have at least 5 records
     • The table must contain records relating to the user requirements The table requires 5 records Each of the records must be unique

3. Self-Determined Criteria

   • Does the database successfully relate to including the phone numbers of customers
   • Did the table successfully include the phone numbers of the users
   • Were the phone numbers easy to find and was the numbers clear for further contact

4. Security Manager

   • Hashing
   • Salt
   • Ceaser Cipher

5. User persona data requirements

   • Jhon is an aspiring chef and a restaurant owner who wants to share his best recipes with his fans that want to try his amazing food. He needs someone to create an online database where people can access the recipes to all of his best creations and buy the ingredients to make a direct replica of his famous dishes

6. Data Types

   • VARCHAR
     • Variable character
       • Constraints Not NULL
   • DATE
     • The date
       • Constraints N/A
   • FLOAT
     • A number that has a decimal point
       • Constraints autoincremints
   • INTEGER
     • Whole number
       • Constraints autoincremints
   • TIME
     • Referring to the time
       • Constraints N/A
   • BOOLEAN
     • Representation of one of two possible outcomes
       • Constraints Not NULL

7. Suggested data dictionary attributes

   • Date_arrived
     • Data type-VARCHAR
       • N/A
   • Time_of_arrival
     • Data type-TIME
       • N/A
   • Ingredients
     • Data type-VARCHAR
       • 255
   • Money_spent
     • Data type-FLOAT
       • 255
   • Shifted_last_name
     • Data type-VARCHAR
       • 255
   • Phone_number
     • Data type-INTEGER
       • 25
   • Hashed_first_name
     • Data type-VARCHAR
       • 255
   • Recipe_name
     • Data type-VARCHAR
       • 255

8. Sample Data

   • Recipe_name
     • Steak
   • Hashed_first_name
     • Noel before getting hashed
   • Phone_number
     • 0406155747
   • Shifted_last_name
     • Manu(before getting shifted
   • Money_spent
     • 67
   • Ingredients
     • Meat, Butter, Rub
   • Time_of_arrival
     • 10.24
   • Date_arrived
     • 10/09/25