See this document in CiteSeerX!

A Corrected 5Nf Definition For Relational Database  (Make Corrections)  
Design Millist W. Vincent Advanced Computing Research Centre, School of...



  Home/Search   Context   Related

 
View or download:
unisa.edu.au/~cismwv/paper...5NFrev.pdf
Cached:  PDF   PS.gz  PS  Image  Update  Help

From:  unisa.edu.au:80/~cismwv/papers... (more)
(Enter author homepages)

Rate this article: (best)
  Comment on this article  
(Enter summary)

Abstract: In this paper, the adequacy of fifth normal form (5NF) in relational database design is investigated. It is shown that 5NF is inadequate because it does not generalise fourth normal form (4NF) and because it is equivalent to the very stringent requirement that every attribute is a key, a requirement that is effectively impossible to satisfy in practical database design. By restricting the join dependencies (JDs) in the set of constraints to those that do not have superfluous components, the... (Update)

Similar documents (at the sentence level):
64.5%:   A Corrected 5NF Definition for Relational Database Design - Vincent (1997)   (Correct)
8.3%:   Redundancy Elimination and a New Normal Form for Relational.. - Vincent (1998)   (Correct)
8.3%:   Redundancy Elimination and a New Normal - Form For Relational   (Correct)

Active bibliography (related documents):   More   All
1.0:   What is the real 5NF? - Vincent (1998)   (Correct)
0.9:   Semantic Foundations of 4NF - Semantic Foundations Of   (Correct)
0.5:   Achievements of Relational Database Schema Design Theory Revisited - Biskup (1998)   (Correct)

Similar documents based on text:
0.0:   Unknown -   (Correct)

BibTeX entry:   (Update)

@misc{ vincent-corrected,
  author = "Design Millist Vincent",
  title = "A Corrected 5nf Definition For Relational Database",
  url = "citeseer.ist.psu.edu/766374.html" }
Citations (may not include all citations):
775   Foundations of Databases (context) - Abiteboul, Hull et al. - 1995
481   Fundamentals of Database Systems (context) - El-Masri, Navathe - 1994
263   Database System Concepts (context) - Korth, Silberschatz - 1991
200   The Theory of Relational Databases (context) - Maier - 1983
64   Testing Implications of Data Dependencies (context) - Maier, Mendelzon et al. - 1979
49   Equivalences among Relational Expressions (context) - Aho, Sagiv et al. - 1979
44   Relational Database Theory (context) - Atzeni, DeAntonellis - 1993
38   Multivalued Dependencies and a New Normal Form for Relationa.. (context) - Fagin - 1977
22   Normal Forms and Relational Database Operators (context) - Fagin - 1979
21   A Normal Form for Relational Databases that is based on Doma.. (context) - Fagin - 1981
19   A Complete Axiomatization for Functional and Multivalued Dep.. (context) - Beeri, Fagin et al. - 1977
9   Semantic Justification of Normal Forms in Relational Databas.. (context) - Vincent - 1994
9   A new redundancy free Normal Form for Relational Databases (context) - Vincent - 1995
8   the Properties of Join Dependencies (context) - Beeri, Vardi - 1981
8   the Complexity of Testing Implications of Functional and Joi.. (context) - Maier, Sagiv et al. - 1981
7   Redundancy and the Justification for Fourth Normal Form in R.. (context) - Vincent, Srinivasan - 1993
6   Update Anomalies and the Justification for 4NF in Relational.. (context) - Vincent, Srinivasan - 1994
5   Theory of Joins for Relational Databases - A Tutorial Survey (context) - Rissanen - 1979
4   Database Scheme Design Theory: Achievements and Challenges (context) - Biskup - 1995
3   A Note on Relation Schemes which are in 3NF but not in BCNF (context) - Vincent, Srinivasan - 1994
3   Australian Computer Science Communications (context) - Orlowska, Zhang et al. - 1992
2   Join Dependencies in Relational-Database Design (context) - Gorchinskaya - 1989
2   A new redunancy free normal form for relational databases - .. (context) - Vincent - 1994

Documents on the same site (http://www.cis.unisa.edu.au:80/~cismwv/papers/):   More
A New Characterisation Of Information Capacity Equivalence In.. - Vincent   (Correct)
A Corrected 5NF Definition for Relational Database Design - Vincent (1997)   (Correct)
Restructuring Partitioned Normal Form Relations Without.. - Vincent (1997)   (Correct)

Online articles have much greater impact   More about CiteSeer.IST   Add search form to your site   Submit documents   Feedback  

CiteSeer.IST - Copyright Penn State and NEC