If you have ever designed a database schema, you have probably drawn an ERD with crow's foot notation. You learned that a circle means optional, a line means mandatory, and a crow's foot means many. You felt confident.

Then you opened your SQL editor and had to guess whether the FK should be NULL or NOT NULL. You were not sure if you needed...