What is the problem with designing a database in which the last name of an employee functionally determines the employee's address?
A)This design has no problems.
B)Two employees could be living at the same address.
C)More than one employee could have the same last name.
D)The address will automatically functionally determine the employee's last name.

Question

Quizplus · Accepted Answer

Having multiple employees with the same last name is common, and if the last name functionally determines the address, it implies that all employees with the same last name would have the same address, which is not practical or accurate in real-world scenarios.

What Is the Problem with Designing a Database in Which