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
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
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.