CSCE 520 -- Summer 2008


The following material is from Spring 2008 and will be updated soon.


April 25, 2008

IMPORTANT FINAL EXAM NOTE: The final examination is scheduled (by the University) for 2 pm on Wednesday April 30, not 9 am. I apologize for handing out the wrong time. It is generally, but obviously not always, the case that morning classes have morning exams and afternoon classes have afternoon exams.

You may omit Part 3.3 (programming language interface) from your project. If you do implement this part of the project, it will be extra credit.

The drop box for the final project is now available. It closes Wednesday, April 30, just before midnight.

April 23, 2008

The final examination study guide link has been added to this web page.

I asked Dr. Matthews to announce that the final project due date was to be extended to the date of the final examination. I forgot to mention this on Tuesday.

April 7, 2008

Jewel Rogers has the graded assignments, if you want to pick them up before the exam tomorrow. Kimberly Yonce will be giving the exam and will pick them up to bring to class.

April 3, 2008

The links for the project assignment and the exam study guide have been reinstalled. Let me know if there are further problems.

March 21, 2008

The dropbox for Assignment 3 has been created. Note the extension to the deadline, which is now Monday, March 24.

March 4, 2008

Minor change to grading formula for course: 10% for each of two midterm examinations will be replaced by 20% for maximum grade on a midterm.

February 20, 2008

The CSE web site has a short Oracle tutorial.

Administrative Information

Course Outcomes




Assignment 1

Assignment 2

Assignment 3

Assignment 4



Quiz 1



Project Assignment



Fall 2004 Midterm Exam 1

Fall 2004 Midterm Exam 2

Fall 2004 Final Exam

Fall 2007 Midterm Exam

First Examination Study Guide

Second Examination Study Guide

Final Examination Study Guide


Other Handouts

Some Notes on Kent

How to Set Up Oracle


Useful Links


Ullman and Widom web page


Lecture Notes

Chapter 1: Introduction

Chapter 2: The Relational Model and Relational Algebra

Chapter 3: Design Theory for Relational Databases

Chapter 3: Multivalued Dependencies

Chapter 4: The Entity-Relationship Model

Chapter 4: UML and ODL

Chapter 5: Extended Relational Algebra

Chapter 6: Introduction to SQL

Chapter 7: Constraints and Triggers

Chapter 8: Transactions, Views, and Indexes

Chapter 9: SQL Programming

Chapter 9: Database Connection Libraries

Chapter 10: SQL Authorization

Chapter 10: Datalog

Chapter 10: Object-Relational Databases

Chapter 10: On-line Application Processing (OLAP)

Chapter 10: Information Integration

Chapter 11: XML Databases

Chapter 12: Query Languages for XML Databases