Developer for Small LAMP project wanted

**The Netherlands is a democracy with a parliament with 150 seats. The Netherlands has a system with a lot of small political parties. The government is always a combination of two or more parties, a socalled coalition government = coalition. Different combinations of parties can form coalitions, as long as they have a majority (of at least 75 + 1) of seats in parliament.**** ****Every week there are opinion polls. These polls show the popularity of all of the parties in the Netherlands. With the results of these polls you can make combinations of parties to form a majority in parliament (and possible combination to form a coalition of 76 or more seats). When the opinion poll changes every week, the possibilities for coalitions changes.**** **To follow these changes, we want to have a “coalition checker??. This will be an application in which the possible coalitions are shown, based on the last poll, and people can say whether they like the coalition or not. ## Deliverables # Requirements Coalition Checker ## Introduction **The Netherlands is a democracy with a parliament with 150 seats. The Netherlands has a system with a lot of small political parties. The government is always a combination of two or more parties, a socalled coalition government = coalition. Different combinations of parties can form coalitions, as long as they have a majority (of at least 75 + 1) of seats in parliament.**** ****Every week there are opinion polls. These polls show the popularity of all of the parties in the Netherlands. With the results of these polls you can make combinations of parties to form a majority in parliament (and possible combination to form a coalition of 76 or more seats). When the opinion poll changes every week, the possibilities for coalitions changes.**** **To follow these changes, we want to have a “coalition checker??. This will be an application in which the possible coalitions are shown, based on the last poll, and people can say whether they like the coalition or not. ## The application **The opening page should hold a list of possible coalitions that have more than 75 seats in parliament, based on the data of the most recent poll. Only possible coalitions with less than six political parties are put on the page. Visitors can rate every possible coalition by giving stars, 0 stars for the coalition the like the least, one star if they like it a bit more, two stars etc. ending with 5 stars for the coalition they like the best. Every user can vote once for each possible coalition (one vote per IP per opinion poll per coalition).** The results should be saved in the database using Ajax (xml or json). Users can search using their own amount of seats and maximum number of parties. For example, the user should be able to look for all possible coalitions that have at least 85 seats and consist of not more than 3 parties, or for all coalitions of at least 45 seats and consist of not more than 8 parties. They should be able to vote for these coalitions as described in the previous paragraph. Users can also select any number of coalitions and take a look at the history of the coalitions in a line diagram, so they can see what the development during the last months of these coalitions were. It should be taken into account that new parties can emerge, or that old parties stop to exist. We also want to be able to show a list with the most popular coalitions over time, and which parties are most selected for coalitions. For example: The highest rated coalitions are A-B-C, A-B-D and A-E-F. This means that A is the most selected party for a coalition, followed by B and then by C,D,E and F. ## The database We have a database with three tables, which is filled by us. You will receive a dump of this database. One with the parties, with the following colums: - id (integer, autoincrement) - partyname (varchar 255) The second containing the opinion polls, with the following columns: - id (integer, autoincrement) - poll date (date) - poll week (integer) The third table couples both tables, with the following columns - partyId - pollId - percentage (integer) - seats (integer) The way you save the coalitions and their ratings is up to you, but the information should be added to the database. ## Platform The application should be developed for a Linux/Apache/Mysql/PHP4 environment. ## Deliverables - You deliver a working PHP4 application that functions according to the specifications as laid out above. - You deliver a database-creation file that can be used to install the additional tables to our database. - No design is necessary, but the HTML generated by the application should be at least valid XHTML 1.0 transitional. Also you will provide the images for the parts of the application.