I get a much better understanding of things when I use diagrams rather than words.
This PowerPoint slide is my attempt to represent Question 1 in diagrammatic form.
I know that this diagram is not complete.
It is provided here so that my fellow students on the "Introduction to Databases" course can make suggestions on how to improve the diagram so that it gives a correct representation of Question 1 in the Recursion quiz.
For ease of reference, the "Notes" part of the slide contains the text of question 1.