a couple of database design questions...

And some don’t even support them: SQLite3.

From http://www.sqlite.org/omitted.html:

FOREIGN KEY constraints are parsed but are not enforced. However, the equivalent constraint enforcement can be achieved using triggers.

Phillip