Development Update: Show Location Code Written

Over the past week, I have been working on the last remaining pieces of the new Stats Page and its underlying database structure. Well, I have finally finished writing up the code to grab and display the location in which shows are recorded at. I still have not entered any real data for it yet; but, it is ready for when I am able to get that data in. To verify that I have the code working, I wired it up to the test script that I have been using. The following is a snippet from that script’s output. Note the field called “Show Location”. I still haven’t had a chance to work on the web presentation layer yet.

Sneak Peek: Database Design for Version 2.0

For all of the Wait Wait fans out there that also are into database designs, you are in for a small treat. Below is an EER diagram of the recently updated database used to house the statistics and other information for the Stats Page. You can view the diagram in its full-sized glory by clicking on this link. My goal is to get the database data and tables as normalized as possible by way of mapping tables. As you can see from the “ww_showpnlmap” table that I have fields for recording: how many points each panelist had, how many points each panelist had before and how many questions the panelists answered correctly during the Lightning Fill-in-the-Blank round. I don’t have data for every single show or panelist at this point. Right now, there is one additional mapping table that I will need to create …