Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed00.sul.t-online.de!t-online.de!news.zanker.org!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!transit.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Date: Thu, 07 Oct 2004 00:45:52 +0200
From: mAsterdam <mAsterdam@vrijdag.org>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040616
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.theory
Subject: Re: OO and relation "impedance mismatch"
References: <31f7e57d.0410020300.16f447fe@posting.google.com> <pan.2004.10.02.13.18.03.39531@arvin.dk> <ohjsjc.99t.ln@mercury.downsfam.net> <pan.2004.10.05.06.58.39.112362@arvin.dk> <d05ujc.652.ln@mercury.downsfam.net> <1096994448.893768.16560@k26g2000oda.googlegroups.com> <75kujc.gh3.ln@mercury.downsfam.net> <1097001822.479306.217660@k26g2000oda.googlegroups.com> <6h3vjc.js4.ln@mercury.downsfam.net> <1097069427.158509.40600@h37g2000oda.googlegroups.com> <fac1kc.83b.ln@mercury.downsfam.net>
In-Reply-To: <fac1kc.83b.ln@mercury.downsfam.net>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 15
Message-ID: <4164759e$0$78749$e4fe514c@news.xs4all.nl>
NNTP-Posting-Date: 07 Oct 2004 00:45:50 CEST
NNTP-Posting-Host: 194.109.233.75
X-Trace: 1097102750 news.xs4all.nl 78749 [::ffff:194.109.233.75]:1904
X-Complaints-To: abuse@xs4all.nl
Xref: dp-news.maxwell.syr.edu comp.databases.theory:26570

Kenneth Downs wrote:

...

> 3.  Enforce the arbitrary convention that a foreign key definition 
>     causes columns to be placed into the child table that correspond
>     in name and type/precision/scale to the primary key of the
>     parent. 

<delurk>
Not the name.
It would exclude mutliple foreign keys between
two tables (ordinary? yes, very). You might want to use the role 
name for each of them.
</delurk>