CSE 444: Introduction to Database Systems

Autumn 1999

Course Information

• Daily schedule
• Course syllabus
• Project information
• Class Members with information about if they're in a group.

Homework Assignments

Assignment	Topic	Due Date	Answers
Homework one	E/R diagrams	Due October 8	Answers
Homework two	Functional Dependencies	Due October 20	Answers
Homework three	SQL	Due October 29	Answers
Homework 4	Datalog	Due November 8	Answers
Homework 5	Interfacing with Java to SQL	Due November 17	No sample solution for code. If you have questions, e-mail me.
Homework 6	Triggers, constraints, database internals	December 3	Answers

Lecture Slides

• Introduction September 27
• ODL and Entity Relation Diagrams September 29
• ER continued, constraintsOctober 1
• constraints, ER ->relational model October 4
• Function dependenciesOctober 6
• Functional dependencies (cont.) October 8
• More functional dependencies and relational algebra October 11
• Relational Algebra October 13
• Relational algebra to SQL October 15
• SQL October 18
• SQL cont. (including aggregation) October 22
• Views and datalog October 25
• Datalog October 29
• Datalog, Constraints, the Midterm November 1
• Embedded SQL and Triggers November 5
• DBMS overview November 10
• ODBC November 10
• DBMS overview continued November 12
• JDBC November 12
• System Overview and Memory Management November 15
• Storage cont. and Indexing November 17
• Indexing cont. and Execution November 19
• Execution November 22
• Optimization November 29
• Optimization cont. December 1
• XML December 6.

Hypermail Archive

Midterms