Q3-ii

MSQMarks unknown

Indicate which of the following statements are true: A relational database which is in $3$ NF may still have undesirable data redundancy because there may exist:

(A)

Transitive functional dependencies

(B)

Non-trivial functional dependencies involving prime attributes on the right-side.

(C)

Non-trivial functional dependencies involving prime attributes only on the left-side.

(D)

Non-trivial functional dependencies involving only prime attributes.

Loading…