[UofT CS Dept]

[UofT DB Group]

343 Introduction to Databases

Section L5201

Course Description

Concepts, approaches, and techniques in data base management systems (DBMS): relational data bases, querying and updating a data base, query language SQL, data base constraints and data base design, elements of data base technology.

Prerequisites: CS263H1/265H1(228H1,238H1)/378H1; CGPA 3.0 proficiency in C

Summer 2003

Instructor: Laurent Mignet
Email: mignet@cs.toronto.edu
Room: BA 5222
Office hours: Tuesday 6:00pm - 8:00pm Cancelled Tuesday, July 29th 2003

Class meets: Thursdays 7-9pm, BA 1190
Tutorials: BA 2135 & BA 2175 & BA2185

Tutors:
   Solmaz Kolahi
   Daniela Rosu
   Miles Trochesset

Tutorial Group:
[A-H]: Room BA 2135
[I-Z]: Room BA 2175

DB2:


Newsgroup: ut.cdf.csc343h

Requirements: Assigments (45%), Midterm (15%), Final exam (40%)

Syllabus (last updated May 12th)

Announcements (last updated May 27th)

Where is L5101 section?

Assignments


Slides
Set 1: Introduction                                         (2 slides per page)     (4 slides per page)     Tutorial
Set 2: Entity-Relationship model                                         (2 slides per page)     (4 slides per page)     Tutorial
Set 3: Relational Model                                         (2 slides per page)     (4 slides per page)     Tutorial
Set 4: Relational algebra                                         (2 slides per page)     (4 slides per page)     Tutorial (Questions)     Tutorial (Solution)
Set 5: SQL                                         (2 slides per page)     (4 slides per page)     Tutorial
Set 6: Embedded SQL                                         (2 slides per page)     (4 slides per page)     Tutorial
Set 7: Functional Dependencies                                         (Last Update July 24th 2003 )
Set 8: Assertion and Trigger                                         (2 slides per pages)     (4 slides per page)
Course Review
Remarks
Email The simpler your message, the faster it will be answered: in general, if you send an email you SHOULD put "CS 343" in the subject field before any other words. Sending a query/program formatted as one line and asking "what's wrong with it?" is unlikely to be answered, ever (even by a TA). Sending html (modern email are especially guilty of that) is also unlikely to result in an answer.



Note: To create the differents materials involved in this course I used these very useful site: