An introduction to functional independency in relational database normalization

Authors:
Tennyson X. Chen;Sean Shuangquan Liu;Martin D. Meyer;Don Gotterbarn
Affiliations:
RTI International, Research Triangle Park, NC;RTI International, Research Triangle Park, NC;RTI International, Research Triangle Park, NC;East Tennessee State University, Johnson City, TN
Venue:
ACM-SE 45 Proceedings of the 45th annual southeast regional conference
Year:
2007

Citing 6
Cited 1

Database processing (4th ed.): fundamentals, design & implementation

Database processing (4th ed.): fundamentals, design & implementation
An introduction to database systems (7th ed.)

An introduction to database systems (7th ed.)
A normal form for relational databases that is based on domains and keys

ACM Transactions on Database Systems (TODS)
Subset Dependencies and a Completeness Result for a Subclass of Embedded Multivalued Dependencies

Journal of the ACM (JACM)
Principles of Database Systems

Principles of Database Systems
A complete axiomatization for a large class of dependencies in relational datatbases

STOC '80 Proceedings of the twelfth annual ACM symposium on Theory of computing

Implementation considerations for improving data integrity in normalized relational databases

Proceedings of the 47th Annual Southeast Regional Conference

Quantified Score

Hi-index	0.00

Visualization

Abstract

In this paper, we discuss the deficiencies of normal form definitions based on Functional Dependency and introduce a new normal form concept based on Functional Independency. Functional Independency has not been systematically investigated while there is a very strong theoretical foundation for the study of Functional Dependency in relational database normalization. This paper will demonstrate that considering Functional Dependency alone cannot eliminate some common data anomalies and the normalization process can yield better database designs with the addition of Functional Independency.