Slide 10.1: Programming Exercise II: an on-line music store using a database
Slide 10.3: Database and JDBC (or other host languages) setup
Home

How to Construct the Programming Exercise II


There are many ways to construct a web-enabled database system such as LAMP or ASP.NET. This course uses the following steps including CGI, JDBC, and Oracle to create the system:
  1. Database and JDBC (or other host languages) setup,
  2. Database design,
  3. Database implementation (SQL),
  4. Web user interface construction [(X)HTML],
  5. Calling a CGI script (Unix shell),
  6. Calling a CGI script (Perl), and
  7. Database accessing embedded in Java host language (JDBC).
These steps and tools are not definite nor unique. You may take other approaches. This approach has the following advantages and disadvantages: