WorksheetsITGS Strand Three: 3.07 Databases
Total questions: 12
Worksheet time: 6mins
Combining several databases to build up more information about a person or set of people.
Data matching
Data mining
Data integrity
Data redundancy
Searching collections of data for hidden patterns.
Data matching
Data mining
Data integrity
Data redundancy
Data in a database which is needlessly duplicated.
Data matching
Data mining
Data integrity
Data redundancy
Database which consists of just one table.
Flat File Database
Relational Database
Database Management System
Parameter query
Database containing multiple related tables and no redundant data.
Flat File Database
Relational Database
Database Management System
Parameter query
Method of extracting data from a database that matches specific criteria
Queries
Field
Form
Record
Collection of fields that represent a single entity, such as a person.
Queries
Field
Form
Record
Single item of data about a single record in a database.
Queries
Field
Form
Record
Screen used to input data into a database.
Queries
Field
Form
Record
Process of converting a database from a flat file database to a relational database.
Knowledge discovery
Normalization
Presence check
Privacy policy
Checks to ensure whether data is in the correct format.
Knowledge discovery
Normalization
Validation
Privacy policy
Checking whether data is correct – i.e. is the value entered in a field the actual value?
Knowledge discovery
Normalization
Validation
Verification
