PulseExploreJournal ClubDebatesTrendingResearchersJournals
Instagram
HomeExploreJournal ClubTrending
Synapse
⌘+K
Synapse
September 1, 1977ACM Transactions on Database Systems720 citationsOpen Access

Multivalued dependencies and a new normal form for relational databases

RFRonald Fagin

Key Points

Key points are not available for this paper at this time.

Abstract

A new type of dependency, which includes the well-known functional dependencies as a special case, is defined for relational databases. By using this concept, a new (“fourth”) normal form for relation schemata is defined. This fourth normal form is strictly stronger than Codd's “improved third normal form” (or “Boyce-Codd normal form”). It is shown that every relation schema can be decomposed into a family of relation schemata in fourth normal form without loss of information (that is, the original relation can be obtained from the new relations by taking joins).

Ask AI
Helpful
Bookmark
Share
View Full Paper

Cite This Study

Ronald Fagin (1977) studied this question.

synapsesocial.com/papers/6a11e55d0db2e61b4b8e11a3https://doi.org/10.1145/320557.320571
Ask AI
Helpful
Bookmark
Share
View Full Paper