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 ...