Gr 11 4.1 – INTRODUCTION TO DATABASES

Question 1

Accuracy

Answer 1

This refers to the fact that the data is ‘right’.

Question 2

Alternate key

Answer 2

A field that identifies each record with a unique value but is
not used as the primary key.

Question 3

Completeness

Answer 3

This refers to how comprehensive the data is.

Question 4

Correctness

Answer 4

This refers to data being ‘logically correct’ or ‘reasonable’.

Question 5

Currency

Answer 5

This relates to how ‘recent’ or up to date the data is.

Question 6

Data validation

Answer 6

Any technique used to reduce the number of errors that can
be made during the input of data.

Question 7

Database

Answer 7

A collection of data or facts regarding a specific topic, e.g
details of a CD collection or details concerning clients.

Question 8

Field

Answer 8

A single fact or the smallest unit of data.

Question 9

Primary key

Answer 9

A field that identifies each record with a unique value.

Question 10

Query

Answer 10

Extracting information according to specified criteria.

Question 11

Record

Answer 11

A collection of fields that contains details on a specific entity.

Question 12

Relevance

Answer 12

This relates to how closely the data matches your needs.

Question 13

dbTable

Answer 13

Grouping related records in a table where each row
represents a record, and each column a field.