LECTURE SLIDES (adapted from book slides)

Note: these  slides are a class reference - they do not intend to cover all book or class material. Exams may include topics that are not in the slides. If  you need pdf's, the books' web sites provide slides  similars to the course's slides, in ps or pdf.

Lecture #1 - Introduction

Lecture #1/2 - E/R modeling

Lecture #3 - The relational model

Tutorial Notes #1

Tutorial Notes #2

Lecture #4 - Relational Algebra(ppt)
pdf -2 slides/page  pdf 4 slides/page

Tutorial Notes #3

Lecture   #5 -  SQL (ppt)
pdf -2 slides/pagepdf 4 slides/page

Lecture   #6 - Embedded  SQL (ppt)

Lecture # 7 - Assertions and Triggers & Intro to FD's

Lectures # 8 and 9 - Functional dependencies

Lecture10 - Functional dependencies

Tutorial Notes #4

Tutorial Notes #5

Lecture # 11 - Multivalued dependencies

Lecture # 9 - Additional slides

Tutorial7

Tutorial 8

Tutorial 9

Tutorial 9 solutions