Minor Description
PRIMARY KEY does not imply NOT NULL. Derby issues error message:
ij> create table tab (i integer primary key);
ERROR 42831: 'I' cannot be a column of a primary key or unique key because it can contain null values.
This is neither compliant with SQL-92 nor with SQL-99 (Feature E141-08, I think).