Practice mode DBMS and SQL

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.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.