Information Handling

Information Handling

1. Validation

   • An automatic computer check that ensures the data is sensible and reasonable
   • However it does not check the accuracy of the data
   • Types
     • Range check
       • Allows you to set suitable boundaries
     • Type check
       • Ensures the correct type of data is entered into that field
     • Length check
       • Ensures the right amount of characters are entered into that field

2. Benefits

   • Fast access
   • Easy to edit
   • Reports can be printed
   • Easy to share

3. What can databases do?

   • Add,change or delete data
   • Search data
   • Sort the data
   • Print reports
   • Use the data in other applications

4. Verification

   • Check data against its original source
   • Entering the data twice
   • Proof reading

5. Examples

   • School register
   • Police records
   • Search engine

6. A database is an organised way of storing data

7. Terminology

   • Table
     • Stores all of the records for a certain catagory
   • Records
     • All of the information/data about one person/thing
   • Fields
     • One peice of information about a person or a thing

8. Key field

Images and files in the map