Databases

Databases

1. Definition

   • A collection of data
   • Held together in an organised way

2. Data types

   • Integer(number)
   • Real(number)
   • String(text)
   • Date/time
   • currency

3. Tables

   • Record consists of related fields. Otherwise known as a row
   • A field is a single item of data within a record
   • A table is collection of related records
   • A primary key identifies each record

4. Searches

   • Simple query search looks for data in one field
   • Complex query search looks at data within multiple criteria

5. Database validation

   • Range check
   • Type check
   • Length check
   • Look up list
   • Format check
   • Input mask
   • Presence check