Suppose you have a table with a primary key composed of two columns. When another column in this table is dependent on only one of the two columns in the primary key, this poses a risk for _____.
A) qualification errors
B) update anomalies
C) function splitting
D) functional dependency

Question

Quizplus · Accepted Answer

Update anomalies can occur because the column that depends on only one part of the composite primary key does not adhere to the principle of full functional dependency, leading to potential inconsistencies during data updates.

Suppose You Have a Table with a Primary Key Composed