What relationship exists when a primary key may appear many times as a foreign key,and a foreign key must appear once and only once as a primary key?
A)1:1
B)1:M
C)M:M
D)M:1

Question

Quizplus · Accepted Answer

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is one-to-many (1:M).That is,a primary key may appear many times as a foreign key,and a foreign key must appear once and only once as a primary key.

What Relationship Exists When a Primary Key May Appear Many