Databases

Databases

1. Fields, records and files

   • Files and organised collection of records
   • Records, data held on on person
   • Field, one item in a data record

2. Search and sorting

   • Sorting, Arrangeing records in order
   • Search, Selecting records in a database according to ceratain rules
     • Assending/Desending

3. Field Types

   • Text, A string of characters
   • Numeric, stores numbers
   • Date,Stores date
   • Time, Stores time and day
   • Graphics, stores an image
   • Link, stores hyperlink
   • Boolean, two values yes and no
   • Key Field, value that is unique to each record

4. Relationships

   • Keys
     • links tables
     • Primary key
       • Unique
     • Foregin key

5. Flat DB

   • Benefits
     • Personal information