4.1- Intro To Database Flashcards

1
Q

Accuracy

A

Refers to the fact that the data is ‘right’

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

Alternate key

A

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

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

Completeness

A

Refers to how comprehensive data is

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

Correctness

A

Refers to data being logically correct or reasonable

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

Currency

A

Related to how recent or up to date data is

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

Data validation

A

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

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

Database

A

Collection of data or facts regarding specific topic

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

Field

A

Single fact or the smallest unit of data

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

Primary key

A

Field that identifies each record with a unique value

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

Query

A

Extracting information according to specified criteria

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

Record

A

Collection of fields that contains details on a specific entity

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

Relevance

A

Relates to how closely data matches your needs

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

Table

A

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

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