That database evaluates your entries based on a set of criteria.

If you slide in your name into a zip code field, the database gives you an error.

That’s because the database tests your entry against the domain defined for the zip code field.

Computer network database

alexsl / Getty Images

A domain is basically a data punch in that can include optional restrictions.

See your database’s documentation for details.

Or, a database designer might choose to define it instead as a character, usually called a CHAR.

What Is Domain Integrity?

For example, the execution statement creates a ZipCode attribute of data jot down CHAR with five characters.

A NULL, or unknown value, is not allowed.

The range of the data must fall between 00000 and 99999.

That creates a ZipCode attribute of data throw in CHAR with five characters.

A NULL, or unknown value, is not allowed.