Database Flashcards Preview

Computer Science IGCSE > Database > Flashcards

Flashcards in Database Deck (15)
Loading flashcards...
1

database

A persistent collection of data which is held together in an organised or logical way

2

field

A single item of data about a person or thing e.g. name date of birth length

3

record

A set of fields defined to contain information about one thing. e.g. an employee.

4

table

All of the records regarding a set of people or things

5

foreign key

An attribute in one table that is a primary key in another table.

6

data type

Indicates the type of data that can be stored in the field

7

verification

User process of checking that the data entered is accurate

8

Length check

Validation technique. Ensures the exact right amount of characters is entered into a field

9

Range check

Validation technique. Ensures a field is between a certain range of values

10

Format check

Validation technique. A field may required letters and numbers in a certain order

11

Presence check

Validation technique. Requires a field to be completed

12

Lookup table

Validation technique. Only data contained within the lookup table (list) is permitted

13

Double entry

Verification technique. Two users enter the same data it is then compared for accuracy. Errors are re-entered

14

Proofreading

Verification technique. Someone checking the data entered against the original document

15

Query

A database object which enables you to locate multiple records matching specified criteria