Another important art is choosing a good, unique primary key for every table. ... I’ll explain this by using examples in DDL, using SQL Server syntax. The short version of this is fairly simple.

I'm adding a table and subclass table to my DB. (Subclass table = table where the primary key joins to the primary key of another table, to give extra row information to some subset of the rows ...