Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!newsfeed.inode.at!news.hispeed.ch!not-for-mail From: Bob Hairgrove Newsgroups: comp.databases.theory Subject: Re: Key attributes with list values was Re: What are the differences ...KEY Date: Sat, 25 Feb 2006 18:05:17 +0100 Organization: Cablecom Newsserver Lines: 14 Message-ID: References: <1140522359.762187.213930@o13g2000cwo.googlegroups.com> <1140804359.681816.282310@t39g2000cwt.googlegroups.com> <1140804994.799874.324810@t39g2000cwt.googlegroups.com> <1140806669.181174.102510@e56g2000cwe.googlegroups.com> <1140812436.783278.188800@i39g2000cwa.googlegroups.com> <1140883592.060038.188390@z34g2000cwc.googlegroups.com> <1140886408.778878.179090@i39g2000cwa.googlegroups.com> NNTP-Posting-Host: 217-162-169-120.dclient.hispeed.ch Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.hispeed.ch 1140887218 20766 217.162.169.120 (25 Feb 2006 17:06:58 GMT) X-Complaints-To: news@hispeed.ch NNTP-Posting-Date: Sat, 25 Feb 2006 17:06:58 +0000 (UTC) X-Newsreader: Forte Free Agent 1.93/32.576 English (American) Xref: dp-news.maxwell.syr.edu comp.databases.theory:36851 On 25 Feb 2006 08:53:28 -0800, "dawn" wrote: >This is one of the reasons to possibly identify a >candidate key as the primary key and restrict it to a single (although >possibly composite) value. A single key with a composite value is generally known as an "intelligent key". If you google for this term, you will find lots of reasons why this is generally considered to be a bad idea. I won't repeat them here because it would be a waste of NG bandwidth. -- Bob Hairgrove NoSpamPlease@Home.com