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

The correct answer to this question is 2NF (Second Normal Form).

Explanation:

1. Definition of 2NF: A relation is in Second Normal Form (2NF) if it is already in First Normal Form (1NF) and all non-key attributes are fully functionally dependent on the entire primary key. This means that no attribute depends only on a part of a composite key.

2. Composite Key Dependency: If an attribute of a composite key is dependent on an attribute of the other part of the composite key, that violates the principles of 2NF. Thus, for a relation to be considered in 2NF, it should not exhibit any partial dependency on any attribute of the composite key.

In summary, since the question mentions that an attribute of a composite key is dependent on an attribute of another composite key, it aligns with the definition of a relationship not being in 2NF.