Notices

  • Marks Uploaded

    Posted by Zhengyi Yang Monday 29 August 2022, 02:09:55 PM, last modified Monday 29 August 2022, 02:12:05 PM.

    Hi all,


    The exams are marked and your final marks are uploaded to the university. We do not release exam marks, but I believe you can calculate them once you get your final marks. Your final marks should be release by the university on this Thursday.

    Hope you enjoyed COMP9311 this term.


    Best,

    Zhengyi

  • Final Exam Released

    Posted by Zhengyi Yang Tuesday 23 August 2022, 12:44:42 PM.

    The final exam paper has been released on WebCMS, accessible in the 'Final Exam' Tab.
    The Moodle submission page will be active starting from 1pm.


    Please read the instructions and questions carefully, and do let us know if there any problems with accessing the file.
    Lastly, best of luck to you all.


    (Note: we don't have any rules on the name of your final file submission, but it would be nice if you could include your zid in the file name)

  • Final Exam Tomorrow

    Posted by Zhengyi Yang Monday 22 August 2022, 11:14:23 AM, last modified Monday 22 August 2022, 11:21:58 AM.

    Dear All,


    A reminder that the exam is scheduled tomorrow: between 1:00 - 4:15 pm ( AEST 23rd Aug).
    We will release the final exam on WebCMS at 12:45 pm (15 minutes prior to the exam start time to allow extra time for downloading and uploading) .
    You will be notified via a WebCMS notice (also emailed to all students) once the paper is released.
    You will submit your exam on Moodle .

    During the examination:

    1. If you have any concerns relating to the questions, send an email to me ( zyang@cse.unsw.edu.au ) AND cc the course email address ( comp9311unsw@gmail.com ). Please do NOT post anything on the forum, as it could be distracting to other students.
    2. If we are to make updates/clarifications to any questions. We will release updates both as WebCMS notices (also emailed to all students) and in the Exam tab in WebCMS.

    Please allocate 5-10 minutes towards the end to submit your examination. Anything submitted after 4:15pm will be ignored (unless you have adjustments based on an Equitable Learning Plan).

    For detailed university guidelines on exam rules, please take 10 minutes or so to read the contents of the following link. https://www.student.unsw.edu.au/exam/rules

    Please be well prepared for the exam. Unfortunately, we will NOT provide any support for your own personal configuration or network-related issues. So maybe have your phone hot-spot ready for unexpected network outages.

    We will be checking for plagiarism in your exam submissions. You must attempt the examination by yourself.



    Wish you all best of luck,

    Zhengyi

  • Assignment 2 Marks Released

    Posted by Zhengyi Yang Tuesday 16 August 2022, 11:41:42 AM, last modified Tuesday 16 August 2022, 11:42:03 AM.

    Dear All,


    The marks and solutions of assignment 2 have been released. Please contact your marking tutor by THIS FRIDAY if you have any questions.


    Best,

    Zhengyi

  • Exam Length Update and Consultations Next Week

    Posted by Zhengyi Yang Friday 12 August 2022, 02:22:02 PM.

    Dear All,


    The myExperience survey is ended. Thank you for participating. All of your responses are valuable to us in improving the course. The final response rate is 71% (113/159), so you will be given an extra 15 minutes for the final exam.

    In addition, just to remind you that we run daily consultations next week (2 - 3pm everyday). You can find the online sessions on Moodle. Moreover, the consultations on next Thursday and Friday will also have offline sessions at Room 201B Level 2 Building K17 . Please wear a mask if you come to the offline sessions.


    Best,

    Zhengyi

  • Survey and Length of Final Exam

    Posted by Zhengyi Yang Monday 08 August 2022, 01:34:08 PM.

    Dear All,


    The myExperience survey is closing soon (this Thursday), thanks for those who have completed the survey. The current response rate is around 30%. To encourage you in filling out, we will INCREASE the length of the final exam by 15 minutes if the response rate reaches 50%, and 25 minutes if the response rate reaches 80%.

    Here is the link https://myexperience.unsw.edu.au/ .


    Best,

    Zhengyi

  • Final Exam

    Posted by Zhengyi Yang Friday 05 August 2022, 02:14:58 AM, last modified Monday 08 August 2022, 02:17:27 PM.

    Dear All,


    We finished all the lectures yesterday. I hope you all enjoyed the course this term. Following are some information for the final exam.

    Final Exam. The final exam will be on 1-4pm 23rd Aug . The exam paper will be released at around 12:45pm on the exam day, allowing you for an extra 15min to download the paper and upload your solutions. The scope of the exam and more additional information were discussed in the last revision lecture. If you didn't attend the revision lecture, I highly recommend you to watch the recording.

    Exam Consultation. We will run one consultation on week 11, and daily consultations on week 12 to answer any questions of you before the exam. Please check the last notice for the schedule. At the meanwhile, you can continue to ask questions on the forums.

    Survey. Your feedback of the course is very important to us. The response rate to the MyExperience survey is currently very low. Please spend a few minutes to fill out the MyExperience survey if you haven't done so. You can find the entry on Moodle or directly use the link https://myexperience.unsw.edu.au/ .


    Thank you and all the best,

    Zhengyi

  • Consultations for Week 11&12

    Posted by Zhengyi Yang Thursday 04 August 2022, 06:01:00 PM, last modified Friday 05 August 2022, 01:27:57 AM.

    Dear Student,

    Here are consultation plan for Week 11&12.

    Week 11:

    Aug 11 Thu 2-3pm (online)

    Week 12:

    Aug 15-19 Everyday 2-3pm (online)

    Aug 18 Thu 2-3pm (offline)

    Aug 19 Fri 2-3pm (offline)

    Offline consultations will be at Level 2 Building K17.


    Best,

    Zhengyi

  • Sample Exam Paper Released

    Posted by Zhengyi Yang Thursday 04 August 2022, 11:48:15 AM.

    Dear Students,


    A sample exam paper and its solution are released.

    Please note that this is only intended to provide a good idea of the difficulty level and format you can expect from the final exam, so do not expect the scope or question types to be the same. I’ll talk about the scope in today’s revision lecture.

    Also note that, unlike our final exam which is a 3-hour exam, this sample exam is designed for a 2-hour exam.

    Best,

    Zhengyi

  • myExperience Survey

    Posted by Zhengyi Yang Monday 01 August 2022, 12:15:38 PM, last modified Friday 05 August 2022, 02:12:09 AM.

    Dear All,


    You will have received email invitation and links to the UNSW myExperience survey are now available in Moodle. It's very important for us to know your feedback about this course, so please kindly response to the myExperience survey if you can.

    Short Link: https://myexperience.unsw.edu.au/

    Thanks,

    Zhengyi

  • Marks of Project 1 is released

    Posted by Zhengyi Yang Monday 01 August 2022, 11:46:19 AM.

    Dear All,

    Marks of project 1 were released last Friday. Please contact your marking tutor by TISH FRIDAY if you have any question about your mark.

    Thanks,

    Zhengyi

  • New Consultation Slot for Offshore Students

    Posted by Zhengyi Yang Thursday 21 July 2022, 02:49:00 PM.

    Hi,

    We have opened up an extra new consultation to support offshore students. The time is 6-8pm every Thursday.


    Best,

    Zhengyi

  • Assignment 2 Released

    Posted by Zhengyi Yang Monday 18 July 2022, 01:09:14 PM.

    Afternoon all,

    A gentle reminder that Assignment 2 is released, and is now accessible under the Assessments section.
    The scope of assessment focuses on the learning outcomes below.

    1. Functional Dependency and Normal Forms
    2. Database Storage/Index
    3. Transaction Management

    Do endeavor to start early, the deadline for the assessment is on the 5th of August.


    Best,

    Zhengyi

  • Project Files Updated

    Posted by Zhengyi Yang Wednesday 06 July 2022, 09:03:30 PM.

    Hi Students,

    We have updated the project files to fix some errors in the check file. Please download the zip again to make sure you have the latest version.

    Zhengyi

  • Assignment 1 marks released

    Posted by Zhengyi Yang Wednesday 06 July 2022, 11:26:01 AM.

    Dear students,

    Marks and sample solution for Assignment 1 have been released. You can check your mark in Moodle.

    For any issues concerning your mark, please contact your marking tutor through the email in the feedback comments.

    If you have submitted your assignment but do not get any mark, please email us on comp9311unsw@gmail.com as soon as possible.

    Best,

    Zhengyi

  • Extra Support for Offshore Students

    Posted by Zhengyi Yang Monday 04 July 2022, 12:37:33 PM.

    Hi Students,

    I've been informed by the school that there’re about 13 offshore students in this course. We're planning on providing them with some extra support (e.g. extra online tutorial). If you are offshore and need some extra support, please let me know by emailing me at zyang@cse.unsw.edu.au.

    Zhengyi

  • Project 1 is released

    Posted by Zhengyi Yang Tuesday 28 June 2022, 11:58:09 PM.

    Project 1 and supporting files have been released (see Project under Course Work) .

    The deadline for project 1 is 15th of July (Friday) at 16:59:59

    Tips:

    1. Familiarise yourself with the project database (i.e., MyMyUNSW) first before attempting the questions.
    2. Set up the project database ASAP so the course staff can assist you with any related issues.
    3. Make sure that your solution can load and runs correctly. You can check your answers using ' check.sql'.
    4. Submit on time

    Best Regards,

    Zhengyi

  • Assignment 1 Due on Friday

    Posted by Zhengyi Yang Wednesday 22 June 2022, 04:37:12 PM, last modified Thursday 23 June 2022, 03:19:23 PM.

    Dear Students,

    A quick reminder that assignment 1 is due on Friday 17:00 this week. Please follow the instructions to submit your solution on Moodle.

    Also notice that we will have a guest lecture tomorrow. Please join the live stream so you can talk to our guest from the industry.


    Best,

    Zhengyi

  • Assignment 1 Released (and also Practice 1)

    Posted by Zhengyi Yang Monday 06 June 2022, 05:12:50 PM.

    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 24th 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

  • Reminder of the 1st Lecture

    Posted by Zhengyi Yang Monday 30 May 2022, 11:47:58 AM.

    Hi Students,

    Your journey into database systems is about to start. The first lecture will be on tomorrow during 15:00-17:00. Please log in to Moodle to access the lecture link.

    Best,

    Zhengyi

  • Lab sessions are 2 hours

    Posted by Zhengyi Yang Tuesday 24 May 2022, 02:40:34 PM.

    Hi Students,

    Please note that all lab sessions (starting from week 2) of COMP9311 are 2 hours. The timetable should be updated shortly (UNSW runs updates overnight).


    Best,

    Zhengyi

  • Welcome to COMP9311

    Posted by Zhengyi Yang Monday 23 May 2022, 03:21:30 PM.

    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 2022T2.

    With no thanks to COVID-19, we will run most of our course online. Specifically, lectures and consultations are held online. Lab sessions are all online with the expectation of a very small number of labs with face-to-face available.

    We manage the course with WebCMS3 and Moodle ( https://webcms3.cse.unsw.edu.au/COMP9311/22T2/ and https://moodle.telt.unsw.edu.au/course/view.php?id=67826 ).
    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 online live lectures and lecture recordings.

    Lectures start from Week 1 :
    We will deliver lectures live online at the scheduled lecture time 15:00 – 17:00 Tuesday and 15:00 – 17:00 Thursday (Sydney time). All lectures will be recorded.

    Lectures will be delivered in Blackboard Collaborate in Moodle.
    Lectures are also recorded in Blackboard Collaborate in Moodle.

    There are two ways to access the lecture:
    1) You can access it directly from Moodle ( https://moodle.telt.unsw.edu.au ), find our course, click "lectures and recordings", click Menu (in up left corner), click "Sessions" to join a live lecture or "Recordings" to access the recorded lecture.

    2) We will provide a copy of the link to access the lecture (live and recording) in the WebCMS Lectures Tab , next to the lecture notes each week.

    Labs start from Week 2:
    1) 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.
    A related copy of the link will also be provided in the WebCMS Labs tab each week, and you are also able to access it via Moodle. All online labs will be recorded.

    2) 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. You are required to follow the university guidelines and wear a mask indoors. You will be required to abide by the latest physical distance restrictions and wear a face mask for the safety of other students and tutors.
    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 2:
    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 14:00-15:00 Thursday before the lecture.

    On Assessments: The final exam will be conducted online, so as all other assessments. We generally give 2-3 weeks for you to work on assignments and projects.

    You can start using the WebCMS "Q and A page" section to ask questions and engage with other students. Tutors will visit the forum regularly to answer questions.

    Best of luck, and I look forward to meeting you all (in some capacity) soon.

    Zhengyi Yang

    Instructor/Lecturer


Back to top

COMP9311 22T2 (Database Systems) is powered by WebCMS3
CRICOS Provider No. 00098G