《kc第讲-关系数据库设计扩展知识》-课件设计(公开).pptVIP

第9讲: (第78章) 关系数据库设计扩展知识  重庆大学计算机学院 分解应注意保持无损连接！ 分解应注意保持函数依赖！ 理想情况是两者同时保持！ BCNF模式的判定方法 To check if a non-trivial dependency ???? causes a violation of BCNF 1) compute ?+ , and 2) verify that ?+ includes all attributes of R (? is a superkey of R). To check if a relation schema R is in BCNF, it suffices to check only the dependencies in the given set F for violation of BCNF, rather than checking F+. If none of the dependencies in F causes a violation of BCNF, then none of the dependencies in F+ will cause a violation of BCNF either. But, using F is incorrect when testing a relatio