Relationships: one, many, and many to many

Where the foreign key goes, why one-to-one needs more than a foreign key, and why a list of ids in a column is a relationship nobody enforces.

Checking your access…