Multiple Choice
What is a potential problem, if any, if you design a database in which the last name of a consultant functionally determines the consultant's address?
A) There is no problem with this design.
B) There could be two consultants living at the same address.
C) There could be more than one consultant with the same last name.
D) The address will automatically functionally determine the consultant's last name.
Correct Answer:
Verified
Correct Answer:
Verified
Q30: A column is a nonkey column when
Q31: The normalization process is a series of
Q32: Tables without repeating groups are said to
Q33: What is a nonkey column?<br>A) A column
Q34: What do you call a data inconsistency
Q36: What type of diagram uses arrows to
Q37: An interrelation constraint is a condition that
Q38: If there is more than one possible
Q39: A table that contains a _ that
Q40: The _ process enables you to identify