CPSC 404: Advanced Relational Databases

To pass the course, you must pass the final and at least two of the 3 midterms.

There will be 3 homework assignments. Assignments should be submitted online from Canvas. Submissions are due NO LATER THAN 11:59 pm on the date they are due.

Penalty on late submissions will be 10% per day, i.e., if you submitted your homework a day after the deadline and your raw score was x%, you would instead get a score of 0.9 * x%. We will count time in the granularity of a day for gauging the lateness of a submission. E.g., for a homework due Sunday, 11:59 pm, submissions received from Monday 12:00 am until Monday 11:59 pm will be considered to be received "1 day late"; submissions received from Tuesday 12:00 am until Tuesday 11:59 pm will be considered to be received "2 days late"; etc.

SUBMISSIONS LATER THAN 2 DAYS WILL NOT BE ACCEPTED.

- as mentioned under "Policy", there will be 3 midterms.
- midterms will be held JOINT FOR BOTH SECTIONS 201 and 202 and WILL BE HELD IN THE EVENING on the days marked on course schedule (see "Welcome & Course Outline" Slide deck for details).
– midterm coverage will be incremental and up to last lecture of previous week.
– We will require you to sign an honor code.
– Absence from a midterm must be explained in advance.

- Final will be cumulative, i.e., will cover the whole course.

Here is a *copy* of the grading scheme from the Outline slide deck.


Clicker Questions 3%
In-class Activity 2%
3 HW assignments 10%
3 Midterms 3 x 15 = 45%
Final Exam 40%

In addition, you may earn free points for simply filling out midterm learning survey (aka midterm course eval).

For both iClickers and in-class activity, we will use the top-80% (i.e., the best 80%) of your marks for grading.

Please note that iClicker questions will not be published.

UBC provides resources to support student learning and to maintain healthy lifestyles but recognizes that sometimes crises arise and so there are additional resources to access including those for survivors of sexual violence. UBC values respect for the person and ideas of all members of the academic community. Harassment and discrimination are not tolerated nor is suppression of academic freedom. UBC provides appropriate accommodation for students with disabilities and for religious and cultural observances. UBC values academic honesty and students are expected to acknowledge the ideas generated by others and to uphold the highest academic standards in all of their actions. Details of the policies and how to access support are available here:

https://senate.ubc.ca/policies-resources-support-student-success

The intent of exercises assigned during in-class activity (ICA) is that they be completed during the class in which they are assigned, if possible. However, *you will have until 12:00 noon the day after the lecture to submit your work, on Canvas*. ICA exercises are expected to be solved in groups of size 3 or 4.