Information Handling (Databases)

Information Handling (Databases)

1. Searching & Sorting

   • =
     • Eg. Town = Newport
       • Lives in Newport
   • <>
     • Eg. Town <> Newport
       • All customers apart from those living in Newport
   • >
     • Eg. Items > 10
       • More than 10 items
   • <
     • Eg. Items < 10
       • Less than 10 items
   • AND
     • Eg. Town = Newport AND Items > 10
       • Lives in Newport and has order with more than 10 items
   • OR
     • Town = Newport OR Items > 10
       • Either orders with more than 10 items or orders from Newport
   • LIKE
     • LIKE Town = New
       • Customers that live in a town beginning with 'New'

2. Validation

   • Lists
   • Range check
   • Format checks

3. Data Types

   • Text
   • Number
   • Currency
   • Date
   • Time
   • Boolean
   • Lists
   • Picture
   • Sound
   • Video

4. Security

   • Password protection
   • Access rights
   • Backup procedures

5. Benefits

   • Faster access to data
   • Variety of output formats
   • Data integrity