ANNOUNCEMENTS FOR CSC343, FALL 2003

  9/10. Some dates and locations have been corrected in the syllabus. 

  9/17. The second tutorial room is BA1130, not SF1101 as previously announced.

  9/18. Hw1 has been posted on the course webpage.

  9/27. Official partial credit policy has been posted.

  9/29. We now have a link to some (but not all) tutorial questions.

  9/29. Textbook reading: 
           relational algebra/basic SQL: Ch 5 (sect. 5.1, 5.2) and Ch 6
               (sect. 6.1, 6.2, 6.3) in parellel; 
            Ch 10 (10.1, 10.2) for rule-based queries. 
            SQL (data types, modification, aggregation): the erst of Ch 6
            embedded SQL: 8.1, 8.6, recursion: 10.3, 10.4
            dependencies and design: 3.4-3.7, 
            constraints in SQL: chapter 7.
            query processing: Ch 15
            concurrency control: 18.1-18.3

  9/30. Additional office hours: Oct 1, 3-5pm, SF3207.

  10/5. Test 1 coverage: all the material covered in the first 4 lectures.

  10/6. Additional office hours: Tue October 7, 5-6pm, SF3207

  10/13. HW1 remarking office hours: Wed October 15, 3-5pm, SF3207.

  10/16. HW2 and db2 instructions are now available on the webpage. 

  10/16. Additional remarking office hours for HW1:
         Tuesday October 21, 12noon-1pm, SF3207

  10/17. Important db2 announcements:
 
         a) the disk partition where the database is located is not backed up.
            It is important that you store all your programs in a place that is
            being backed up nightly (your home directory).

         b) you can only work on db2srv1, db2srv2, db2srv3, according to the
            algorithm explained on the webpage. If you use a wrong server, or if
            you use db2.cdf, your mark will be reduced by 20%.

  10/30. Test 1 remarking office hours: Friday Oct 31, 3-4pm, SF3207.

  10/31. Test 2 coverage: Sets 1, 2 and 3 of lecture notes.

  10/31. Additional office hours, for both test 2, and test 1 remarking:
             Wednesday Nov 5, 4-5pm, SF3207.

  11/06. HW3 has been posted.

  11/12. HW2 remarking office hours: Tue Nov 18, 5-6pm, PT378.

  11/25. Test 2 remarking office hours: Thu Nov 27, 3-4pm, BA7162.

  12/2.  Remarking office hours:

         Friday Dec 5, 3-5pm, PT378 (test2 + test3 + hw3)
         Tuesday Dec 9, 11-12:30, PT378 (test3 + hw3)

  12/9, 17:00. Unofficial final marks have been posted. 
        No additional remarking requests will be considered.