Question

Which relationship is possible when two tables share the same primary key?

A. one-to-one
B. one-to-many
C. many-to-one
D. many-to-many

Answer 1

The correct answer is many-to-one

This kind of relationship is likely to happen when two tables share the same primary key because one entity had values that are related to another one that has distinctive values. It is usually applied by primary key relationships and the relationships normally are between fact and dimension tables and levels in hierarchy as well.