...
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024
Database-Management-System
August 29, 2024

Functional-Dependency

Question 51
Given a relation schema R(ABCDEFGH) in first normal form. For the set of dependencies

F={ A→ B, A→ C, CG→ H, B→ H, G→ F}, which dependency is logically implied?

A
AC→ H
B
C→ H
C
G→ H
D
A→ H
Question 51 Explanation: 
From the dependencies A→ B and B→ H, we can imply A→ H by using transitive dependency
Correct Answer: D
Question 51 Explanation: 
From the dependencies A→ B and B→ H, we can imply A→ H by using transitive dependency

Leave a Reply

Your email address will not be published. Required fields are marked *