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: Need help with twisty design problem

Re: Need help with twisty design problem

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 13 May 2002 13:52:21 -0700
Message-ID: <c0d87ec0.0205131252.123a6fbc@posting.google.com>


>> The columns beginning with 'User...' are the respondent data. The
columns beginning 'DM...' are what the respondent submits as the person meeting the criteria in 'KeyDM'. However, if the respondent is also the person meeting the criteria, I don't want to populate the'DM..' columns with the same data. <<

Why not? They are playing a different role as a "Qualified surveyee" than they played as a "first-time surveyee" -- and they did in fact qualify themselves. There is a real logical difference here.

You might want to prune the relationship table down to user_id's and have a table of all user's data rather than repeated the attributes in two places in the relationship table. Maybe add a few columns about when this happened, etc. Received on Mon May 13 2002 - 15:52:21 CDT

Original text of this message

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