I ask, therefore, my readers--particularly the regular ones--please disseminate the information by linking to this site's posts on as many of the web and social media sites for whose audience you deem the material important. It is not available anywhere else. Thanks.
What is wrong with last week's picture painted by Martijn Evers in Kinds of Keys: On the Nature of Key Classifications.
"Many data and information modelers talk about all kinds of keys (or identifiers. I'll forego the distinction for now). I hear them they talk about primary keys, alternate keys, surrogate keys, technical keys, functional keys, intelligent keys, business keys (for a Data Vault), human keys, natural keys, artificial keys, composite keys, warehouse keys or Dimensional Keys (or Data Warehousing) and whatnot. Then a debate rises on the use (and misuse) of all these keys ... The foremost question we should actually ask ourselves: can we formally disambiguate kinds of keys (at all)?"I, of course, sympathize, as I've deplored the misuse and abuse of terminology in the industry for longer than I care to remember. Chris Date once wrote an article titled Models, Models Everywhere, Nor Any Time to Think. So this is not unique to keys, it's a general absence of foundation knowledge.
The answer is yes, we can disambiguate--the key to keys is understanding what in the real world they represent and what database function they fulfill. Things are much simpler than the mindless industry jargon.