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.
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
Some Notes on Kent
How to Set Up Oracle
Ullman and Widom web page
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