All mock tests are FREE till 31 December — register to save your progress
Unit 4 · Database Management Systems Paper 2 CS · December 2019

Directions (Q96–100): An organization maintains a database with five attributes A, B, C, D, E. Consider the universal relation R(A, B, C, D, E) with functional dependency set F = {A → BC, D → E, BC → D, A → D}. All attributes are simple and atomic.

Minimal cover of functional F dependency set is

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: A. F′ = {A → B, A → C, BC → D, D → E}

Explanation

Split A → BC into A → B and A → C. A → D follows from A → BC and BC → D, so drop it.

More Database Management Systems questions