Greetings.
I’m trying to figure out what the data modelling best practice is, regarding a situation where a table can be connected to several others using an “optional” foreign key.
To better illustrate the example, let say we have a TASKS table.
Each task is assigned to a user from the USERS...