Data validation Flashcards

1
Q

What is data validation?

A

Data validation is checking, carried out by the computer to make sure that input data are within the limits of what a user might reasonably enter.

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

Name 5 types of data validation.

A

Any 5 from: Type check, range check, limit check, length check, character check, format check, presence check, consistency check or check digit.

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

What is consistency check?

A

In a consistency check the software checks that different fields in the same record correspond correctly. For example if ‘Ms’ has been entered into the title field, ‘Female’ must be entered into the gender field.

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

What is presence check?

A

In a presence check, the software checks that essential data items have been entered when the current record is entered or ‘submitted’. For example, when applying for a service on a form on a web page you are usually required to supply certain minimum information, even if some fields remain optional.

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

What is type check?

A

Type check is when the program expects to receive data of a partiular type, it automatically rejects characters or symbols entered that are inconsistent with the type of data. For example, the characters ‘0’ to ‘9’ and ‘.’ will be acceptable for a decimal number, but ‘J’ and ‘#’ will not be.

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

What is range check?

A

In a range check, the software checks that a numerical value is within a particular range of values. For example, the validation rule might be that a number must be greater than zero and less than or equal to 100.

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

What is limit check?

A

A limit check is similar to a range check, but the rule involves only one limit. For example, a number might be limited to being greater than or equal to zero.

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

What is length check?

A

In a length check, the software checks that the number of characters entered in a string is within specified limits. For example, we can use a length check to enforce a minimum of six characters when setting a password.

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

What is character check?

A

In a character check, the software checks that a string of charcaters does not contain invalid characters or symbols. For example, when registering a birth, a parent is likely to be restricted to alphabetic characters for the baby’s registered name.

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

What is format check?

A

In a format check, the software checks that a string of characters has the required pattern or ‘format’. For example, an ID code may be required in the format ‘LLL000000’, meaning three letters followed by six digits.

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

What is check digit?

A

Check digit is an extra digit that is calculated from all the original digits in order to summarise them.

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