Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Arved Sandstrom" Subject: Re: Designing a structure Message-ID: <01GTj.565$Yp.560@edtnps92> X-Comment-To: comp.databases,comp.lang. Newsgroups: comp.lang.java.databases In-Reply-To: References: Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 22 Date: Wed, 27 Apr 2011 15:21:33 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303917693 96.60.20.240 (Wed, 27 Apr 2011 10:21:33 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:21:33 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:67 To: comp.databases,comp.lang. "Stefan Ram" wrote in message news:join-20080505155910@ram.dialup.fu-berlin.de... > "Arved Sandstrom" writes: >>named relationships [...] so the join tables will >>often have at least one extra attribute. > > Which is the same as keeping a single join table > per named relationship without an extra attribute. This is true. But you'd want to ask whether or not you want one join table for for work phone numbers, one for personal phone numbers, and possibly others for other phone numbers. Easier to have one join table for PersonInfo - PhoneNum, and keep an attribute in there that describes the nature of the phone number. AHS --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24