The theory of functional and subset dependencies over relational expressions |
| |
Authors: | Marco A Casanova |
| |
Affiliation: | Pontificia Universidade Catolica do RJ, 22453 Rio de Janeiro, RJ, Brazil |
| |
Abstract: | 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 ? 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. |
| |
Keywords: | Formal languages relational expressions functional dependencies |
本文献已被 ScienceDirect 等数据库收录! |