I have a data modeler who is set on developing using a natural key. The issue at hand is this,
1) The natural key which they intend to use will be broken immediately in our system because of what it represents.
2) The natural key models a type of facility but only 1 facility of the same type is modeled by this key.
3) Our footprint allows for in several cases for multiple facilities of the same type to exist and thus have the same natural key apply.
4) The system I am working on is for the purpose of modeling all facilities.
5) The data modelers issue is that other systems wanting to report from us will be unable to manage the fact the "natural key" exists more than once and will thus cause invalid information.
Now as for the answer I have mine and have posted in the past what I would do. But in this case I am too close to the issue for others to seem to take me as seriously not focused on being stubborn as they see it. So I am posting here for comments and suggestions to see if my solution is the concensus or if maybe someone else sees another way I haven't thought of that will satisfy the data modeler.
Any and all input is appreciated.