Chapter 11
Identity
Identity is the property that distinguishes an entity from all others. In concept, an entity has intrinsic identity apart from how the entity may happen to be implemented. Users must be able to find data in a database or the database is compromised.
11.1 Intrinsic Identity
Intrinsic identity is the ability to find data with fields that have meaning. Starting from outside a database, a user specifies real-world fields to find one or more entities and then navigates the database to find the desired data. Intrinsic identity has no bearing on how identity is implemented. Rather intrinsic identity provides a way for logically finding entities when searching a database.
11.1.1 Candidate Keys
Candidate keys provide one aspect of ...
Get Patterns of Data Modeling 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.
