Information Handling - (Databases)

Information Handling - (Databases)

1. A database is a collection of data or information in a organised and logic way

   • Examples
     • Search engines
     • Police databases

2. Benefits

   • Fast access unlike a paper based syatems
   • Easy to edit
   • Validation settings, checks it's sensible
   • Reports can be printed
   • Security passwords can be set

3. Validation - Types

   • Is an automatic computer check to ensure that the data entered is sensible and reasonable. it does not check the accuracy of data
   • A validation does not check that the data is correct

4. Verification - Types

   • Means to check the data thet you have entered against the original sourse data
   • By entering the data twice this checks if you have made any mistakes

5. Database Queries and Reports

   • Queries with one search are called simple queries
   • Complex queries combine two or more simple searches together by putting AND or OR in the middle

6. Database terminology

   • Table - they allow you to see all of the records stored in the database all at once
   • Rows - the information is stored in a 'row' or 'record'
   • Fields - are the idividual pieces of information

Images and files in the map