|
Date | Topic with Link to Lecture Notes | Assignment | Project | Readings (*) |
---|---|---|---|---|
Wed. April 3 | Introductory Material | - | - | 1, and: SQL for Web Nerds: Introduction |
Mon. April 8 | Data: Relations and XML (and some follow-up notes) | - | - | 3.1, 6.6.1-6.6.4, 4.7, XML in 10 Points |
Tue. April 9 | CGI Help Session | - | - | - |
Wed. April 10 | Relational Algebra and SQL: Queries and Updates | #1 assigned | Part 1 assigned | 5.1-5.2, 6.1-6.5, optional: SQL for Web Nerds: Queries and Complex Queries |
Mon. April 15 | SQL Queries and Updates (cont'd) | - | - | 8.1-8.5 (**) |
Tue. April 16 | Programming with SQL (help session) | - | - | - |
Wed. April 17 | XML Queries: XPath and XQuery (and some follow-up notes) | #1 due #2 assigned | Part 1 due Part 2 assigned | Introducing XSLT and XPath (start at "How XPath Works"), An Introduction to XQuery, (just the shaded box), XQuery: Reinventing the Wheel? (ignore XSLT), optional: XPath Specification, XQuery Specification |
Mon. April 22 | Relational Database Design | - | - | 3.4-3.7 |
Wed. April 24 | Relational Design (cont'd) | #2 due #3 assigned | Part 2 due Part 3 assigned | " |
Thu. April 25 | XML Parsing Help Session | - | - | - |
Mon. April 29 | Indexes, Views | - | - | 6.6.5-6.6.6, 6.7, optional: SQL for Web Nerds: Views |
Wed. May 1 | Design Models: E/R and OO | #3 due #4 assigned | Part 3 due | 2, 4.1-4.3 |
Mon. May 6 | MIDTERM EXAM | - | - | - |
Wed. May 8 | Translating High-Level Designs | #4 due #5 assigned | Part 4 assigned | 3.2-3.3, 4.4 |
Mon. May 13 | Transactions | - | - | 8.6 |
Wed. May 15 | Authorization, Constraints and Triggers | #5 due #6 assigned | Part 4 due Parts 5 & 6 assigned | 8.7, 7, optional: SQL for Web Nerds: Triggers |
Mon. May 20 | Triggers (cont'd), Recursion | - | - | 10.4 |
Wed. May 22 | Object-Relational SQL, Temporal Databases (and some follow-up notes) | #6 due #7 assigned | Part 5 due | 4.5, 9.4-9.5 |
Mon. May 27 | HOLIDAY | - | - | - |
Wed. May 29 | Data Warehousing and Data Mining | #7 due #8 assigned | Part 6 due | "On-Line Analytical Processing and Data Cubes" (in postscript or pdf), SQL for Web Nerds: Data Warehousing |
Mon. June 3 | XSLT, XML Schema | - | - | Transforming XML Data with XSLT, XML Bible: XSL Transformations (***), optional: XSLT Specification, XML Schema Specification |
Wed. June 5 | Course evals, project demos, wrap-up, refreshments | #8 due | - | - |
Wed. June 12 | FINAL EXAM 9:30-11:30 AM, Cubberly Auditorium School of Education, 485 Lasuen Mall | - | - | - |
(*) All numbers in this column refer to chapters or sections of the course textbook - A First Course in Database Systems, Second Edition or Database Systems: The Complete Book. See Books in the Administrative Information page for more information.
(**) Required reading even though material will not be covered in lecture.
(***) We suggest skipping all of the material on systems and architectural issues as well as everything resembling XPath.