Understanding Validation Rules

Front

What is a validation rule?

Back

A rule in a database that restricts the type of data that can be entered in a field.

Front

Why do we need validation rules?

Back

To ensure data integrity by preventing invalid or unreasonable data entries.

Front

What is a presence check?

Back

A validation rule that requires data to be entered in a field, ensuring it is not left blank.

Front

What does a range check do?

Back

It ensures the entered data falls within a specified range, e.g., between 1 and 100.

Front

How does a length check validate data?

Back

By ensuring the data entered does not exceed a specified number of characters.

Front

What is a value lookup?

Back

A validation rule that restricts data entries to a list of predefined acceptable values.

Front

What is an input mask?

Back

A template that dictates the format in which data must be entered, e.g., a phone number.

Front

What does a not NULL validation ensure?

Back

It ensures a field is not left empty, requiring some form of data to be entered.

Front

Tickets Booked

Back

Please enter a number less than 6

Front

Age

Back

Birth date cannot be in the future