View this PageEdit this PageUploads to this PageHistory of this PageTop of the SwikiRecent ChangesSearch the SwikiHelp Guide

CMPSC 380, Fall 2003: Principles of Database Systems

Instructor: Bob Roos. Send me email

Click here to see my office hours and
to schedule appointments
(use "Guest user?" button)

Syllabus

Grading distributions (NOT FINAL!!)

K-Means Example

Homework 5

Exam 2 Solutions

EXAM 2 REVIEW Post questions, etc., here

More detailed project description and schedule

Homework 4

Homework 4 solution

HTML 4.01 Specification

FONT is deprecated

Style sheet usage in HTML

CSS, level 1

Lab 8

lib.dtd

lib-xsl.xml (do "view source" to see the XML)

lib-css.xml (do "view source" to see the XML)

css-stylesheet.css

xsl-stylesheet.xml (do "view source" to see the XML)

Download site for JDBC driver software

Lab 7

Homework 3

Lab 6 WARNING: some special symbols may not look right in HTML

JDBCDemo.java

Solutions to homework 2

Sample HTML/PHP Problem (see email for more information)

Midterm exm information and review

Solutions to midterm review problems in previous handout

Lab 5

validate.php

loggedoff.php

sessiondemo.php

loggedoff.php

reload.php

simpleconnect.php

Lab 4

form1.php

form2.php

form3.php

form4.php

table.php

Homework 2 (Due Tuesday, 23 September)

Lab 3 (Monday, 15 September)

Lab 2 (Monday, 8 September)

Homework 1 (Due Tues., 2 September)

Lab 1 (Monday, 1 September) Don't print this from the Web – I'll hand out a hard copy.

Textbook: Database System Concepts, Fourth Edition by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan

ACM Curriculum 2001 Recommendations for the Database course


MySQL Documentation
PHP Documentation

(Ch. 2 has a brief tutorial)
Introduction to CVS
PostgreSQL Documentation

Using MySQL and PHP on Allegheny's webpub site

Zend.com PHP tutorials
WebMonkey PHP/MySQL Tutorial
DevShed PHP Tutorials
DevShed MySQL Tutorials
DevShed JavaScript Tutorials
PHPBuilder.com (articles, tutorials, etc.)
PHPHelp.com (supposedly for beginners)
PHP articles at the O'Reilly site
MySQL articles at the O'Reilly site
PHP/PostgreSQL tutorials
Database Journal MySQL/PostgreSQL Tutorials and Information

PostgeSQL language / plpgsql language reference

O'Reilly Safari bookshelf 14-day free offer

*include_once>http://us3.php.net/manual/en/function.include-once.php*

*require_once>http://us3.php.net/manual/en/function.require-once.php*

*header>http://us3.php.net/manual/en/function.header.php*

*session_start>http://us3.php.net/manual/en/function.session-start.php*

*session_unset>http://us3.php.net/manual/en/function.session-unset.php*

*session_destroy>http://us3.php.net/manual/en/function.session-destroy.php*

predefined variables
*mysql_connect>http://us3.php.net/manual/en/function.mysql-connect.php*

*mysql_pconnect>http://us3.php.net/manual/en/function.mysql-pconnect.php*

*mysql_select_db>http://us3.php.net/manual/en/function.mysql-select-db.php*

*mysql_query>http://us3.php.net/manual/en/function.mysql-query.php*

*mysql_fetch_array>http://us3.php.net/manual/en/function.mysql-fetch-array.php*

*mysql_close>http://us3.php.net/manual/en/function.mysql-close.php*


PERL DBI Tutorial
JDBC Basics Sun Tutorial
C# Database Connectivity Tutorial
MySQL JDBC interface
All MySQL functions

"Ten Security Checks for PHP, Part 1"

by Clancy Malcolm
"Ten Security Checks for PHP, Part 2" by Clancy Malcolm

"Form Validation on the Client Side" by Martin Tsachev
Javascript tutorial from W3Schools.com
The section devoted to forms validation
Form Validation by Paul Adams and Apple Developer Connection
form and Javascript form validation examples from javascriptkit.com
Javascript validation + PHP form processing from DevShed Forums

All PostgreSQL functions
PostgreSQL JDBC interface


"What Employers Want from Students: a Report from OOPSLA"

by Phil Pfeiffer (from SIGCSE Bulletin, 1999)

People (This page just barely under way!)