Transactions
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 441 |
Comprehension:
Answer question (96-100) based on the problem statement given below:
An organization needs to maintain database having five attributes A, B, C, D, E. These attributes are functionally dependent on each other for which functionally dependency set F is given as : F: {A→ BC, D → E, BC → D, A →D}. Consider a universal relation R(A, B, C, D, E) with functional dependency set F. Also all attributes are simple and take atomic values only.
→ Identify the redundant functional dependency in F
| BC→D | |
| D→E | |
| A→D | |
| A→BC |
Question 441 Explanation:
A→D is redundant because A can determine D using FD’s A→ BC and BC → D.
Correct Answer: C
Question 441 Explanation:
A→D is redundant because A can determine D using FD’s A→ BC and BC → D.