CS 387 - Database Design

CS 387

Database Design

Quick Links

General:

Course Information/Syllabus (PDF) - (HTML)
Guidelines for All Assignments (PDF) - (HTML)
Book:

Databases and transaction processing - An application-oriented approach, Philip M. Lewis, Arthur Bernstein and Michael Kifer, Addison Wesley, ISBN 0-201-70872-8.
Book web page:

Not yet available by publisher.
Lecture notes:

Lectures notes from the book and additional notes.

Lectures			Sections in book
Num/Name	PPT	PDF	Readings
Presentation of the course		4PDF
1 - Introduction	PPT		Chapter 1
2 - Foundations (sets, relations...)		4PDF
3 - A closer look	PPT		Chapter 2
4 - Entity relationship model	PPT		Chapter 5
5 - Relational data model	PPT		Chapter 4
6 - Relational algebra and SQL	PPT		Chapter 6
7 - Relational normalization theory (light version)	PPT		Chapter 8
8 - Physical Data Organization and Indexing	PPT		Chapter 11
9 - XML and Web Data (light version)	PPT		Chapter 17
10 - Security and Internet Commerce	PPT		Chapter 27

Practical exercises:

Look in Blackboard.

Other books:

Database Management Systems - Ramakrishnan (McGraw-Hill) Fundamentals of Database Management Systems - Elmasri and Navathe (Addison Wesley)

Software references:

DBMS
- Oracle
- Error numbers in Oracle

PL/SQL
- SQL*PLUS tutorial
- SQL tutorial

UNIX
- UNIX tutorial

JAVA

JDBC
- JDBC on matrix - Look in Blackboard.
- Sunsoft JDBC Homepage
- JDBC Enhancements
- The JDBC Specification
- JavaSoft's JDBC API specification

Servlets
- Servlets on matrix - Look in Blackboard.