Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database design qn for one-to-many relationship

Re: Database design qn for one-to-many relationship

From: Jon Maz <jonmaz_at_surfeu.de.no.spam>
Date: Fri, 7 Mar 2003 16:52:34 +0100
Message-ID: <b4af3j$qcc$1@news.online.de>


Hi Damjan,

Thanks for your advice. Your suggested third solution with an Entities table was something I had never thought of - if I were designing the system from scratch, I might do it that way, but since I am now adding this Notes functionality to existing tables, it would be too disruptive to change the way the PK's work in tblPeople, tblCompanies etc.

So I'll do as you recommend, and go for solution #2.

Thanks again,

JON Received on Fri Mar 07 2003 - 09:52:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US