FOR FREE MATERIALS

Comparison table of 1NF, 2NF, 3NF, and BCNF: 

Some important point:

# Only BCNF, dependency preserving may or may not maintain, (in case of convert 3NF to BCNF). So, we always prefer 3NF, still, we do not reduce redundancy by 0% but we reduce a lot of redundancy. 

So, prefer the Normal form is 3NF because it maintains all property (lossless, dependency preserving) at also reduces mere redundancy.

# Binary relation should be BCNF, it is 1NF

# If one relation has n attribute

So, how the super key can exist -

Power set of CK = $2^{\mathrm{n}}$ subset and all element of the subset is super key except ɸ.