Database Basics for Grade 8

Front

Field

Back

Data about one aspect of a record

Front

Format Check

Back

Validation: DD/MM/YYYY

Front

Length Check

Back

Validation: <50 characters

Front

Presence Check

Back

Validation: NOT NULL

Front

Null

Back

Unknown or missing data

Front

Data Accuracy

Back

Ensures correct search results

Front

Validation

Back

Checks data correctness

Front

Range Check

Back

Validation: >0 AND <20

Front

Data Format

Back

Structure of data in a field

Front

Primary Key

Back

Unique entry for each record