My question is about design / patterns for an international database.
The client has requested a single database to allow for many countries to enter their data (English, French, Japanese, etc). Each country could be viewed as a separate system almost.
All lookups / pick lists must be divided by country (easy).
Where is the best place to identify a countrys ownership of data?
The best way to describe what I am asking is on the attached example ERD... this is an example not the real thing!
Many thanks for help.