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