avatar
请问大侠: superkey# Database - 数据库
w*g
1
suppose that R is given with attributes ( A,B,C,D,E,F) and
the FDs ( A-->BC, B-->E, CD-->EF)
i would like to know, for the superkey at here. why not can
just AD be the superkey. as i found the superkey's
defination : K is a superkey of a relation R iff K+ consists
of all attributes of R, i think ( A, D)+ = ( A,B,C,D, E ,F).
thus why not only the AD can be the superkey and has to plus
B and C.
thank you very much for your help. good day
avatar
m*n
2
AD is the key for the relation. Key is the minimum set of attributes
that FD determines the relation, while superkey is not the minimum set.
so ADC, ADB, ADE, are all superkeys.

【在 w******g 的大作中提到】
: suppose that R is given with attributes ( A,B,C,D,E,F) and
: the FDs ( A-->BC, B-->E, CD-->EF)
: i would like to know, for the superkey at here. why not can
: just AD be the superkey. as i found the superkey's
: defination : K is a superkey of a relation R iff K+ consists
: of all attributes of R, i think ( A, D)+ = ( A,B,C,D, E ,F).
: thus why not only the AD can be the superkey and has to plus
: B and C.
: thank you very much for your help. good day

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。