September 12th:

• The lecture will be held in MC 102 starting September 17th
• The first term test on October 8th will be held in MS 3154 from 6:00 pm to 7:00 pm
• The second term test on November 5th will be held from 6:00 pm to 7:00 pm in:
  • [A-O]: MP 102
  • [P-Z]: MP 103
• Message posted in the newsgroup regarding A1:

  It seems that you have some question about the database design, and it was true because of one mistake that I did. So in order to solve this problem you just have to add one attribute in the Hall table: province. Therefore the schema is: City (name, province, country). The primary key of the relation is composed by City, Province. Hall (name, city, province, capacity). Primary Key: name Foreign Key (city, province) references the primary key in City (name, province) Show (title, artist, hall, attendance) same that before. We understand that you already answered some questions using the previous schema and positional notation in R.A, or R.C; so please write before each question the schema for the relation "Hall" that you used to avoid any confusions. Sorry about that, Laurent

• Tuesday Nov. 25th no office hour Wednesday Nov. 26th no office hour