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.
Identify the redundant functional dependency in F
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. A → D
Explanation
A → D is implied by A → BC and BC → D.
More Database Management Systems questions
- 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?
- With respect to relational algebra, which of the following operations are included for mathematical set theory? (a) Join (b) Intersection (…
- In relational databases, if relation is in , then which of the following is true about relation R ?
- Which of the following key constraints is required for functioning of foreign key in the context of relational databases?