Database Design Changes

Through out this phase there have been unplanned changes to the evote database. The Position table was removed since it wasn't vital and the information could be stored in a different table. This table might make coding efficient in the Raven version but for the Sparrow version it is not necessary.

Today, a column called "Barcode" was added to the candidate table . This field will store the text to be converted to the printed receipt.

A history table was added to associate a an official to a voter. This way, should there be any problems with a voter or an official, related people can be identified.

The kiosk table was given an additional identification number to make the voting experience better for voters and officials. The kID field is unique for every kiosk, so in a real life scenario every kiosk in the area using the system will have a different number. This number would only be useful when looking at the kiosks from an outside perspective. In the voting units, the officials and voters need local identification number that will make it easy for them to know where a voter has to go.