Question List a minimal set of functional dependencies satisfied by the table T .
Note: FDs are determined from understanding the data items and rules of the enterprise. This is just for practice. |
|
|
⇒ By the Union |
|
B
attribute are the same,D
values are all different, andA↛C
(Rows 1 and 2) and C↛A
(Rows 1 and 3).D
determines all other attributes,
B
, combined with any other attribute P
, still functionally determines only those attributes determined by P
, and
A C
” have distinct values on each row, so
A C → A B C D ⇒ A C → D
T
is
(a) A → B
, (b) C → B
, (c) D → A B C
, (d) A C → D