正在加载图片...
例4:已知关系模式R(AB,CD),F={AB→cC→DD→A} 求:蕴含于给定函数的所有非平凡函数依赖; (1)求关系R的所有单属性的闭包 AF+=A, B+=B, CF+= ACD, D+= AD (2)求关系R的所有双属性的闭包; (AB)F+=ABCD,(AC)F+=ACD (AD)F+=AD (BC)F+=ABCD,( Bd)F+=ABCD,(CD)F+=ACD (3)求关系R的所有三属性的闭包 ( ABC)+=ABCD (ABD)F+=ABCD (ACD)F+=ACD,( BCD)+=ABCD (4)求关系R的所有四属性的闭包 (ABCD)F+ EABCD例4:已知关系模式R(A,B,C,D),F={AB→C,C →D,D →A} 求:蕴含于给定函数的所有非平凡函数依赖; (1)求关系R的所有单属性的闭包; AF + = A , BF + = B , CF + = ACD, DF + = AD (2)求关系R的所有双属性的闭包; (AB)F + =ABCD, (AC)F + =ACD, (AD)F + =AD, (BC)F + =ABCD, ( BD )F + =ABCD,(CD)F + =ACD (3)求关系R的所有三属性的闭包; (ABC)F + =ABCD, (ABD )F + =ABCD (ACD)F + =ACD, (BCD)F + =ABCD (4)求关系R的所有四属性的闭包; (ABCD)F + =ABCD
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有