Elements of the Ideal Field

  • It represents a distinct characteristic of the subject of the table.

  • It contains only a single value.

  • It cannot be deconstructed into smaller components.

  • It does not contain a calculated or concatenated value.

  • It is unique within the entire database structure.

  • It retains the majority of its characteristics when it appears in more than one table.

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.