I am learning databases and sql. I am trying to understand if one single parent table can have multiple child tables, and if yes, just how common is it in financial companies? If this is allwoed, is such a structure typically used in database design, or does one strive for a one parent table linked to just one child?
In other word, let's take a table with a primary key. Can we link it to say three other tables via appropriately defined foreign keys in those respective tables?