MadeEasy Test Series: Databases - Database Normalization

Question

#plz check i am right??

Answer 1

1 is not correct BCNF is not the highest normal form , 4NF is also available. so BCNF doesnot remove the entire redundancy

2 is not correct The decompostition BCNF is not always lossless

3 si not correct It is not all of the keys but any one of the candidate keys

4 is not correct the necessary condition to be in 3nf, also is that it should be in 2nf which is not mentioned in the options

correct answer is 0

Comments

2 ,3,4 is false for sure .

for 1 statement  i have a doubt .that redundancy due to functional dependency is zero .but due to MVD WE have redundancy in BCNF ??

---

@kunal so that makes 1 false right

---

yes got now it will be false :)