I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple. Every table that you want to use in relations should have a primary key ...

This, or these, attribute(s) are the candidate key(s) for the structure. The candidate key is also known as the primary key, or if a structure has multiple candidate keys, then one of them is ...