passwella.
Menu

WAEC Data Processing 2025 Question 36

Question 36

Database Management

To create a one-to-one relationship in database, it is necessary that

  1. A.both primary and foreign key fields should have multiple key index.
  2. B.both primary and foreign key fields should have unique key index.
  3. C.only the foreign key field should have a unique index.
  4. D.only the primary key field should have a unique index.
Show the answer and explanation

Answer: B (both primary and foreign key fields should have unique key index.)

Explanation

In a one-to-one link each value can appear only once on both sides, so both keys must be unique.