Compared to BCNF, 3NF is a more restrictive normal form.Question 2Select one:TrueFalse

What is the difference between Boyce-Codd Normal Form (BCNF) and Third Normal Form (3NF)?a.BCNF is more restrictive than 3NFb.BCNF allows fewer update anomalies than 3NFc.BCNF allows more redundancy than 3NFd.BCNF is less restrictive than 3NF

Compared to 3NF, BCNF eliminates more redundancy.Question 3Select one:TrueFalse

What is TRUE about the Third Normal Form (3NF)?a.All of the answerb.Data duplication is reduced by using 3NFc.When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NFd.It helps maintain the integrity of the data

Choose the correct answerWhich one of the following statements about normal forms is FALSE?OptionsLossless, dependency–preserving decomposition into BCNF is always possibleLossless, dependency-preserving decomposition into 3 NF is always possibleBCNF is stricter than 3 NFAny relation with two attributes is BCNF

Choose the incorrect statement:Select one:a.A relation in BCNF must also be in 3NFb.A relation in 3NF must also be in 2NFc.A relation in 3NF must also be in BCNFd.A relation in 2NF must also be in 1NF