Preserving Functional Dependencies
- 1 August 1981
- journal article
- Published by Society for Industrial & Applied Mathematics (SIAM) in SIAM Journal on Computing
- Vol. 10 (3), 647-656
- https://doi.org/10.1137/0210048
Abstract
We show that functional dependency preservation can be tested in polynomial time. We show further that while finding a cover for all embedded dependencies is NP-complete, such a cover can be found in polynomial time if dependencies are preserved.Keywords
This publication has 10 references indexed in Scilit:
- Equivalence of Relational Database SchemesSIAM Journal on Computing, 1981
- Adequacy of decompositions of relational databasesJournal of Computer and System Sciences, 1980
- The theory of joins in relational databasesACM Transactions on Database Systems, 1979
- Computational problems related to the design of normal form relational schemasACM Transactions on Database Systems, 1979
- Theory of relations for databases — a tutorial surveyLecture Notes in Computer Science, 1978
- Independent components of relationsACM Transactions on Database Systems, 1977
- Multivalued dependencies and a new normal form for relational databasesACM Transactions on Database Systems, 1977
- Synthesizing third normal form relations from functional dependenciesACM Transactions on Database Systems, 1976
- Reducibility among Combinatorial ProblemsPublished by Springer Nature ,1972
- A relational model of data for large shared data banksCommunications of the ACM, 1970