Exclusive Identification

One principle of database design that I'd like to re-emphasize is that a primary key should exclusively identify the value of each field within a given record. Each field value for any particular record should be unique in the database, except where it's used as matching data for establishing a relationship. If the primary key doesn't exclusively identify the field, either it's unnecessary or it belongs in another table.

This is a difficult concept to comprehend. Let's look at the final list of tables and fields in Table 3.26 to see how it applies. Consider the table Programs, where ProgramID is the primary key. Each of the nonkey fields—Name, Location, Synopsis, Notes—is uniquely identified by the primary key. GenreID ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with O’Reilly online learning.

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