Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Integrity-Related Terms

Field Specification

A field specification (traditionally known as a domain) represents all the elements of a field. Each field specification incorporates three types of elements: general, physical, and logical.

• General elements constitute the most fundamental information about the field and include items such as Field Name, Description, and Parent Table.

• Physical elements determine how a field is built and how it is represented to the person using it. This category includes items such as Data Type, Length, and Display Format.

• Logical elements describe the values stored in a field and include items such as Required Value, Range of Values, and Default Value.

You'll learn all of the elements associated with ...