For my portion of the project I am only dependent on other components when it comes to data visualization. I will need to retrieve information from the database to be able to do this. I have reviewed Catherine's interfaces, and it seems the only ones I will be dealing with are DatabaseInterface.php and potentially Data.php I have a few overall concerns. First, these interfaces are in php5 and we will be using php4. Interfaces don't exist in php4. So these php files will need to be fully filled in and just included in my php files, which I don't think is too much of an issue. Second, it seems that the only three functions I would use in DatabaseInterface.php are getInformationFromTable(), selectDatabase(), getTableColumnNames(), and the constructor. One thing that I see that is missing is that when I connect to the database, I will somehow need to know which table is the current election table. Perhaps adding some sort of getCurrentElectionTableID() method would be good. However, these don't provide much of a wrapper around the SQL, which is perhaps what we want. In other words, it's the difference between just calling a method like getNextVoterName() and passing "SELECT voter_name FROM ucs_election" to some method. Also, it is somewhat ambiguous to me what the $what_to_select string will be in the getInformationFromTable() method. Will this be an SQL statement? Or something else? It seems to me that it might just be best for me to pass in an SQL statement and get back a result set. The final thing is that I didn't see anything about an SQL schema. It seems we should make this ASAP. What I mean is we need to know what tables we'll need to create and what these tables will store. For my part, it seems like I'll need an "elections" table that stores election IDs, election start/end times, current election ID, etc. For data vis, there will need to be a table for that specific election that contains voter names and then the questions and their responses. i.e. "elections" table: election ID| start time | end time | current election? -----------|------------|------------|------------------ UCS Spring | 2/2/05 4PM | 2/3/05 4PM | Y -----------|------------|------------|------------------ UCS Fall | 9/8/05 4PM | 9/9/05 4PM | N -----------|------------|------------|------------------ "UCS Spring" table: voter name | Q1 | Q2 | Q3 -----------|-----------|------------------|---------------- Joe Schmoe | Y | Charlie Cummings | Mary Black | | | Sue Wood -----------|-----------|------------------|---------------- Amy Smith | N | Joel Payne | Sue Wood | | | John Gormly -----------|-----------|------------------|---------------- As for the testing and schedule, the only parts that really concern me are again with the database. I should be able to start with excel and data vis php stuff before the database is done. The current schedule has me starting on excel exportation before break and the database schedule is done by 4/3. Basically the sooner database stuff is ready to go, the better for me.