Course Content - CSCC43 Summer 2009

CSCC43: Introduction to Databases
Summer 2009

Course Content

Required Readings

Topics
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

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

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)