Database design for dynamic online surveys

This paper discusses the architecture and implementation of dynamic Web-based surveys with an emphasis on the recently completed Survey2001 project. Survey2001 was made available at the National Geographic Web site for several months starting October 2001 and could be taken in four different languages: English, German, Spanish and Italian. This paper discusses surveys and the advantages of Web-based surveys, lays the background for Survey2001, describes the details of the database used and the manner in which transitions were conducted in this dynamic Web-based survey. It also lists the results, including other surveys developed using the same database structure, and concludes with a look to the future.