Digi-Tech Term 3 Assessment

Digi-Tech Term 3 Assessment

1. Prescribed Criteria

   • Your database must have at least 20 records
   • 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

2. Sample Data

   • Baguette Recipe
     • Original
       • Price
         • $3.50
       • Recipe
         • Flour, Eggs, Water, Salt, Yeast
       • Time
         • 00:20:00
     • Buffet
       • Time
         • 00:45:00
       • Price
         • $25.00
       • Recipe
         • Two, Chocolate Baguette, Five scoops of Vanilla Ice-cream, Banana, Caramel Drizzle Sauce, Sprinkles, Fredo Frogs

3. Self-Prescribed Criteria

   • Ideas
     • Must use a minimum of 25 records
     • Insert a new column using Hashing and SALT
     • Recipe must be in order to how it is in SQL column

4. Data Types

   • Text
     • Use for text or combinations, 255 characters maximum
   • CHAR
     • A fixed length string
   • VARCHAR
     • A variable length string
   • Time Stamp
     • Values are stored as the number of seconds
   • Boolean
     • Equal to BOOL (Zero = false, Non-zero = true
   • Integer
     • Allows whole number between -32,768 and 32,767
   • Date Time
     • A date and time combination
   • FLOAT
     • The number of digits after the decimal point

5. Database Context

   • Baguette Store
     • What types of baguettes are ready to be sold
     • How many baguettes are ready to be sold
     • How long does each baguette take to cook

6. Cipher and Hashing

   • Caesar Cipher
     • Easy to decipher
     • Simplest encryption techniques
   • Hashing with SALT
     • Very hard to breach