Databases

Databases

1. Databases use

   • Defenition
     • A database is a collection of data or information which is held together is an organised or logical way
   • Examples
     • Police records
     • School regester

2. Benefits

   • Easy to edit
   • Fast access: Faster than paper based system
   • reports can be printed
   • Sharing
   • Security: password can be set

3. Database terminology

   • Fields
   • Records
   • Tables
   • Field length
   • Primary key
   • Foreign key
   • Referential integrity

4. Validation-types

   • Validation is and automatic computer check to ensure that the data entered is sensible and reasonable. It does not check the accuracy of the data

5. Verification-types

   • verification -To check that the dataon the original sourcedocument is identical to the data that you have entered into the

6. Database queries and reports

Bilder und Dateien der Mindmap