作者chot (C-hot)
看板Grad-ProbAsk
标题[理工] 资料库
时间Wed Dec 30 18:14:55 2009
已知关联( relation) T( A, B, C, D, E, F),
其函数相依集( functional dependency set)
F = {B → D, C → A, AD → F},
下列何者为T 之无损分解( lossless decomposition) ?
( A) T1 = {A, B, C, D}, T2 = {A, D, E, F}
( B) T1 = {A, B, C, F}, T2 = {B, C, D, E}
( C) T1 = {A, C, D, F}, T2 = {B, C, E, F}
( D) T1 = {A, D, E, F}, T2 = {B, C, D, F}
请问要怎分解?
我的想法
B->D
C->A 可分为CD->AD
AD->F
CD->AD->F 等於 CD->F
Orz
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 218.172.91.9