What are the design criteria for primary keys?
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Fri, 03 Sep 2010 01:20:58 -0300
Message-ID: <4c8077b4$0$11823$9a566e8b_at_news.aliant.net>
Choosing good *primary keys* and candidate keys is a vitally important
*database design* task--as much art as science. The design task has very
specific design criteria.
Date: Fri, 03 Sep 2010 01:20:58 -0300
Message-ID: <4c8077b4$0$11823$9a566e8b_at_news.aliant.net>
Choosing good *primary keys* and candidate keys is a vitally important
*database design* task--as much art as science. The design task has very
specific design criteria.
*What are the criteria?*
As an experiment, I asked the above question on StackOverflow.com having first verified it wasn't already answered on the site. It is a very important question that has a very simple and clear answer. I had planned to offer a sizable bounty if nobody gave the correct answer after the 1st day and answer it myself if nobody claimed the bounty.
I thought the question was clear enough. The answer, of course, is: uniqueness, irreducibility, simplicity, stability and familiarity.
To anyone who uses that site as a resource, all I can say is: Caveat lector! Received on Fri Sep 03 2010 - 06:20:58 CEST