1/1/07: Unofficial course marks.
23/10/06: Marks for the project are ready. I still need to enter some changes due to remarking requests.
20/12/06: The two best projects are (they both get 1st place):
1) Group 3:
Edward Lam,
Erek Barsczewski, and
Waseem Maolah
2) Group 6: Prashanthi Nadarajah, Hwa Young Kim, and Ding Cai
16/12/06: A sample exam. Note that there are no multiple choice questions in this year's exam.
Note: the two projects were too close to call, though Group 6 had a small advance.
07/12/06: Here are the bookings for your demo.
04/12/06: Chapters and Secctions to read for the exam:
04/12/06: Since our exam is one of the latest ones, I extend the due date for A2 by 2 more days. So the new due date for A2 is next Thursday, DEc 7.
As for the project due date, I will arrange things with the TA so that he can reserve 4 different days spread between next Friday and the Friday next week to accomodate everyone. I will announce those days/times by Wednesday. So anyone who is ready to present will indicate when (s)he wants to do so.
23/11/06: For those who could not attend yesterday's tutorial, there is a 2nd tutorial today between 1PM and 2PM in STE0131.
20/11/06: Mohamed Mansour will give you a one hour tutorial on his handson experience in writing web-based database applications partly acquired in a past CSI3317 class and extensive practice.
The tutorial will be held on wednesday, nov. 22 in STE 0131, 4-5PM.
Make sure that each group delegates at least one representative to ask question you may have. Off course, those group that do not need the tutorial can skip it.
18/11/06:
13/11/06: For the project, the VERY first thing to do is to read the appropriate sections of chapters 6 and 7. Then read the runing example in the book (The Internet Book Shop example presented in Chapters 2-7), particularly in Chapter 7.
07/11/06:
01/11/06:
Midterm:
25/10/06:
Please submit your deliverable 1 both electronically and in hard copy by
the due date. Email your script as a text document to
Yonglin (Yren009@site.uottawa.ca) and submit the hard copy in the
assignment box.
23/10/06:
22/10/06/: Some of you noticed that the Relational Algebra
and the SQL sections in the sample midterm that I gave you a few days ago
did not match the given schema. I can't find in my
archives the matching midterm. So take the following
solutions for another old midterm
to help you study the material:
p1,
p2,
p3,
p4,
p5.
21/10/06/: Solutions for Assignment 1:
p1,
p2,
p3,
p4,
p5,
p6,
p7,
p8,
p9,
p10 (JPEG). 21/10/06: A copy of complete solutions for Assignment 1 is left
outside of my office for you to make your own copy. So when you
make a copy, BRING THE ORIGINAL BACK for others to make copies.
19/10/06: Here are important announcements about the midterm:
For the exam, learn:
Break down of questions:
19/10/06:
An old
midterm exam
with solutions:
p1,
p2,
p3,
p4,
p5.
19/10/06/: As a preparation for the midterm, you may
read the solutions for last year's Assignment 1
(except the trigger):
p1,
p2,
p3,
p4,
p5,
p6,
p7,
p8,
p9,
p10 (GIF). 16/10/06: Tomorrow's course is cancelled. I am on the
conference and did not find a replacement. Please do use the office hour
on Friday. I will post several exercises to do as a preparation for
the midterm.
13/10/06: The ER diagram of the question 1 of last year's
assignment 1 that we solved today in class is posted
here.
11/10/06: New due dates for the course work:
A1 (Tuesday Oct 17, at 6PM) and the
first part of the project (Friday Oct 27 at 6PM).
03/10/06: Midterm date: Oct 24, 2006 (in class).
02/10/06: TERM PROJECT.
25/09/06: Assignment 1. To be done in
groups of 2.
19/09/06: Project
groups. Please let me know of any possible error.
06/09/06:
IMPORTANT MESSAGE: FIRST DAY OF CLASSES WILL BE TUESDAY SEPT. 12.
This is necessary for synchronizing with the French section that starts
only next week.
02/09/06:
Since the PDADMIN interface has evolved recently, some may still be having
problems with it. What is required now is a script that would run on any
of DB2, Oracle, MySQL, or PostgresSQL.
I will post scanned pages later today for you.
I am in SITE Monday at noon for any eventual questions.
Chap 3: Sections 3.1--3.5, and 3.7;
Chap 4: Sections 4.1, 4.2, and 4.3.2 (domain relational
calculus ONLY for students that are CSI and MATH students);
Chap 5: Sections 5.1--5.5, and 5.7.
ER diagram: 30%;
Rel. model: 20%;
SQL Queries and constraints: 20%;
Rel. algebra and calculus: 20% (The rel. calc. will be short,
and Management will only get algebra questions).
Tomorrow, I will post solutions for this year's Assignment 1 that the TA is
now marking. Note that exercises at the end of chapters are also a good
preparation to the exam.
I will announce on monday whether the class on next tuesday must be cancelled
or not. In case I cancel that class (due to a conference), I will hold
an office hour on Friday between 11AM and 1PM.
On Tuesday next week, I will be away for a conference and will try to arrange a
replacement if possible.