When two 3NF relations are merged to form a single relation:
A)weak entities are created
B)recursive relationships may result
C)transitive dependencies may result
D)IS-A relationships are formed

Question

Quizplus · Accepted Answer

Merging two 3NF relations can result in transitive dependencies, where an attribute in one relation depends on another attribute in the same relation as well as an attribute in the other relation. This violates normalization rules and can lead to data anomalies. Therefore, it is important to carefully examine the resulting relation for transitive dependencies and resolve them through further normalization. The other options of creating weak entities or recursive relationships may occur in specific situations, but they are not as common as transitive dependencies. IS-A relationships are formed through inheritance and are not relevant to merging relations.

When Two 3NF Relations Are Merged to Form a Single