THE THEORY OF FUNCTIONAL AND SUBSET DEPENDENCIES OVER RELATIONAL EXPRESSIONS

A formal system for reasoning about functional dependencies (FDs) and subset dependencies (SDS) defined over relational expressions is described. An FD e: X +Y indicates that Y is functionally dependent on X in the relation denoted by expression e; an SD e c f indicates that the relation denoted by e is a subset of that denoted by f. The system is shown to be sound and complete by resorting to the analytic tableaux method. Applications of the system include the problem of determining if a constraint of a subschema is implied by the constraints of the base schema and the development of database design methodologies similar to normalization