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
Temporal Data and the Relational Model
Temporal Data and the Relational Model
Microsoft(R) SQL Server 2005 Unleashed
Microsoft(R) SQL Server 2005 Unleashed
The Relational Database Dictionary: A Comprehensive Glossary of Relational Terms and Concepts, with Illustrative Examples
An introduction to functional independency in relational database normalization
ACM-SE 45 Proceedings of the 45th annual southeast regional conference
Hi-index | 0.00 |
Using vertical decomposition method to normalize relational database has been well illustrated and understood. The purpose of relational decomposition is to remove data redundancy and prevent data anomalies. Up to the Boyce-Codd normal from (BCNF), decompositions are performed based on functional dependency at a relation's attribute level. However, since data redundancies can also appear between attributes that are interrelated in forms other than functional dependency, decomposition method fails to remove some very basic data anomalies. Consequently, we can still observe data anomalies in high level normal forms such as BCNF, 4NF and 5NF. After introducing the data anomalies that may occur in high level normal forms, this paper discusses some practical approaches on how to eliminate or reduce such anomalies in order to improve data integrity.