Database - Input validation

Question 1

Input validation

Answer 1

Checking something to make sure it’s correct and reasonable. - No errors when data it’s added to a database. - Database is more robust (able to cope with errors)

Question 2

Data type

Answer 2

Ensures specific data type e.g. Integer

Question 3

Range check

Answer 3

Input is in acceptable range. e.g. Age - between 0 and 122

Question 4

Null check

Answer 4

Makes sure a database field isn’t left blank

Question 5

Length check

Answer 5

Makes sure input is above/below a length limit. e.g. Minimum length of passwords