Each department employs many employees, but each employee works in exactly one department. What is the mapping cardinality from Department to Employee?
Correct answer C. One-to-many
Explanation
Reading from Department to Employee, one department relates to many employees, while each employee relates to only one department, so the mapping is one-to-many. Read in the opposite direction, Employee to Department, the same relationship is many-to-one, which is why that option tempts. When mapped to tables, the many side (Employee) receives a foreign key to Department.
Answer checked How we write and check questions
Discussion