Elementary key normal form
 | This article includes a list of references, related reading, or external links, but its sources remain unclear because it lacks inline citations. (December 2012) |
 | This article may be too technical for most readers to understand. (December 2012) |
 | This article needs more links to other articles to help integrate it into the encyclopedia. (November 2012) |
Elementary Key Normal Form (EKNF) is a subtle enhancement on 3NF. By definition, EKNF tables are also in third normal form (3NF). This happens when there is more than one unique composite key and they overlap. Such cases can cause redundant information in the overlapping column(s).
A table is in Elementary Key Normal Form (EKNF), if and only if, all its elementary FDs begin at whole keys or end at elementary key attributes.
For every full nontrivial FD of the form X→Y, either X is a key or Y is (part of) an elementary key.
See also
- database normalization
- First Normal Form
- Second Normal Form)
- Third Normal Form)
- Boyce–Codd Normal Form
- Canonical form
Notes and references
- Joe Celko’s SQL for Smarties: Advanced SQL Programming, Third Edition
- A New Normal Form for the Design of Relational Database Schemata by CARLO ZANIOLO - Sperry Research Center[1]
- Information Modeling and Relational Databases By T. A. Halpin, Antony J. Morgan, Tony Morgan