Journal of Computer and System Sciences

Adequacy of decompositions of relational databases

View publication


We consider conditions that have appeared in the literature with the purpose of defining a "good" decomposition of a relation scheme. We show that these notions are equivalent in the case that all constraints in the database are functional dependencies. This result solves an open problem of Rissanen. However, for arbitrary constraints the notions are shown to differ. © 1980.