Allvue Systems Interview Question

Difference between joins, foreign and primary key, etc.