Chapter 12. K
key A candidate key, q.v. (unless the context demands otherwise).
key attribute An attribute of a given relvar that's part of at least one key of that relvar. See also subkey.
key constraint A constraint to the effect that a given subset of the heading of a given relvar is a key for that relvar. In Tutorial D, such a constraint is defined by means of a KEY specification within the pertinent relvar definition (see, e.g., the definitions for relvars S, P, and SP in the introduction to this dictionary). Note, however, that while the system will certainly enforce the uniqueness property implied by such a constraintsee candidate keyit can't in general enforce the corresponding irreducibility property as well. In other words, specifying ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access