DBMS

Tables in second normal form (2NF)

• Eliminate all hidden dependencies

• Eliminate the possibility of a insertion anomalies

• Have a composite key

• Have all non key fields depend on the whole primary key

Which-one ofthe following statements about normal forms is FALSE?

• BCNF is stricter than 3 NF

• Lossless, dependency -preserving decomposition into 3 NF is always possible

• Loss less, dependency – preserving decomposition into BCNF is always possible

• Any relation with two attributes is BCNF