Databases Tools & Techniques Tables

Databases Tools & Techniques Tables

1. Table characteristics

   • Field Types
   • Field Names
   • Field Sizes
     • Byte
     • Integer
     • Long integer
     • Single
     • double
     • Decimal
   • Field Formats
   • Default values
   • Rows = Records
   • Columns = Fields

2. Validation

   • Examples
     • Check Digit
       • The last one or two digits in a code are used to check the other digits are correct
     • Length Check
     • Format Check
     • Lookup table
     • Presence Check
     • Range Check
     • Spell check
   • Validation is an automatic computer check to ensure that the data entered is sensible and reasonable. It does not check the accuracy of data.

3. Indexing

   • ________Key
   • _________ Key

4. Records

   • Edit
   • Delete
   • Add
     • Manually
     • External source
       • Spreadsheet

5. Relationships

   • One to many
   • One to one
   • Many to many