Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

relational design question

Show all headers | View raw

Hi - I have a tool that allows managers to nominate their fellow
employees for an award.  Part of the nomination is specifying the
education of an employee.  This data can change year to year, and I
want to keep track of the data as it existed in each year.

I have a nominations table:
* nomination_id
  year
  candidate_id
  nominator_id

And I have an education_entries table:
* ee_id
  school
  year
  degree

And I have a nom_education_entries table:
* nom_id   (FK to nominations.nomination_id)
* ee_id      (FK to education_entires.ee_id)

My intent is for each education_entries row to be able to be used for
multiple nominations, but for only one employee.  I don't want
nominations for different employees to use the same education_entries
row.

What's the best way to alter the design of this to do what I need?

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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