Apologies if this isn't the norm, but I am seeking advice for the database design for 'dog rescue/adoption'.
I've done my normalization research and this is my first attempt at database design. Any tips/feedbacks/criticism?
The trickiest part was dealing with dogs/users/organisations and representing who owns a dog.
a dog can belong to an organisation. An organisation can have many organisation users. Think animal shelter/pound
a dog can belong to an organisation user. think a one man band with a large property housing multiple dogs at a time
a dog can belong to a single user, not attached to any organisation. think someone moving overseas and they need to find their dog a new owner
So, the dog table has to have either an organisation ID or a user ID attached to it, or both. Perhaps a trigger stating that one must be not null.