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
Q2: What do you call a data inconsistency
Q3: If B is functionally dependent on A,
Q4: Which of the following can be defined
Q5: The normalization process is a series of
Q6: Which term's definition also defines a candidate
Q7: Converting to third normal form always avoids
Q8: Tables without repeating groups are said to
Q9: A table is in fourth normal form
Q10: Third normal form is sometimes referred to
Q11: Any row that determines another row is
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents