ITGS Strand Three: 3.07 Databases

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