开发者

How to determine candidate keys from record schema and functional dependencies?

开发者 https://www.devze.com 2023-04-08 22:37 出处:网络
If I have a schema say R={A,B,C,D} and functional depen开发者_如何学Cdencies say {B->C, D->A} will my set of candidate keys be {B,D} or {BD}?If B were a candidate key, you\'d have to be able to

If I have a schema say R={A,B,C,D} and functional depen开发者_如何学Cdencies say {B->C, D->A} will my set of candidate keys be {B,D} or {BD}?


If B were a candidate key, you'd have to be able to derive these functional dependencies from the ones given in the problem.

  • {B->A}
  • {B->C}
  • {B->D}

Can you do that?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号