COMP9311 Notices

Assignment 2 mark released

Posted by Xingyu Tan Tuesday 12 May 2026, 09:57:06 AM.

Hi Class,

The mark and sample solution for Assignment 2 have been released. You can check your mark in Moodle and find the sample solution in WebCMS3.

For any concerns regarding your mark, please contact your marking tutor through the email in the feedback comment by this Friday (15th May) .

Best regards,

Xingyu

Final Exam Tomorrow

Posted by Xiaoyang Wang Monday 04 May 2026, 09:37:57 AM.

Dear Students,

Please carefully read the following instructions regarding tomorrow’s final exam:

Location:

• Please check your assigned exam location through myUNSW. Ensure you arrive at the correct venue at correct time.
• Please bring your UNSW Student ID card.

Questions:

• There will be 6 questions, including the True/False question.
• Marks for each question will be clearly indicated on the exam paper.

Exam Scan:

• The exam will be scanned using ExamScan technology and converted to a digital format.
• Ensure you correctly fill in your ZID on the exam paper .

Writing:

• Write your answers ONLY on the exam paper with the question and QR code.
• There are additional pages at the end of the exam paper if you require more space.

Steps for Partial Marks:

• Always show your steps and reasoning whenever possible to receive partial marks.

Read Before Attempting:

• You are advised to read all questions first before starting your answers.

QR Code Area:

• Do not write in any part of the QR code area on the exam paper.

No notes are allowed during the exam. You can attempt the questions in any order, arrange your time wisely.

For MyExperience : The response rate is 74%! Well done class and thank you all for your collective effort. As promised, I will add 1 extra mark towards your final exam for everyone :-)

Finally, good luck to all of you!

Best regards,

Xiaoyang

Project mark released

Posted by Xingyu Tan Tuesday 21 April 2026, 01:39:43 PM.

Hi Class,

The mark and sample solution for the project have been released. You can check your mark in Moodle and find the sample solution in WebCMS3.

For any concerns regarding your mark, please contact your marking tutor through the email in the feedback comment by This Sunday (26 April) .

Best regards,

Xingyu

MyExperience and sample exam paper

Posted by Xiaoyang Wang Monday 20 April 2026, 02:32:12 PM.

Hi Students,

Two things here:

• Fill in the MyExperience survey, please. As advertised in the class, if the response rate from the class hits more than 50.0% , everybody gets 1 bonus mark added to the final exam mark :-)
• A sample exam paper and its solution have been released on WebCMS3 . Please note that the sample paper is just a reference. The final exam might have a different number of questions, scopes, and difficulty levels.

We will talk about the final exam in Thursday's lecture. See you!

Best regards

Xiaoyang

Assignment 2 released

Posted by Xingyu Tan Monday 06 April 2026, 01:59:00 PM.

Hello Class,

Assignment 2 has been released under the Assignment2 section. The deadline for the Assignment 2 is Sun. 20:59:59 26th April (Sydney Time).

Best regards,

Xingyu

Assignment 1 mark released

Posted by Xingyu Tan Wednesday 01 April 2026, 11:56:55 AM, last modified Wednesday 01 April 2026, 11:59:12 AM.

Hi Class,

The mark and sample solution for Assignment 1 have been released. You can check your mark in Moodle and find the sample solution in WebCMS3.

For any concerns regarding your mark, please contact your marking tutor through the email in the feedback comment on Moodle by the End of this Sunday (5th April) .

Best regards,

Xingyu

Project released

Posted by Xingyu Tan Monday 16 March 2026, 10:05:18 AM.

Hi Class,

The project has been released under the “Project” section. The deadline for the project is 20:59:59 Sun April 5th (Sydney Time) .

Tips:

• Familiarise yourself with the project database first. Before attempting the queries straight away, try to examine what each relation holds and find out how relations might be related to each other.
• Set up the project database ASAP so the tutors can assist you with any related issues.
• Make sure that your solution can load and run correctly. You can check your answers using check.sql.

Best regards,

Xingyu

Assignment 1 released (and also the first lab and practice)

Posted by Xingyu Tan Monday 23 February 2026, 08:46:20 AM.

Hello Class,

Assignment 1 has been released under the Assignment1 section. The deadline for assignment 1 is Sun 20:59:59 15th March (Sydney Time).

The first lab material has been released under the Labs section. We also provide a demo video that helps you go through the setup procedure.

Practice 1 has been released with solutions under the Practices section. It is about ER and the relational model.

Best regards,

Xingyu

Welcome to COMP9311 26T1

Posted by Xiaoyang Wang Saturday 14 February 2026, 01:47:35 PM.

Hi Class,

Welcome to the course COMP9311! I hope you look forward to learning about database systems. In this opening notice, I outline how the course will run in T1 2026.

Course Webpages We manage the course with WebCMS3 and Moodle . If you’re reading this notice, congrats, you’ve found us. All announcements, lecture notes, lab notes, assignment specs, etc, are going to be posted here. Moodle is used to provide access to online live lectures, lecture recordings, and assignment/project submissions.

Lecture The lectures will be delivered in person on Tue/Thu. There will also be online streaming lectures via Blackboard Collaborate at the same time. You can find the online stream link in Moodle.

Lecture Recording All lectures will be recorded and uploaded onto Echo360, which can be found through the links (Lecture Recordings) in Moodle.

Lab Labs start from Week 2. Due to the limited space of school labs, we have to run BYOD labs face-to-face in classrooms. So you need to bring your own laptop. During the lab, a tutor will be present to assist you and answer questions.

Consultation Weekly consultation will be presented online via Blackboard Collaborate from Week 1. You may join the consultation if you have any questions regarding the course.

Discussion Forum You can also ask questions through the course forum. The forum link and instructions are linked on the WebCMS3 menu .

Exam The currently plan is in-person exam. If you cannot sit the offline exam, do not take the course.

Other than that ... nothing much you need to do until you see me on Tuesday!

Best of luck, and I look forward to meeting you all next week!

Xiaoyang Wang