...
Transactions
October 4, 2023
GATE 2000
October 4, 2023
Transactions
October 4, 2023
GATE 2000
October 4, 2023

Normalization

Question 12

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

A
Zero
B
More than zero but less than that of an equivalent 3NF decomposition
C
Proportional to the size of F+
D
Indetermine
Question 12 Explanation: 
If a relation is in BCNF then there is no functional dependencies.
Correct Answer: A
Question 12 Explanation: 
If a relation is in BCNF then there is no functional dependencies.

Leave a Reply

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