Primary Key and Foreign Key: understand the difference between them

Primary keys, foreign keys and relationships between tables are not always easy to learn when you are starting out. Besides this, there is cardinality, modeling, queries… Of course all this can be very confusing. I know, because I have been…