Find the false statements.
-
a) A Primary Foreign Key is a foreign key on the parent-side that points to one “primary” record on the child -side of a one-to-many relationship
-
b) A primary FK creates a one-to-many relationship between the parent and the child
-
c) A primary FK allows the one initial query to join in one child record per MVG per parent record and display it
-
d) None
The question asks which statement is false. Option B states 'A primary FK creates a one-to-many relationship between the parent and the child' - this is FALSE. A Primary Foreign Key points from the CHILD side to the PARENT (one child has one primary parent), creating a many-to-one relationship from child perspective, not one-to-many. The one-to-many exists from parent to child, but the FK itself doesn't create it - the relationship exists first, then FK identifies which child is primary. Options A and C correctly describe primary FKs.