Semantic Considerations on Multivalued Dependencies in Relational Databases

概要

論文の詳細を見る
Data dependencies play an essential role in database design. They provide not only integrity constraints but also structural information about data. Among them, multivalued dependencies, as well as functional dependencies, are fundamental. However, the semantic aspects of multivalued dependencies have not been sufficiently investigated. This paper examines multivalued dependencies from the semantic point of view and clarifies the following: (1)The difference between Boyce-Codd normal form and fourth normal form is clarified. (2)It is shown that the real transitivity condition for multivalued dependencies does not hold in a natural sense. (3)It is also shown that a rule which is a mixture of functional and multivalued dependencies has the same problem as the transitivity rule.
一般社団法人情報処理学会の論文
1981-11-05