Administrative Docs and Links
Course Info Sheet
Policy on Collaboration
The Portal!
UTSC Calendar
UoT – Medical Certificate
Current UTSC CSMS Courses
References
A First Course in Database Systems by Ullman & Widom
Course Schedule and Notes
Lecture 1: Intro
Lecture 2: ER model
Lecture 3: Relational Algebra & Calculus, Handout: RA, Handout: Company Tbls, Handout: Library Tbls
Lecture 4: SQL Intro, SQL types
Lecture 5: Constraints, Triggers, Cascades, Drop, Insert, Handout: examples
Lecture 6: Joins, Group by, having, where, Handout: examples
Lecture 7: Views, Insert, Delete, Trigger
Lecture 8: Functional Dependency
Lecture 9: Normalization, JDBC, Transactions, Normalization Examples
Lecture 10: Authorization, Grant Diagrams
Lecture 11: Embedded SQL, PL/SQL, Stored Procedures
Lecture 12: XML, XPath, XQuery, Index
Lecture 13: Review
Assignments
Assignment Cover Sheet
Assignment Coding Guidelines
Assignment/Midterm Remark Form
Relational Algebra Symbols
A1: ER Diagram, Relational Schema, Relational Algebra
A2: SQL
A2: Solution
A3: Stored procedures, XPath
Midterm/Exam
Related Links
PostgreSQL + PG Admin
ER Modeling Tools
Interactive SQL tutorial
XML/XPath Evaluator