CSE 444: Introduction to Database Systems
Winter 2004
Recent Announcements
[2/18/04] You have been given a 24 hour extension on phase II. It is now due at 11:59pm on Thursday February 19.
Course Information
Course syllabus
Daily schedule
Project information
Project support page
Mailing List
Pictures
Newsgroup
Homework Assignments
There will be 4 homeworks.
Assignment
Topic
Due Date
Answers
Homework 1
SQL Queries
January 20
Homework 2
Conceptual Modeling and Normalization
February 6
Homework 3
XML
March 3
Homework 4
Query Execution & Optimization
March 12
Lecture Slides
Introduction to Database Systems
January 5
Beginning SQL
January 7
More SQL
January 9 and 12
Conceptual Modeling
January 14
Conceptual Modeling and schema design
January 21
Views
January 30
Phase 2, more on views, constraints and triggers.
February 2-4.
end of SQL
February 6.
end of transactions, relational algebra
February 6.
More XML
February 18.
XQuery
February 23.
End of XQuery; DBMS internals
February 25.
DBMS internals -- storage
--> -- February 27.
Hash indexes and query execution
March 1-3.
Query optimization
March 5-10th.
Midterms from previous offerings
Final in Spring 2002
and
its solution
Midterm in Spring 2002
and
its solution
Midterm in Autumn 1999
Midterm in Autumn 1998
and
its solution