scenario based sql question

Question

Hi,

I was just reading SQL scenario based question from this link  ( https://www.c-sharpcorner.com/blogs/a-scenario-based-sql-interview-queries-test-modeltraining)

 

I want  information about "relationship between tables". I cannot find in this link.

Can you share me?