By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,486 Members | 1,150 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,486 IT Pros & Developers. It's quick & easy.

Database of electoral results?

P: n/a

Hi all,
This is not so much a question specific to PostgreSQL, but rather a
general "application of theory" type of problem!

I did post this on comp.databases.theory but received no replies there.
If anyone here is interested and this is a suitable forum in the
PostgreSQL hierarchy, that would be great! If this is not a good group,
please point me in the right direction.

The actual election being discussed is neither here nor there, but I
mention it so that people might get a flavour for the issues - I often
find that this can help to get a discussion/flame-war/whatever going!
I am planning a database of the results for the NoI (North of Ireland)
assembly elections.

Background information can be found here
For those not used to the STV (Single Transferrable Vote) PR
(Proportional Representation) method used in elections in Ireland or the
NoI (still part of the United Kingdom), all I can suggest is to search
for STV PR on your favourite search engine.
Basically constituencies are multi-seats and voters vote for their
choice in order of preference (1,2,3,4... &c.) and when a person is
elected, their surplus is transferred to still unelected candidates.
It's quite a complex system, and makes for great amateur psephology.
This will be a proper SQL database that will allow for sophisticated
queries about the results.
What I would like to know from this group is:

"Does anybody know of logical and/or data models that have been used in
the past to model election data?" - i.e. Candidate, Constituency,
Party, Election &c. (Sample tables and fields would be nice! 8-);


"Particularly in the case of STV PR elections?":
BTW, I did search in the library of free datamodels here
and found nothing.
Any URL's, references, discussions, texts, ideas &c. welcome.

I did look at

and I don't see much there that I can apply to my particular problem.


C++ Builder 5 SP1, Interbase IBX 5.04 W2K Pro

Please do not top-post.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.