Database

Database

1. File

   • Organise Records

2. Record

   • Group of Fields

3. Fields

   • Text
   • Numbers
   • Calculated
   • Date/Time
   • Graphic

4. Flat

   • 1 table

5. Relational

   • Linked tables
   • Keys
     • Primary
       • Unique
       • Must have
     • Foreign
       • links tables relationships
   • Avoid Data Duplication

6. Search

   • Complex
     • >1 field
   • Simple

7. Sort

   • Complex
     • >1 field

8. Validation

   • Presence Check
     • field not blank
   • Restricted Check
     • dropdown box
   • Field length
     • size of field
   • Field Range
     • range of numbers