Entity Identifiers


We can select and join on any candidate key with equally valid results. So why name an identifier?

When the logical model transforms into a physical model, an entity's identifier evolves into a table's primary key.

The DBMS uses primary keys to maintain referential integrity.



Copyright © 1996 Applied Information Science International