This website is the computerized version of the House of Representatives election in Australia. Voters will go through the same process that they experience when they vote in real life at Voting Centres, from giving their information to filling in the ballots. Oracle Database is used to store all the data required to run the website and for it to function properly. This website was my final project for the Database Applications course at RMIT University.
I made the artistic choice to make the website simple yet practical and user-friendly as it is meant to be a governmental website for citizens of all ages and backgrounds. A straight-to-the-point interface will quickly and effortlessly guide users through the voting process without any confusion or distraction. Below are some screenshots of the website:
The website implements an Autocomplete API by Google Maps, which fastens the process of filling in information and ensures the consistency and validity of residential information by preventing things like typos made by voters. This is also one of the compulsory requirements for this assignment.
On the other hand, Oracle Database is responsible for the behind-the-scenes work, which in this case is storing all the data about voters and the elections. Every time a voter enters their information, the website will check it against the database to verify whether this voter is registered and whether they have voted. After that, it will automatically match the voter's address to the corresponding Electorate and show the list of candidates in that Electorate.
Sample data is provided to store in the database so markers can test the website during the marking process, which can be found in the sampledata.txt file. If the website works properly, 2 sample voters will be shown different ballots with different sets of candidates as they are in different Electorates. The list of candidates must also appear correctly in their corresponding Electorate as provided in the sample data.
It is unlikely that you will be able to test the website now as this has been done by the markers. In other words, sample voters have already been marked in the database as voted. However, this website received full marks so it does function the way it is programmed to.
This is a project that I'm very passionate about because I put a lot of time and effort into it. It was my first time building a website and after hours of debugging, I was overjoyed to see it up and running properly. I also had a very great time learning PHP and improving my HTML while working on this project. To be honest, I did find this project a highly time-consuming challenge as I had to take on both front-end and back-end roles. Even though the back-end tasks are very relevant to the course, I was not familiar with the front-end side of this project at all, which could be demotivating at first. However, I love learning new things and I also believe that learning more about different parts of a tech project will make me a better team player.

