Databases

Databases

1. Validation methods

   • Range check
     • Length check
       • Checking if the correct number of characters been put in
     • Check digit
       • Barcode checking (extremely carefully checked)
     • Checks numbers within a range
   • Format check
     • Presence check
       • Checking if data is there
     • Checks the characters are valid

2. Data capture forms

   • Should be designed to...
     • Easy to use
     • Not too long
     • logically laid out
     • Clearly shown data
   • Should include...
     • First name/surname
     • Gender
     • Phone number
     • CAPTCHA box
     • Submit

3. Data types

   • Text
     • Numerical
       • Only numbers
     • Letters & numbers
   • Boolean
     • Currency
       • Money
     • Real number
       • Any number including decimals
     • Allows one of two options
   • Date/time
     • Autonumber
       • Unique number
     • Integer
       • Whole number

4. Data