databases - tools and techniques

databases - tools and techniques

1. table characteristics

   • rows and colums
     • columns=fields
     • rows=records
   • numeric
     • numbers
     • currency
     • dates
     • time
   • field type
     • alphabetic
       • text
       • memo
   • field types
     • size
     • formats

2. validation

   • check for erros
   • correct format
   • postcode
     • input mask
     • correct field size
     • correct data type.
   • examples
     • check digit
       • the last one or two digits in a code used to correct other digits.
     • format check
     • length check
     • range check
     • presence check
     • spell check

3. records

   • add
     • external source
       • spreadsheet
     • manually
   • edit
   • delete

4. indexing

   • primary key
   • foreign key

5. relationships

   • one to one
   • many to many
   • one to many