Groups > comp.databases.ms-sqlserver > #899

Re: relational design question

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder2.hal-mli.net!news.glorb.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	"Fred." <ghrno-google@yahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: relational design question
Date	Thu, 12 Jan 2012 06:21:53 -0800 (PST)
Organization	http://groups.google.com
Lines	26
Message-ID	<12044559.466.1326378113904.JavaMail.geo-discussion-forums@yqni15> (permalink)
References	<390061ca-db22-4194-a2de-fd1f19e76740@do4g2000vbb.googlegroups.com>
Reply-To	comp.databases.ms-sqlserver@googlegroups.com
NNTP-Posting-Host	198.234.82.254
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
X-Trace	posting.google.com 1326378114 29404 127.0.0.1 (12 Jan 2012 14:21:54 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Thu, 12 Jan 2012 14:21:54 +0000 (UTC)
In-Reply-To	<390061ca-db22-4194-a2de-fd1f19e76740@do4g2000vbb.googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=198.234.82.254; posting-account=H0CbGQoAAACbl_tS1RfYwvMt_jmh18zO
User-Agent	G2/1.0
X-Google-Web-Client	true
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:899

Show key headers only | View raw

I think you need to think in problem terms
for a while before you go back to data.  What
is obvious is that there can be muliple
educational reports from the same or over the
years different sources, and they can be 
redundant or in conflict.

What you really need to come down to is a
set of education records for each nominee
with conficts and redundancies resolved.

So my shot would be that you really need
two education tables, one for reports
where each record contains a foreign key
to the reporting nomination, and one for
resolved records where each record
contains the nominee_id, which I assume
remains the same from year to year.

Of course if you are going to resolve 
these conficts in the data entry process
you can drop the table for educational
reports.  If entering from paper, you
will need to file the paper anyhow.

Fred.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

relational design question livefree75 <jpittman2@gmail.com> - 2012-01-11 07:24 -0800
  Re: relational design question "Fred." <ghrno-google@yahoo.com> - 2012-01-12 06:21 -0800

csiph-web