CSE 444: Introduction to Database Systems

Winter 2003

Course Information

Course syllabus

Homework Assignments

There are 5 homeworks, and a warm-up XML self-introduction
Note: Send the questionaire as an attachment (.xml) to Eric at likhan03@cs.washington.edu. Do not put questionaire under Message Text of the email. The file name should indicate your name, such as eric_chu.xml

Assignment	Topic	Due Date	Answers
Questionnaire	Tell us about yourself in XML	January 8	Sample XML file and code
Homework 1	SQL Queries	January 24	Answers
Homework 2	Conceptual Modeling and Normalization	February 10	Answers
Homework 3	XML	March 5	Answers
Homework 4	Query Execution & Optimization	March 12	Answers

Lecture Slides

Introduction to Database Systems January 6
SQL January 8
SQL and Project Issues January 10
More SQL January 13
Outerjoins, Schema Creation, and Views January 15
Views January 17
Constraints and Programming January 22
SQL Programming and Transactions January 24
Conceptual Database Design January 27
E/R Diagrams and Functional Dependencies January 29
Functional Dependencies January 31
Functional Dependencies February 3
Relational Decomposition and Relational Algebra February 5
Relational Algebra, Projects, XML February 7
XML February 10
Querying XML February 12
Web Services February 14
End of XML February 19
DBMS Internals February 24
Storage and Indexing February 26
Index (cont) February 28
Query Execution March 3-5
Query Optimization March 7
Query Optimization (cont) March 10
Query Optimizations and Perspectives March 12

Hyper mail Archive

To subscribe, visit http://mailman.cs.washington.edu/mailman/listinfo/cse444

Midterms