There are reviews on a pile of data modelling tools at databaseanswers.org. Some of the more expensive tools are very good but it takes quite an effort to get up...
If you number all your identities from 1 then there will be duplicated values in different tables. If an application developer gets hold of the wrong integer key and inserts it as,...