WAEC Data Processing 2015 Question 35

Question 35

Database Management

The diagram above illustrates the relationship between two tables in a database. Use it to answer questions 35 and 36.
The student ID in Table II is referred to as

Diagram for this question
  1. A.primary key.
  2. B.foreign key.
  3. C.normal key.
  4. D.composite key.
Show the answer and explanation

Answer: B (foreign key.)

Explanation

Student ID in Table II refers to the primary key of Table I, which makes it a foreign key.