In Database normalization, I had a question.
In the 3rd Normal form, we remove the transitive dependency, so due to this removal, we remove some of the redundant entries.
My question is why we need BCNF. How re are removing more redundant entries by using BCNF.
please explain this by using an example and compare with 3rd normal form.