GetWiki
Elementary key normal form
ARTICLE SUBJECTS
being →
database →
ethics →
fiction →
history →
internet →
language →
linux →
logic →
method →
news →
policy →
purpose →
religion →
science →
software →
truth →
unix →
wiki →
ARTICLE TYPES
essay →
feed →
help →
system →
wiki →
ARTICLE ORIGINS
critical →
forked →
imported →
original →
Elementary key normal form
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
{{Short description|Enhancement on third normal form when there is more than one unique compound key and they overlap}}{{multiple issues|{{technical|date=December 2012}}{{more footnotes|date=May 2018}}}}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).- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
History
EKNF was defined by Carlo Zaniolo in 1982.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.JOURNAL, A New Normal Form for the Design of Relational Database Schemata, Zaniolo, Carlo,weblink ACM Transactions on Database Systems, 7, 3, September 1982, 489â499, 10.1145/319732.319749, 15790238, {{page needed|date=May 2018}}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
{{Expand section|date=March 2024}}For an example of a table whose highest normal form is EKNF, see BoyceâCodd normal form#Achievability of BCNF.Notes
{{reflist}}References
- BOOK, Information Modeling and Relational Databases, Halpin, T. A., Morgan, Antony J., Morgan, Tony,
- BOOK, Database Design and Relational Theory, Date, C. J., Elementary key normal form (EKNF),
- BOOK, SQL for Smarties: Advanced SQL Programming, 3rd, Celko, Joe,
- content above as imported from Wikipedia
- "Elementary key normal form" does not exist on GetWiki (yet)
- time: 7:13am EDT - Sat, May 18 2024
- "Elementary key normal form" does not exist on GetWiki (yet)
- time: 7:13am EDT - Sat, May 18 2024
[ this remote article is provided by Wikipedia ]
LATEST EDITS [ see all ]
GETWIKI 23 MAY 2022
The Illusion of Choice
Culture
Culture
GETWIKI 09 JUL 2019
Eastern Philosophy
History of Philosophy
History of Philosophy
GETWIKI 09 MAY 2016
GetMeta:About
GetWiki
GetWiki
GETWIKI 18 OCT 2015
M.R.M. Parrott
Biographies
Biographies
GETWIKI 20 AUG 2014
GetMeta:News
GetWiki
GetWiki
© 2024 M.R.M. PARROTT | ALL RIGHTS RESERVED