Elements of the Ideal Table
-
It represents a single subject, which can be an object or event.
-
It has a primary key.
-
It does not contain multipart or multivalued fields.
-
It does not contain calculated fields.
-
It does not contain unnecessary duplicate fields.
-
It contains only an absolute minimum amount of redundant data.
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.
