Database Design Flashcards

1
Q

What are the 6 characteristics of quality data

A

Accurate
Correctness
Current
Complete
Relevant
Consistent

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

What are the 4 types of data validation

A

Format Check
Data type check
Range check
Check digit

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

What are 3 steps to get to information

A

Have one source of truth
Standardise data
Use effective names

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

LOOK AT ERD STUFF

A

*

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