Dear students,
Please aware that according to the course policy, there is no supplementary exam for the students who have attended the final exam even if you have failed this course.
If you failed this course, please retake it in later terms and work harder next time.
For any other issues, please contact the course email comp9311unsw@gmail.com .
Best wishes on your academic life!
There is a clarification of the lecture slide.
Definition (Second Normal Form): A relation scheme is in second normal form (2NF) if all non-prime attributes are fully functionally dependent on the candidate keys.
The relation keys here mean candidate keys, and we update the slides to make it clear
The affected slides have been updated.
Dear students,
There is a mistake in the provided assignment 1 sample solution. The derived attributed 'Number of Artists' should be an attribute of the entity 'company'.
During the marking, we have recognised this and mark it right. We have updated the sample solution.
In the exam, please follow this rule if facing similar situations.
Marks and sample solution for Assignment 3 have been released. To check your mark with comments, you can go to the website https://cgi.cse.unsw.edu.au/~give/Student/give.php and click the button ‘marks’ on top of the page.
For any concerns about your mark, please contact your marking tutor through the email given in the comments.
If you have submitted your assignment but do not get any mark, please email comp9311unsw@gmail.com as soon as possible.
The ODL which appears in the sample exam paper is not covered in this semester and thus will not be included in the final exam as well. You can just ignore it, and sorry for the confusion caused.
Marks and sample solution for Project 1 have been released. To check your mark with comments, you can go to the website https://cgi.cse.unsw.edu.au/~give/Student/give.php and click the button ‘marks’ on top of the page.
For any concerns about your mark, you should test your proj1.sql file once more on Grieg Server and take a screenshot of the output. As you are asked in the Project description to check and test your code before submission, you are responsible for your syntax errors, and we will not accept any argues about this case. If you still think you have been marked wrong, please contact your marking tutor through the email given in the comments with this screenshot.
If you have submitted your assignment but do not get any mark, please email comp9311unsw@gmail.com as soon as possible.
The consultation arrangement before the exam is as follows:
Mon 29 April, 5pm – 6pm at K17-201B
Tue 30 April, 5pm – 6pm at K17-201B
Wed 01 May, 5pm – 6pm at K17-201B
Thu 02 May, 1pm – 3pm at K17-201B
Fri 03 May, 3pm – 6pm at K17-201B
Marks and sample solution for Assignment 2 have been released. To check your mark with comments, you can go to the website https://cgi.cse.unsw.edu.au/~give/Student/give.php and click the button ‘marks’ on top of the page.
For any concerns about your mark, please contact your marking tutor through the email given in the comments.
If you have submitted your assignment but do not get any mark, please email comp9311unsw@gmail.com as soon as possible.
In order to protect your submission, please follow the steps in https://webcms3.cse.unsw.edu.au/COMP9311/19T1/reso...
to take a screen shot with both your submission time and file size . In addition, you should keep a copy of your submission in the CSE Server . Please remember to do these for any project or assignments. For any personal issues about this course, please contact the course email mailto:comp9311unsw@gmail.com
Marks and sample solution for Assignment 1 have been released. To check your mark with comments, you can go to the website https://cgi.cse.unsw.edu.au/~give/Student/give.php and click the button ‘marks’ on top of the page.
For any concerns about your mark, please contact your marking tutor through the email given in the comments.
If you have submitted your assignment but do not get any mark, please email comp9311unsw@gmail.com as soon as possible.
Please get lecture notes on this site by yourself. Usually I will upload them by Monday.