Multiple Choice
Which of the following is NOT true regarding second normal form?
A) The second normal form requires that the table has no fields with partial dependencies on a composite or concatenated key.
B) The table satisfies 1NF.
C) The table may contain a transitive dependency.
D) The table could have a partial dependency.
Correct Answer:
Verified
Correct Answer:
Verified
Q76: Each employee can only be in the
Q77: The _ approach in an ERD will
Q78: A(n)_ anomaly forces you to change data
Q79: A transitive dependency is when the field
Q80: A(n)_ key is created from naturally occurring
Q82: The 1NF dictates that the table must
Q83: Which of the following is NOT true
Q84: An insertion anomaly suggests that you enter
Q85: A depends on B and B depends
Q86: _ will update a foreign key automatically