0ch07-bygyb讲解.pptVIP

Figure 7.16: An Illegal R2 Relation Figure 7.18: Relation of Practice Exercise 7.2 * Hold 成立 * 结束 * 结束 * Design Goals Interestingly, SQL does not provide a direct way of specifying functional dependencies other than superkeys. Can specify FDs using assertions, but they are expensive to test Even if we had a dependency preserving decomposition, using SQL we would not be able to efficiently test a functional dependency whose left hand side is not a key. Multivalued Dependencies (MVDs) Let R be a relation schema and let ? ? R and ? ? R. The multivalued dependency ? ?? ? holds on R if in a