CSCC43 Introduction to Databases (Sum 11, Sum 08)

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

Sample Questions + Solution

Related Links

PostgreSQL + PG Admin
ER Modeling Tools
Interactive SQL tutorial
XML/XPath Evaluator