COMP9311 Notices

External Question Booklet Usage during Exam

Posted by Xingyu Tan 5 days ago.

Dear class,

If you requested additional scratch sheets from an invigilator as the external question booklet and wrote any part of your final answer on those sheets during yesterday’s examination , please email me by tomorrow night .

Your message must include your full name, your zID, the examination room where you sat the test, and the question number.

Thank you for your cooperation.

Best regards,
Xingyu

75% response rate

Posted by Xiaoyang Wang 6 days ago.

Well done class and thank you all for your collective effort. As promised, I will add 1 extra mark towards your final mark for everyone :-)

Best regards,

Xiaoyang

Final Exam Tomorrow

Posted by Xiaoyang Wang 7 days ago.

Dear Students,

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

Location:

• Please check your assigned exam location through the email from the school. Ensure you arrive at the correct venue at correct time.
• Please bring your identification, e.g. a valid UNSW Student ID card, driver's license, or passport (physical copy)

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 digital format.
• Ensure you correctly fill out your ZID on the exam paper .

Writing:

• Write your answers ONLY on the exam paper with the question and QR code.
• Scrap/scratch paper (probably normal A4 printing paper) will NOT be scanned or marked. DO NOT WRITE YOUR ANSWRS ON IT .
• Answers must be written in ink. However, pencils may be used for drawing and sketching.

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 section on the exam paper.

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

Finally, good luck to all of you!

Best regards,

Xiaoyang

Moodle Website Restored

Posted by Xingyu Tan 10 days ago.

Dear Students,

The Moodle website has now been restored and is functioning normally.

Since the issue was resolved before 4:00 PM, the assignment deadline remains unchanged.

Please note that the deadline is still tonight at 9:00 PM .

Thank you for your understanding.

Best regards

Xingyu

UNSW Moodle System Issue

Posted by Xingyu Tan 10 days ago.

Dear Students,

Please be informed that the UNSW Moodle system is currently down. The university is actively working on resolving the issue, and we expect it to be fixed shortly.

Please check again in a little while. If the issue has not been resolved by 4:00 PM today, we will extend the deadline by an additional day.

Thank you for your understanding.

Best regards,
Xingyu

Project mark released

Posted by Xingyu Tan 11 days ago.

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 next Friday (2nd May) .

Best regards,

Xingyu

Clarification on operation order and time slots in Assignment 2

Posted by Xingyu Tan 13 days ago, last modified 13 days ago.

Dear Class,

You may notice that, in Assignment 2, some schedules show several operations on the same data item in the same time slot. When this occurs, please assume the operations are carried out in the order of the transaction numbers —for example, T1 first, then T2, and so on.

Each “time slot” represents a span of time rather than an exact instant, and two operations on the same item do not happen simultaneously. For example, in Question 2, two operations on D appear in time slot t7; treat the operation from T1 as occurring first, followed by the T4.

Because a time slot is only an interval, whenever you need to refer to a precise moment in the assessment, please use phrases such as “immediately after time slot ti ” or “between ti and tj.” This wording will make your explanation clear.

Thank you for your attention, and please let me know if any part of the assignment needs further clarification.


Best regards,

Xingyu

MyExperience and sample exam paper

Posted by Xiaoyang Wang 15 days ago.

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 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 Deadline Extension

Posted by Xingyu Tan 22 days ago.

Hi Class,

Due to the public holiday in week 10, we are extending the deadline for Assignment 2. The new deadline for Assignment 2 is Monday 20:59:59 28 April (Sydney Time).

Best regards,

Xingyu

Public Holiday Lab Schedule

Posted by Xingyu Tan 27 days ago, last modified 27 days ago.

Dear Class,

Due to the public holiday, there are no labs scheduled on Friday of Week 9 , as well as Monday and Friday of Week 10 . You may attend any other weekday lab sessions during these weeks to keep up with your studies. The Ed forum and consultation session will continue as usual.

Thank you and happy Easter next weekend!

Best regards,

Xingyu

Assignment 2 released

Posted by Xingyu Tan about a month ago.

Hello Class,

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

Best regards,

Xingyu

Assignment 1 mark released

Posted by Xingyu Tan about a month ago.

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 by next Friday (4th April) .

Best regards,

Xingyu

Project released

Posted by Xingyu Tan 2 months ago.

Hi Class,

The project has been released under the Project section. The deadline for the project is Fri 20:59:59 April 4th (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 2 months ago.

Hello Class,

Assignment 1 has been released under the Assignments section. The deadline for assignment 1 is Fri 20:59:59 14th March (Sydney Time).

The first lab material has been released under the Labs section. We also provide one 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 25T1

Posted by Xiaoyang Wang 3 months ago.

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 2025.

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 submissions.

Lecture The lectures will be delivered in person at AinswthG03 (Tue/Thu). There will be online streaming lectures via Blackboard Collaborate at the same time. You can find the 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 in-person and online via Blackboard Collaborate from Week 1. You may join the consultation if you have any questions regarding the course.

Discussion Forum We will use Ed for the course forum/discussion board. You have to register yourself first . 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 soon!

Xiaoyang Wang