Please note that a review of COMP9311 exam paper will be held next Monday 4 December 2017 from 1pm to 4pm in room K17-304 in Level 3 of K17 building (where CSE school is located).
Please do send me an email if you want to review/see your exam paper.
Please note that any student who got between 47 (inclusive) and 50 (exclusive) is eligible to sit for supplementary exam.
Please also note that anyone who got UF grade is also eligible to sit for supplementary exam. UF (Unsatisfactory Fail) means that the student got more than 50 overall but failed to get 24/60 in the final exam as it is clearly explained and described in the course outline.
The supplementary exam will be held next Wednesday 6 December 2017 @ 8.45am at Rex Vowels theatre and is managed by the school of CSE (Computer Science and Engineering). The school of CSE will send a notification to eligible students soon.
Finally, I am dealing with lots of queries and it will take time to deal with all of them. I am planning to get back to everyone by Monday 4th of December 2017.
Please note that Exam sample solution is now released. You can find it under Lectures/Week12 ( https://webcms3.cse.unsw.edu.au/COMP9311/17s2/reso... )
Please note that Assignment 3 sample solution is now released.
Please note that Assignment 2 sample solution is now released.
Please note that Assignment 3 is released.
I just checked Grieg and there are a very large number of PostgreSQL servers running, but (apparently) not a lot of people logged in to Grieg and using those servers. You were asked to shut down your PostgreSQL servers when not in use . It seems that some people aren't doing this. The effect is that people who want to work on their assignments can't, because some of you couldn't be bothered to do what we asked. I note that some people appear to be running multiple servers, with the worst offenders running 8 servers at once! A solution would be to kick everyone off grieg and re-boot it, but I'm sure you don't want that. The other solution is for people who aren't using their servers to shut them down . Thanks for your cooperation in this.
Please note that Assignment 1 (Stage 2) sample solution is now released.
Please note that Lab6 Solution about updates and trigeers is released.
Please note that Assignment 2 is released.
As promised, I uploaded the more detailed version of the PLpgSQL slides we went through some of its content in the lecture today as well as a video about PLpgSQL Functions. You can find them under Lectures/Week5.
Please note that Lab2 solution is released and three (3) videos related to SQL Queries and SQL Views are added under Lectures/Week 4.
Please note that Assignment 1 (Stage 2) is released.
I just added one video related to ER Design (Publishing exercise) as well as three videos related to Mapping ER Design to SQL under Lectures/Week 2. Please do go through them. Very useful to consolidate your knowledge in both topics and to be able to do your Assignment 1.
This is to let you know that I added the solution for Slide 25 of Lecture 2 as agreed on.
Please note that Assignment 1 (Stage 1) is released. You need to log in to WebCMS3 to be able to view it.
I just added three videos related to ER Design (the important topic we started discussing in class in Week1 Lecture) in the course website under Lectures. Please do go through them.
Welcome to COMP9311 (Database Systems).
See you all in our first lecture next Wednesday 26 July at 3pm in ChemScM17.