The relationships between tables in a database is defined by the database designer and hence will vary significantly from database to database.
You need to do a google search to look for some training online about database fundamentals.
As an example something like...
Database Fundamentals - YouTube[
^]