Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: "Mark D Powell" <Mark.Powell@eds.com>
Newsgroups: comp.databases.theory
Subject: Re: How to represent a total-and-exclusive relation into a relational database
Date: 19 Jan 2005 12:36:39 -0800
Organization: http://groups.google.com
Lines: 7
Message-ID: <1106166999.904249.189350@z14g2000cwz.googlegroups.com>
References: <uIcHd.52889$%K3.1232946@weber.videotron.net>
   <1106080835.292071.62190@z14g2000cwz.googlegroups.com>
   <8qwHd.36322$06.30996@clgrps12>
NNTP-Posting-Host: 192.85.50.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1106167004 10913 127.0.0.1 (19 Jan 2005 20:36:44 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 19 Jan 2005 20:36:44 +0000 (UTC)
In-Reply-To: <8qwHd.36322$06.30996@clgrps12>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=192.85.50.1;
   posting-account=J7QqBQwAAABTieek3RP_669Gs2iATWzr
Xref: dp-news.maxwell.syr.edu comp.databases.theory:29489

Mathieu, Celko created the UK on the PK + another attribute, in this
case, vehicle_type because his design calls for creating a table for
each vehicle type and he want a FK from the vehicle type tables back to
the parent for referential integrity.

HTH -- Mark D Powell --