CS 325 - Database and Transaction Systems

Syllabus

Resources:
PHP
        PHP Web Site
        PHP Manual
        Introductory Tutorial
PostgreSQL
        PostgreSQL web site
        PostgreSQL Documentation (also see phoenix man page for psql)
Dia
        Dia Instructions

Schedule:

Chapters	Assignment	Files	Due Date
Semester Project
Chapter 2	p25 2.1, 2.7, 2.8		Sept. 9
PHP Lab			Sept. 14
Chapter 3	homework 2	SQL DDL1 SQL DDL2	Sept. 25
Semester Project Proposals			Sept. 16
SQL Lab1			Sept. 18
Chapter 4	p124 4.9		Oct. 2
E/R Design Lab			Sept. 25
Semester Project E/R design			Sept. 30
Chapter 5	p188 5.10		Oct. 12
Semester Project Formal Specification			Oct. 14
PHP - PostgreSQL Lab		PHP Sessions PHP PostgreSQL Connectivity	Oct. 16
Exam 1			Oct. 23
Chapter 6	p246 6.1,6.4, 6.9		Oct. 28
	p247 6.20		Nov. 2
Chapter 7	Triggers Lab1	PostgreSQL's PL/pgSQL	Nov. 6
	Triggers Lab2		Nov. 6
Semester Project Sample end to end application			Nov. 11
Exam 2			Dec. 4
Semester Final Project			Dec. 9