Elementary key normal form
In today's world, Elementary key normal form is a topic that has caught the attention of millions of people around the world. Since its emergence, Elementary key normal form has triggered a series of debates, discussions and reflections that have highlighted the importance and impact it has on our society. Whether on a personal, social, political, economic or cultural level, Elementary key normal form has left its mark in different areas, generating great interest and influence in the way we perceive and relate to the world around us. In this article, we will thoroughly explore the impact and relevance of Elementary key normal form, analyzing its influence on various aspects of our daily lives and providing a complete overview of its meaning and impact today.
 | This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages)
|
Elementary key normal form (EKNF) is a subtle enhancement on third normal form, thus EKNF tables are in 3NF by definition. This happens when there is more than one unique compound key and they overlap. Such cases can cause redundant information in the overlapping column(s).
History
EKNF was defined by Carlo Zaniolo in 1982.[1]
Definition
A table is in EKNF if and only if all its elementary functional dependencies begin at whole keys or end at elementary key attributes. For every full non-trivial functional dependency of the form X→Y, either X is a key or Y is (a part of) an elementary key.[1]
In this definition, an elementary functional dependency is a full functional dependency (a non-trivial functional dependency X → A such that there is no functional dependency X' → A that also holds with X' being a strict subset of X), and an elementary key is a key X for which there exists an attribute A such that X → A is an elementary functional dependency.
Example
 | This section needs expansion. You can help by adding to it. (March 2024) |
For an example of a table whose highest normal form is EKNF, see Boyce–Codd normal form#Achievability of BCNF.
Notes
- ^ a b Zaniolo, Carlo (September 1982). "A New Normal Form for the Design of Relational Database Schemata" (PDF). ACM Transactions on Database Systems. 7 (3): 489–499. doi:10.1145/319732.319749. S2CID 15790238.[page needed]
References
- Halpin, T. A.; Morgan, Antony J.; Morgan, Tony. Information Modeling and Relational Databases.
- Date, C. J. "Elementary key normal form (EKNF)". Database Design and Relational Theory.
- Celko, Joe. SQL for Smarties: Advanced SQL Programming (3rd ed.).