## A consideration on normal form of not-necessarily-normalized relation in the relational data model (1977)

Citations: | 68 - 0 self |

### BibTeX

@INPROCEEDINGS{Makinouchi77aconsideration,

author = {Akifumi Makinouchi},

title = {A consideration on normal form of not-necessarily-normalized relation in the relational data model},

booktitle = {},

year = {1977},

pages = {447--453}

}

### Years of Citing Articles

### OpenURL

### Abstract

In this paper definitions of unnormalized relation, functional dependency on it and Normal Form are presented. The Normal Form plays a key role in our relational data model in which unnormalized relations are admitted as does the Third Normal Form of Codd in the data model of normalized relation. Properties pertaining to Normal Form are discussed emphasizing comparison with 3NF along with analysis of some typical examples. Similarity and dissimilarity between new functional dependency and Fagin's multivalued depend-ency are also discussed and presented in the form of proposition. 1. INTRODUCTION 2. AN EXTENSION OF F!lNCTIONAL DEPENDENCY Codd proposed a relational model of data in his earlier paper [l] and developed his idea on normali-zation of relational data model in his succeeding oaoers 12 and 41. He defined three tvoes of normal

### Citations

1355 | The Entity-Relationship Model: Toward a Unified View - Chen - 1976 |

506 |
An Introduction to Database Systems
- Date
- 1976
(Show Context)
Citation Context ...orm is considered. Hereafter, we use the term normalized relation instead of 1NF relation, and an unnormalized relation may be normalized to a normalized relation using the procedure given in [12] or =-=[3]-=-. 447 2.1 Definition of relation Mathematically, a relation is defined as follows: Given sets DI, D2, . . . . . . D, (not necessarily distinct), R is a relation on these n sets if it is a set of n-tup... |

150 | The Design and Implemention of INGRES - Stonebraker, Wong, et al. - 1976 |

117 | Multivalued dependencies and a new normal form for relational databases
- Fagin
- 1977
(Show Context)
Citation Context ...ition of functional dependency or an extension of Codd's functional dependency We propose a new definition of functional dependency on a not-necessarily-normalized relation following Fagin's notation =-=[6]-=- with necessary modification * Some constraint on the domain may exclude an specific values. ** Non existence. 448 described below: Let {Ail(i=l, .., m), {Bj}(j=l, . . . . n) be sets of column names o... |

22 | A data base sublanguage founded on the relational calculus - CODD - 1971 |

10 | Relational database management systems - Chamberlin - 1976 |

5 | Unacceptable File Operations in a Relational Database - Heath - 1971 |

5 | Signals and systems - Madisetti, Williams - 1998 |

2 | A Relational Data Base Schema for Describing Complex Pictures with Color and Texture - Kunii, Weyl, et al. - 1974 |

1 |
A Relational Model of Data for Large
- Codd
(Show Context)
Citation Context ...ndency. And 2) a normalized relation does not necessarily mean the same thing as the original unhormalized relation does; in fact, in'N-TRIANGLE, (1,1,2, RED) for example, does mean nonsense, while ({=-=(1,1)-=-,(3,1),(3,3)], 2, RED) means that a triangle determined by the three points is 2 squaremeters in size and its color is red. It is worthwhile to mention that the data contained in U-TRIANGLE can be mai... |

1 | CODASYL Data-Base Shared Data Banks. Management Systems - Taylor, Frank |

1 |
6, Further Normalization of the Data
- No
- 1971
(Show Context)
Citation Context ...ish Only to generalize the concept of 3NF so as to be able to apply it to not-necessarily-normalized relations. May we say that if a relation R is of 3NF then R is of NF? The answer is negative. Codd =-=[2]-=- and others 13, 7 and 81 discussed favorably for 3NF that it can avoid certain storage operation anomalies. Fagin and Others [6, 5, 101 however found that 3NF is not necessarily almighty and suggested... |

1 | An Introduction to Modern - Iyanaga, Kodaira - 1961 |

1 | Analysis and Design of Relational Schemata for Detabase Systems - Zaniols - 1976 |

1 |
Normalized Data Base Structure: A Brief Tutolial
- F
- 1971
(Show Context)
Citation Context ...normal form is considered. Hereafter, we use the term normalized relation instead of 1NF relation, and an unnormalized relation may be normalized to a normalized relation using the procedure given in =-=[12]-=- or [3]. 447 2.1 Definition of relation Mathematically, a relation is defined as follows: Given sets DI, D2, . . . . . . D, (not necessarily distinct), R is a relation on these n sets if it is a set o... |

1 | Research Direction of Database Management System. Intensive lecture - Hammer - 1975 |

1 | An aopreach to Implementing a-geo-data ' system - M, Williams - 1975 |

1 | SYSTEM R: A Relational Approach to Data Base Management - Astraham - 1975 |