Normalization
August 29, 2024Database-Management-System
August 29, 2024HCU PHD CS MAY 2016
| Question 7 |
The condition- “there are no non-trivial functional dependencies of attributes on
anything other than a superset of a candidate key”, is both necessary and sufficient
for a database to be in
anything other than a superset of a candidate key”, is both necessary and sufficient
for a database to be in
| 2nd Normal form | |
| 3rd Normal form | |
| PJNF | |
| BCNF |
Question 7 Explanation:
The condition for the relation to be in BCNF is that the left side of functional dependencies must be super key.
Correct Answer: D
Question 7 Explanation:
The condition for the relation to be in BCNF is that the left side of functional dependencies must be super key.