If you create a nice, perfectly normalized database, you (probably) won’t ever
run into circular foreign keys (when a row in table A references a row in table
B that references the same row in table A).
In the real world, this happens pretty regularly. The most common situation