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
- Identify primary key of table with F functional dependency set
- Identify the normal form in which relation R belong to
- Identify the redundant functional dependency in F
- Assume that given table R is decomposed in two tables R (A, B, C) 1 with functional dependency set f = {A → B, A → C} 1 and R (A, D, E) FD…
- Which of the following has same expressive power with regard to relational query language? (a) Relational algebra and domain relational cal…
- Which of the following features is supported in the relational database model?