WAEC Data Processing 2023 Question 23

Question 23

Database Management

Figure 4 is an entity relationship diagram in MS Access.
What kind of relationship exists between users and products as shown in Figure 4?

Diagram for this question
  1. A.One-to-many
  2. B.One-to-one
  3. C.Many-to-many
  4. D.Many-to-one
Show the answer and explanation

Answer: A (One-to-many)

Explanation

One user (USER_LOGIN) can register many products, so users to products is one-to-many.