Database Systems COMP9311 19T1
Notices
-
About Final Results
Posted by Chenji Huang Friday 24 May 2019, 10:09:40 PM, last modified Friday 24 May 2019, 10:45:14 PM.
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!
-
Update on Second Normal Form Definition
Posted by Chenji Huang Friday 03 May 2019, 05:08:45 PM, last modified Friday 03 May 2019, 05:49:50 PM.
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.
-
Mistake in assignment 1 sample solution
Posted by Chenji Huang Friday 03 May 2019, 04:15:05 PM.
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.