0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

候補キー(Candidate Key)

Posted at

AP試験学習記録27年秋 午前28

関係R(A,B,C,D,E,F)において,次の関数従属が成立するとき,候補キーとなるのはどれか。

〔関数従属〕
A→B,A→F,B→C,C→D,{B,C}→E,{C,F}→A

image.png

1、
候補キー(Candidate Key)は、主キーの候補となるキーのことで、表の中の1つのレコードを特定できる性質を持つ属性、または属性の組合せです。

A→Bは、Aから、Bを決定できること。
質問には、その属性がすべての他の属性を決定できるかのこと。

C,F→A→B、F
B→C→D

B,F→A、C、D、E

なのでmB,Fが候補キーでいいです。

参照:
https://www.ap-siken.com/kakomon/27_aki/q28.html

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?