While the city slept, Augustus (
[email protected]) feverishly
typed...
Help wanted will pay reasonable fee
I need someone who can working from a template I supply, fill in the
data for 308 Members of Parliament (MPs)
This is NOT a database project.
It would be hard to come up with a more perfect example of what
should be a database project
Agreed
[...]
- if an MP is voted out of office (or dies or retires or whatever)
you only have to delete his/her entry in the DB and enter the new
entry... [...]
A better approach would be to have an entry for each seat, and change the
details of the sitting MP when necessary. No need to delete one and then
enter another. Eg. I am in the High Peak constituency (UK). The sitting MP
is Tom Levitt (Labour). If (or when) at the next election there is a new MP,
simply change the details for "High Peak" to reflect this. I would also
suggest recording such details as the MP's majority, and the majority at the
previous election (to help demonstrate any swing). If he actually manages to
keep his seat, then update the High Peak entry to show the new majority.
Cheers,
Nige