Choose the correct answerA relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.OptionsBCNF3NF2NF1NF

The correct answer is BCNF. A relation is in Boyce-Codd Normal Form (BCNF) if an attribute of a composite key is dependent on an attribute of another composite key.

A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.

To determine the correct answer, we need to understand the different normal forms in database design.

1. 1NF (First Normal Form): In 1NF, the relation should have a primary key, and each attribute should contain only atomic values. This means that composite keys are not allowed in 1NF.

2. 2NF (Second Normal Form): In 2NF, the relation should be in 1NF, and all non-key attributes should be fully dependent on the entire primary key. This means that no partial dependencies should exist.

3. 3NF (Third Normal Form): In 3NF, the relation should be in 2NF, and there should be no transitive dependencies. This means that no non-key attribute should be dependent on another non-key attribute.

4. BCNF (Boyce-Codd Normal Form): BCNF is a stricter form of 3NF. In BCNF, the relation should be in 3NF, and every determinant (attribute that determines another attribute) should be a candidate key.

Based on the given options, the correct answer is BCNF. BCNF ensures that all dependencies are fully satisfied and no partial or transitive dependencies exist.