Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q2: Explain why and how an unnormalized relation
Q3: In a relational database, _.<br>A) rows must
Q4: In the following shorthand representation of a
Q5: A table in second normal form should
Q6: Which of the following tables is in
Q8: The process of determining the particular tables
Q9: Within an entity-relationship diagram, which of the
Q10: You can determine functional dependence by viewing
Q11: Why have Social Security numbers traditionally been
Q12: When you are designing a database, _.<br>A)