Project #3: Due Apr. 23 Apr. 26, BEFORE Class Begins

PDA (Personal Database Application), Courtesy of J. Widom

In Project #3, each team needs to create a web-based interface to their DB2 database. As we discussed at the beginning of the course, a huge number of Web sites are based largely on a relational database system. The HTML pages a user browses are generated from the database, and user actions and inputs result in behind-the-scenes SQL queries and updates. Although the database-backed site you will create is not likely to be as snazzy as a typical Web shopping or auction site, the basic idea is the same. Here are some general ground rules:


Your Web front-end can interact with the DB2 database using many ways -- CGI, ColdFusion, PHP, ASP, JSP, JavaScript, Applet/Servlet, or ODBC/JDBC, just to name a few. Since this is not a Web course, we cannot possibly cover all these. Ideally, we should be able to cover at least ODBC/JDBC since they are the ones most related to Database course. However, most students in IST210 do not have adequate programming background, nor PSU ITS supports it.

Therefore, what we finally chose was to use PHP for this task. ITS officially supports DB2 along with PHP. They have already created a starting point for you to work as follows:


  1. By due date, a final project web site that has Web-based interface to DB2 must be ready and accessible to anyone on Web.

  2. A project 3 report (hardcopy) and a presentation (hardcopy) must be turned in to the Instructor at 313A.

  3. In addition, the same report must be linked to the web site; it includes
We will be running everyone's Web interface in order to grade this part of the PDA. You will lose substantial points if the web interface that you created does not run properly, or if the URL linked to your project web page is not valid. Also, if you decide to require a username and/or password to access your database through the Web, then you must either disable this feature in your submitted version or inform us a working username and password.

Dongwon Lee
Last modified: Mon Apr 19 14:24:40 EDT 2004