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>
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

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.