Hi everyone,
The final marks have been released today. Please note that we do not provide detailed comments on your exam marks. If you have any questions or concerns regarding your final marks, please don't hesitate to reach out to us via email.
For those who will be taking the supplementary exam, it is scheduled for Friday, September 8th, from 1PM to 4PM. If you have been granted special consideration for a supplementary exam, we will contact you via email with further details.
As a reminder, please be aware that according to UNSW's policy, anyone who has already taken the exam will not be eligible for a supplementary exam.
We hope you had a great experience in COMP9311 this term!
Best regards,
Zhengyi
Dear Students,
The submission deadline for the final exam is approaching. Please ensure that you submit your exam on time.
Best,
Zhengyi
Dear Students,
Due to technical issues with WebCMS3 this morning, we are extending the submission time for the final exam by 5 minutes. The new deadline is 12:30 PM .
Please ensure you utilize this additional time if needed. If you encounter any further difficulties, please inform us by email.
Please submit your answers on: https://moodle.telt.unsw.edu.au/mod/assign/view.php?id=5725828 .
Thank you for your understanding.
Dear Students,
A quick reminder that the final exam is scheduled for tomorrow, between 9:00 AM and 12:25 PM (AEST) on August 18th. We will release the final exam paper on WebCMS at 8:50 AM (10 minutes prior to the exam start time) to allow extra time for downloading and uploading.
You will be notified via a WebCMS notice, which will also be emailed to all students, once the paper is released. Remember that you are required to submit your exam on Moodle.
Here are some important guidelines for the exam day:
Please allocate 5 minutes towards the end of the exam for submission. Submissions received after 12:25 PM will incur a significant late penalty of 5 marks per minute (unless you have adjustments based on an Equitable Learning Plan).
For detailed university guidelines on exam rules, I strongly encourage you to spend around 10 minutes reading through the contents of this link: https://www.student.unsw.edu.au/exam/rules .
Kindly ensure that you are well-prepared for the exam. Unfortunately, we will not be able to provide support for personal configuration or network-related issues during the exam. It might be a good idea to have your phone's hotspot ready for any unexpected network outages.
Lastly, I want to emphasize that the exam must be attempted individually. Engaging in group work or using generative AI tools can lead to academic misconduct. For more information, please review the details at this link: https://www.student.unsw.edu.au/plagiarism .
Wishing you all the best of luck in your exams.
Warm regards,
Zhengyi
Dear all,
Marks of Assignment 2 were released. Please contact your marking tutor BEFORE EXAM (18th Aug Friday) if you have any question about your mark.
Dear All,
The myExperience survey has concluded, and we appreciate your participation. Your input is highly valuable to us for enhancing the course. The final response rate is 82%, which means you will receive an additional 25 minutes for the final exam.
Best,
Zhengyi
Dear Students,
Today is the last day for myExperience survey. The current response rate is 75%. So you only need 5% more (around 15 students) to get the extra time in the final exam.
Zhengyi
Dear All,
I hope you have enjoyed the course this term. As we have concluded all the lectures, I'd like to provide you with some important information regarding the final exam.
Final Exam: The final exam is scheduled for 9 AM-12 PM on 18th Aug (plus a potential extension from the myExperience survey). The exam paper will be released at approximately 8:50 AM on the exam day, allowing you an extra 10 minutes to download the paper and upload your solutions. The scope of the exam and additional information were discussed in the last revision lecture. If you missed the revision lecture, I highly recommend watching the recording. Please ensure that you submit your answers on time to avoid a late penalty of 5 marks per minute .
Exam Consultation: We have scheduled two consultations during week 11, and daily consultations during week 12 to address any questions you may have before the exam. Additionally, you can continue to ask questions on the forums. The consultations will be conducted in a hybrid form, allowing both online and in-person attendance. The schedule is as follows:
Week 11:
Week 12:
Wishing you all the best for the final exam and please don't hesitate to reach out if you have any questions.
Thank you,
Zhengyi
Dear All,
Marks of project 1 were released. Please contact your marking tutor by THIS FRIDAY if you have any question about your mark. Note that if your question is related to errors in your code, please follow the section 8 in proj1.pdf firstly to verify if your code works correctly.
Dear students,
A quick reminder that the myExperience survey will be closing soon. Thank you to those who have already completed the survey. However, we currently have a response rate of only around 30%. To potentially receive more time in your final exam, we kindly ask you to take a few moments and participate in the survey.
Again, if the response rate reaches 50%, we will INCREASE the length of the final exam by 15 minutes . And if the response rate reaches 80%, we will extend it by 25 minutes .
Best,
Zhengyi
Dear students,
We are excited to have a guest lecture on "RDBMS Implementations Fitting Different Workloads" tomorrow. The speaker, Dr. Yi Jin, is an adjunct lecturer at UNSW with 15 years of experience in the database industry. He has worked at IBM for the DB2 product and has been the top contributor to the open-source Apache HAWQ project.
Don't miss this enlightening session to learn how RDBMS implementations handle diverse data processing demands. Join us to gain valuable insights from Dr. Jin's expertise and have the opportunity to interact with him in-person.
Best,
Zhengyi
Dear Students,
A sample exam paper and its solution are released. Please note that the sample paper is just a reference. The final exam might have different number of questions, exam duration, scopes and difficulty levels. For more detailed information about the final exam, please refer to the content covered in the revision lecture.
Dear all,
We hope you are enjoying the course so far. You should have received an email invitation, and the links to the UNSW myExperience survey are now available in Moodle. Your feedback is of great importance to us, and we kindly request you to respond to the myExperience survey.
To show our appreciation for your participation, we have a special incentive: If the response rate reaches 50%, we will increase the length of the final exam by 15 minutes. And if the response rate reaches 80%, the final exam will be extended by 25 minutes.
Your valuable feedback will help us improve the course and enhance your learning experience. Please take a few moments to complete the survey by following this link: https://myexperience.unsw.edu.au/ .
Best,
Zhengyi
Dear all,
The deadline of Assignment 2 has been extended to
17:00 6th Aug (Sunday)
to ensure that you have sufficient time to complete. If you have any other questions or concerns, please do not hesitate to contact us.
Dear all,
A gentle reminder that Assignment 2 is released (see Assessments under Course Work).
The scope of assessment focues on the learning outcomes of:
The deadline for assignment 2 is 4th of August (Friday) at 17:00.
Dear students,
This is a reminder that Project 1 is now overdue. If you have not yet submitted your project, please do so as soon as possible unless you have applied for special consideration. Late penalties (5% per day) will apply for submissions made after the deadline.
If you have encountered any unforeseen circumstances that may have affected your ability to submit on time, I encourage you to apply for special consideration following the university's guidelines.
Best,
Zhengyi
Dear students,
The marks and sample solution for Assignment 1 have been released. You can now access your marks by logging into Moodle.
If you have any concerns or questions regarding your mark, please reach out to your marking tutor using the email provided in the feedback comments. Kindly make sure to address any issues within this week .
In the event that you have submitted your assignment but have not received a mark, please contact us promptly via email.
Best,
Zhengyi
Dear all,
The deadline of project 1 has been extended to 17:00 16th July (Sunday) to ensure that you have sufficient time to complete project 1. If you have any other questions or concerns, please do not hesitate to contact us.
Dear all,
Due to a technical issue occurred within the cse network, you may find that access to server are unavailable sometimes. Currently, we decided to extend Project 1 deadline to 17:00 15th July (Saturday) . We will closely moniter the server situation. If the problem persists, we will consider granting a further extension.
Project 1 and supporting files have been released (see Project under Course Work) .
The deadline for project 1 is
14th of July (Friday) at 16:59:59
Tips:
Zhengyi
Dear Students,
A quick reminder that the assignment 1 is due today at 17:00. Please follow the instructions to submit your solution on Moodle. Otherwise, late penalty will apply.
Best,
Zhengyi
Dear all,
This is a reminder that there will be no lecture and lab next Monday due to a public holiday. However, you are welcome to attend labs on other days throughout next week.
Zhengyi
1) Assignment 1 is released (see Assessments under Course Work)
By the time we finish wk2's lectures, you will have all the skills/knowledge needed to attempt assignment 1. The deadline for assignment 1 is 23th of June (Friday) at 16:59:59.
(See other details e.g. submission instructions in the assignment PDF)
2) Practice Set 1 is also released (see Practices under Course Work)
Practice set questions are there to aid you in your learning.
This is a good indicator to see if you've understood the concepts taught.
(We recommend attempting the practice questions before inspecting the solutions for maximum value)
Best of Luck,
Zhengyi
Hi Students,
The issue with lecture recordings has been resolved! You can now access the recordings on Moodle under the section of 'Lecture Recordings'.
Best,
Zhengyi
Hi Students,
Lecture recording is currently not showing up on Moodle. I have contacted the school to fix the issue. It should be available shortly.
Best,
Zhengyi
Hi Students,
Firstly, welcome to the course COMP9311. I hope you look forward to learning about database systems. In this opening notice, I outline how the course is run in 2023T2.
As required by UNSW, all students must return to campus in 2023T2. So we will run most of our course face-to-face. Specifically, lectures are in-person only with recordings. Lab sessions are mostly face-to-face with a small number of labs online. We will also run online help sessions (i.e., consultations) every week to answer further questions you may have.
We manage the course with WebCMS3 and Moodle
(
https://webcms3.cse.unsw.edu.au/COMP9311/23T2/
and
https://moodle.telt.unsw.edu.au/course/view.php?id=75964
).
If you’re reading this notice, congrats, you’ve found us.
All announcements, lecture notes, lab notes, assignment spec, etc. are going to be posted here.
Moodle is used to provide access to and lecture recordings, online labs/consultations, and assessment submission.
Lectures
start from Week 1
:
We will deliver lectures at the scheduled lecture time 10:00 – 12:00 Monday (Science Theatre) and 15:00 – 17:00 Thursday (Rex Vowels Theatre). All lectures will be recorded, which can be found on Moodle after the first lecture.
Labs start from Week 2:
1) Face to Face Labs: You may either use the lab computers or your own computer. A tutor will present in the lab to assist you and answer your questions. There will be no recordings for f2f labs.
2
) Online Labs: Detailed lab notes will be provided, and you are expected to follow the guide using your own computer. We will schedule online lab sessions throughout the course (via Blackboard Collaborate) and there will be tutors present to help you.
You are able to access it via Moodle. All online labs will be recorded.
Do not
attend the lab if you feel unwell, and you can make up the labs by attending any of the online labs.
Consultation
starts from Week 1:
Weekly consultation will also be presented via Blackboard Collaborate. You may join the consultation if you have any questions regarding the course. Consultations will be recorded. A link will be provided in the Consultation tab for you to join, also you may join via Moodle. Consultations will be held 10:00-12:00 Thursday before the lecture.
On Assessments: The final exam will be conducted in-person, DO NOT take this course if you are not able to attend the in-person final exam. For other assessments, we generally give 2-3 weeks for you to work on assignments and projects.
Ed Forums: You can start using the Ed forums (linked on WebCMS menu) to ask questions and engage with other students. Tutors will visit the forum regularly to answer questions. Please let me know if you are unable to access.
Best of luck, and I look forward to meeting you all (in some capacity) soon.
Zhengyi Yang
Instructor/Lecturer