For Higher Computing Science, revise the use of primary and foreign keys and the difference between flat file and relational databases.

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

I have a foreign key constraint that I created to reference the primary key of another table:constraint geneassay_fk foreign key (geneassay) references ...

For everyone normalizing their designs, just remember: There ain't no such thing as a partial foreign key. When a project pretends that partial foreign keys are a valid concept, the end result is a ...