Database Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

database

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

field

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

record

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

table

A

All of the records regarding a set of people or things

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

foreign key

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

data type

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

verification

A

User process of checking that the data entered is accurate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Length check

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Range check

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Format check

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Presence check

A

Validation technique. Requires a field to be completed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Lookup table

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Double entry

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Proofreading

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Query

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly