Slides 2: Programming Exercise I

The following slides give the Programming Exercise I construction steps.

Slide 2.0: Programming Exercise I: A database-driven online bookstore for administrators only

Slide 2.1: Programming exercise guidelines

Slide 2.2: Hosting a database-driven website

Slide 2.3: (Exercise I) How to build the Programming Exercise I

Slide 2.4: (Exercise I) Database and JDBC (or other host languages) setup

Slide 2.5: (Exercise I) Database and JDBC setup (cont.)

Slide 2.6: (Exercise I) Database design

Slide 2.7: (Exercise I) Database design (cont.) — ER model

Slide 2.8: (Exercise I) Database implementation (SQL) — SQL

Slide 2.9: (Exercise I) Database implementation (cont.)

Slide 2.10: (Exercise I) Web user interface construction [(X)HTML] — ListCourses.html

Slide 2.11: (Exercise I) Calling a CGI script (Unix shell) — ListCourses.cgi

Slide 2.12: (Exercise I) Calling a CGI script (Perl) — ListCourses.pl

Slide 2.13: (Exercise I) Database accesses embedded in Java (JDBC) — ListCourses.java

A priest who graduates from law school
is called a father-in-law.