CSCC43: Introduction to Databases
Summer 2009


Course Content

Required Reading   |   Lecture Notes   |  Tutorial Notes

Required Readings

Topics
Database System Concepts
by A. Silberschatz et al.
Introduction Chapter 1
The relational model Section 2.1
Relational Algebra Sections 2.2 - 2.3
SQL Chapter 3
Sections 4.1-4.2, 4.4-4.5
XML/XPath/XQuery Sections 10.1-10.4
The ER model Sections 6.1 - 6.6
Relational database design Sections 7.1-7.5, 7.8

[Top]


Lectures

(Lecture slides are kindly provided by Ramona Truta and Prof. John Mylopoulos)

Week Date Notes
1 May 04 Introduction
2 May 11 Relational Model, Relational Algebra, RA Example 1
3 May 18 No Class (Victoria Day)
4 May 25 Relational Algebra (Cont'd), RA Example 2
5 June 01 SQL, Examples
6 June 08 Using SQL in an Application
7 June 15 SQL (Cont'd), Examples
8 June 22 Midterm
9 June 29 XML Query Languages (XPath Examples)
10 July 06 XML Query Languages (Cont'd) (XQuery Examples)
11 July 13 Conceptual Database Design
12 July 20 Relational Normalization Theory
13 July 27 Relational Normalization Theory (Cont'd)
14 Aug. 03 No Class (Civic Holiday)

UTSC 2009 Summer Seasonal Dates

[Top]


Tutorials

Week Date Notes
1 May 04 No Tutorial
2 May 11 Relational Model
3 May 18 No Tutorial (Victoria Day)
4 May 25 Relational Algebra, Latex
5 June 01 Simple SQL
6 June 08 PostgreSQL (sample db, sample queries), additional slides
7 June 15 Nested SQL, SQL summary
8 June 22 No Tutorial (Midterm)
9 June 29 XML
10 July 06 XPath, XQuery (Bookstore Example)
11 July 13 ER Modeling
12 July 20 ER to Relational Translation (summary of rules)
13 July 27 Functional Dependency
14 Aug. 03 No Class (Civic Holiday)

[Top]