University of Toronto - St. George

CSC343-- Introduction to Databases

Summer 2003
 

Instructors
 

Laurent Mignet  (L5201), lecturer. Office BA5222, electronic mail mignet@cs.toronto.edu.
lectures : thursdays, 7-9 pm. Office hours:
Alejandro Vaisman(L5101) , lecturer. tuesdays 7-9 pm Office BA4249, electronic mail avaisman@cs.toronto.edu.
Office hours: Wednesdays 6-7 pm at  BA4249
 
 
 

Meeting times
 
 

Tutorial 1: Tuesdays BA 3012 - Edward Xia

Tutorial 2:  Tuesdays BA 3000 - Lei Jiang

Tutorial 3: Tuesdays BA 3004 -  Vladimir Surkov

Tutorial 4:  Tuesdays BA 3008 -  Chaofa Gao

Tutorial 5:  Thusrdays  - BA 2135 - Miles Trochesset

Tutorial 6:  Thusrdays  - BA 2175 - Solmaz Kolahi

All tutorials:  6 - 7 pm.

News

Latest course news
 

Newsgroup: ut.cdf.csc343h - Please, post your questions to the newsgroup. If you have personal questions
 to discuss, ask for an appointment or come to my office  during office hours. I will NOT answer questions
 via e-mail.

Course web site

http://www.cs.toronto.edu/~avaisman/cscd34summer/csc343.htm

Make sure you monitor this site frequently for announcements. All handouts and assignments will also be available here.
 

References

Calendar

Lecture 1 - May 13 th - Introduction - Entity/Relationship model
Lecture 2 - May 20 th - Entity/Relationship model - Relational model - E/R - relational mapping
Lecture 3 - May 27 th - Relational algebra
Lecture 4 - June 3rd - Relational Algebra - Relational calculus - SQL
Lecture 5 - June 10 th - SQL
Lecture 6 - June 17 th - SQL - embedded SQL
Lecture 7 - June 24 th - Midterm exam.
Lecture 8 - July 1st - University closed.
Lecture 9 - July 8th - Relational theory - Functional dependencies
Lecture 10 - July 15 th - Lossless join decomposition - Dependency - preserving decompositions - Minimal covers
Lecture 11 - July 22 nd - Normal forms.
Lecture 12 - July 29 th - Multivalued Dependencies. 4NF
Lecture 13 - August 5 th - Course wrap-up / review.

Updated July 29th, 2003

Grading scheme
 

Note: To pass this course, you must receive at least 40% on the final exam  and at least 50% overall on the term mark (assignments plus mid-term test).
 
Assignments 45%
Mid-term test 15%
Final exam 40%
  100%

Assignments and exams

Unless otherwise announced, assignments will be due at 9PM on the day indicated. Due dates below are tentative and subject to change.


 

Item Due date Weight Comment
Assignment 1 June 9th 15%  
Midterm test June 24th 7pm 15% 1.5 hour exam 
Assignment 2 July 7th 15%  
Assignment 3 July 28 th 15%  
Final exam 40% 2 hour exam

 Only the programming/SQL part of the assignments can be submitted electronically.
 Late assignments will have a 20% penalty per day.
Assignments will be marked for correctness and presentation. Please type (preferably) or write legibly.
Illegible answers will not be marked.  Please,  do NOT use pencil.
Assignments must be submitted in a folder/envelope with the name and student #. For the "paper" part of your submissions,
there is a csc343 drop box next to the LP/SF bridge, on the SF side.
No aids (books, notes, etc.) will be allowed to use in  the exams.
Assignments questions must be answered individually. If you discuss the problems with other students, you must acknowledge this help.
Not doing this constitutes academic dishonesty and will be treated as such. We do reserve the right to give less than full credit in
circumstances where it appears that there has been large-scale division of labor.
Take into account that we may ask ask you some questions regarding the assigment,
in order to confirm that you understand what you have written. Your answers will constitute a part of   the assignment's marking.