Elementary key normal form
The template {{Wikify}} has been deprecated since 25 August 2012, and is retained only for old revisions. If this page is a current revision, please remove the template.
 | Template:Wikify is deprecated. Please use a more specific cleanup template as listed in the documentation. |
 | This article contains no links to other Wikipedia articles. (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.
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
 | This article has not been added to any content categories. Please help out by adding categories to it so that it can be listed with similar articles. (November 2012) |