CS 318 Course Materials
Database and Transaction Systems
Spring 2002

General

• Syllabus: PDF, HTML.
• Grades. (See instructor for password.)
• PostgreSQL Use PDF, HTML.

Resources

Unix, vi, and emacs

• Unix tutorials: Unix Tutorial. Coping with Unix, An Interactive Survival Kit. Yet another Unix tutorial. Getting Started with Unix (PDF).
• vi guides: A Beginner's guide to vi and ex. Mastering the vi Editor.
• emacs guides: Remember that emacs has a self-contained tutorial, accessed by typing C-h t after starting emacs. emacs Tutorial. Getting Started with emacs: Emacs Beginner's HOWTO. Getting Started with the Emacs Screen Editor (PDF). GNU Emacs Manual. GNU Emacs FAQ. Emacs Reference Card from the Free Software Foundation.

HTML

• The Bare Bones Guide to HTML.
• Introduction to HTML.

PHP

• PHP Web Site. PHP Manual. Introductory Tutorial.
• PHP Tutorials.
• Another PHP tutorial.

PostgreSQL and SQL

• PostgreSQL web site. PostgreSQL Documentation (also see phoenix man page for psql). HOWTO for PostgreSQL.
• SQL for Web Nerds.
• Philip and Alex's Guide to Web Publishing (Really a book about database-backed web sites. Wicked funny with tons of great photographs. A must read.).
• SQL Tutorial.
• Another SQL Tutorial.
• SQL.org. Resources at SQL.org.

Assignments

• Semester Project PDF, HTML.
• Homework I, due Feb. 13 PDF, HTML.
• Homework II, due Feb. 27 PDF, HTML. Solution PDF, HTML.
• Homework III, due Mar. 13 and IV, due Mar. 27. PDF, HTML. Solution for III PDF, HTML. Solution for IV PDF, HTML.
• Homework V, due Apr. 10: 8.2, 8.5, 8.9.
• Homework VI, due Apr. 24 at the beginning of class PDF, HTML.
• Group Homework VII, due May 1 at the beginning of class: demonstrate that each of your project's tables are in BCNF or 3NF. For any tables that are not in these normal forms, provide a decomposition that is in dependency-preserving BCNF (preferably) or 3NF. Post your demonstration to your group web site.

Class Outlines

• Week 0: Jan. 23 PDF, HTML. Jan. 25 PDF, HTML.
• Week 1: Jan. 28 PDF, HTML. Jan. 30 PDF, HTML. Feb. 1 PDF, HTML.
• Week 2: Feb. 4 PDF, HTML. Feb. 6 PDF, HTML. Feb. 8 PDF, HTML.
• Week 3: Feb. 11 PDF, HTML. Feb. 13 PDF, HTML. Feb. 15: Continuation of SQL material from Feb. 13.
• Week 4: Feb. 18 PDF, HTML. Feb. 20 PDF, HTML. Feb. 22 PDF, HTML.
• Week 5: Feb. 25: Class cancelled. Feb. 27: Continuation of TRC material from Feb. 22. Mar. 1 PDF, HTML.
• Week 6: Mar. 4 PDF, HTML. Mar. 6 PDF, HTML. Mar. 8: Homework review.
• Week 7: Mar. 11 PDF, HTML. Mar. 13: Midterm. Mar. 15: Field trip.
• Week 8: Mar. 27 and 29 PDF, HTML.
• Week 9: Apr. 1 PDF, HTML. Apr. 3 PDF, HTML. Apr. 5 PDF, HTML.
• Week 10: Apr. 8 PDF, HTML. Apr. 10: Finish PL/pgSQL Lab I and II. Apr. 12: Discussion.
• Week 11: Apr. 15: Really finish PL/pgSQL Labs I and II. Apr. 17 PDF, HTML. Apr. 19 PDF, HTML.
• Week 12: Apr. 22 PDF, HTML. Apr. 24 PDF, HTML. Apr. 26: GIG.
• Week 13: Apr. 29 PDF, HTML. May 1 PDF, HTML. May 3 PDF, HTML.

Class Materials

• Week 0:
  • Jan. 25: Using Unix PDF, HTML. PHP scripts showing basic usage of PHP and form handling: hello.php, text of hello.php. loop.php, text of loop.php. form.html, text of form.html. text of process.php. form2.php, text of form.php. text of process2.php.
• Week 1:
  • Feb. 1: SQL Lab I PDF, HTML.
• Week 4:
  • Feb. 18: PHP scripts showing usage of sessions and PHP/PostgreSQL interaction: pageCount.php, text of pageCount.php, login.html, text of login.html, authenticate.php, text of authenticate.php, query.php, text of query.php.
  • Feb. 20: PHP/PostgreSQL Lab PDF, HTML. PHP scripts showing usage of include() call and function definition: factForm.html, text of factForm.html, fact.php, text of fact.php, factorial.php, text of factorial.php.
• Week 10:
  • Apr. 8: PostgreSQL Triggers Lab PDF, HTML.
  • Apr. 10: PostgreSQL Triggers Lab II PDF, HTML.