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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
