My bet would be on something like this:
ELECTION
electionid primary key
EMPLOYEE
employeeid primary key
ELECTIONPOSITION
electionpositionid primary key
electionid references election.electionid
runningmatepositionid
references electionposition.electionpositionid
ELECTIONCANDIDATE
electionpositionid not null
references electionposition.electionpositionid
candidateemployeeid not null references employee.employeeid
runningmateemployeeid references employee.employeeid
runningmatepositionid tells you whether a given position is voted on
independently or is bundled with another position - in the event that
an election uses runningmates, the vp employee id is found in the
electioncandidate table record for the president candidate - otherwise
there's a 2nd record in the electioncandidate table for the candidate
who's running for himself -- or more simply -- there is one
electionposition record for each voteable record in the
electiondandidate table.
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/author/?id=4806
http://www.fusiontap.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200502
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
