Database Systems: Main

Database Systems, Spring 2006

Instructor: Lisa N. Michaud
Email: lmichaud@wheatoncollege.edu
Office: Science Center, 106A
AIM: _____________________________

Lecture (118)	Monday / Wednesday	2:00pm-3:20pm
Office Hours (106A)	Monday	9:30-11:30am
	Tuesday	3:00-4:30pm
	(Other)	by appointment

Welcome to Computer Science 325, Database Systems.

ANNOUNCEMENTS - Last Updated: 12/3/06

Due Wednesday, December 6th:

HW #6, Transactions

Due Friday, December 8th:

Project #5, Inserting, Deleting, and Updating
Files for the extra credit options:
- an updated DBrecordForm.java that shows how to turn off editability
- a fragment to show how to use a JOptionPane to pop up a dialog to ask: do you really want to make this change?

GENERAL:

Remember to include the Wheaton Honor Pledge on all work in this course: I have abided by the Wheaton College Honor Code in this work. (signed with your name.

Click here for past assignments and handouts

OVERVIEW OF THE COURSE

In an age of information, it is crucial to understand how to design systems to manage and organize potentially large collections of data. This course involves an in-depth study of the issues involved in today's database management systems (DBMS). Topics include:

Theories behind database architecture (including the relational model, relational algebra, and relational calculus)
Database system design and implementation
Collection, organization, and retrieval of data through query languages such as SQL

This course will combine homework assignments on theoretical aspects of database design, and a series of large-scale programming assignments implementing the front end of a database of your own design in Java.

EMAIL POLICY

Information and announcements will be frequently communicated via email. It is the student's responsibility to check for email announcements on a regular basis throughout the week. Emails will usually be sent from the Blackboard system, so make certain the email address you have registered in Blackboard is the one at which you prefer to receive emails.

REQUIRED TEXTBOOK

The textbook for this class is Database Management Systems, by Ramakrishnan and Gehrke, Third Edition. Make certain you have the third edition!

COURSE WEBSITE

If you are viewing this text on paper, you may want to also check it out online at:

http://cs.wheatoncollege.edu/lmichaud/teaching/325/

The online version will be kept up-to-date with assignments and announcements.