Notices

  • Final Exam

    Posted by Junhua Zhang Monday 27 November 2023, 01:04:05 PM.

    Hi students,

    The final exam is going to start at 1:20pm and ends at 4:40pm. The exam paper will be released on Moodle and Webcms at 1:20PM . The solution should be submitted on Moodle .

    You will have 3 hours (1:30 pm-4:30PM) to answer the questions, 10 minutes to read the exam requirements and the exam paper and 10 minutes to submit your answer. Late submissions after 4:40 pm will be penalised by 5 marks per minute.

    In case the course website is overloaded, we have put the slides in a shared folder on Dropbox . The exam paper will also be available in the folder during the exam.

    If you have any issues, please post them on Edforum privately and we will monitor the forum throughout the exam.

  • Industry Talk, Pizza&Drinks and Final Exam

    Posted by Junhua Zhang Friday 10 November 2023, 03:17:53 PM.

    Dear students,

    Industry Talk: Next Monday of week 10, we are excited to have an industry talk from Dr Yi Jin on how RDBMS implementations handle problems in the Industry.

    Pizza and Drinks will be served during next week’s Lectures on Monday and Thursday. You are encouraged to attend next week’s lectures in person and talk with Dr Yi Jin, other students and us.

    Final Exam: The final exam is scheduled for the afternoon session on 27 November. A sample exam paper will be released next week to help you get familiar with the final exam.

  • Final Exam and Consultations

    Posted by Yiheng Hu Thursday 09 November 2023, 04:18:12 PM.

    Dear Students,

    Consultation : We will run daily consultation before the final exam. You will be able to get support instantly in case you have a problem in preparing for the exam. Join the session the same way as you do for our normal weekly consultation sessions (allowing both online and in-person attendance).

    Venue: Building K17 Room 203

    Time: 3PM to 4PM

    Monday 20th Nov

    Tuesday 21st Nov

    Wednesday 22nd Nov

    Thursday 23rd Nov

    Friday 24th Nov

    Final Exam: The dates and mode of final exam (online) is centrally managed by the university. The scope of final exam will be discussed in the revision lecture of Week 10.

    Wishing you all the best for the final exam and please don't hesitate to reach out if you have any questions.

  • Assignment 2 Released

    Posted by Junhua Zhang Tuesday 31 October 2023, 02:01:58 PM.

    Dear students,

    Assignment 2 has been released. The due date is 5pm Friday, 17 November . This assignment is submitted via Moodle . Please start early and submit on time.

    Best,

    Junhua

  • Project 1 Released

    Posted by Junhua Zhang Tuesday 10 October 2023, 12:26:12 PM, last modified Monday 23 October 2023, 09:46:03 AM.

    Hi students,

    Project 1 and related files have been released. You can find the Project in the Course Work menu on the left.

    The deadline is 5pm Friday, Week 7 (27 October) .

    The project is submitted via Moodle: https://moodle.telt.unsw.edu.au/mod/assign/view.php?id=5960459

    Some tips for the project:

    1. Before attempting the questions, familiarise yourself with the project database (i.e., MyMyUNSW).
    2. Set up the project database ASAP so the course staff can assist you with related issues.
    3. Make sure that your solution can load and run correctly. You can check your answers using ' check.sql'.
    4. Start early and submit on time

    Best,

    Junhua


  • Public holiday and rescheduled consultation

    Posted by Junhua Zhang Saturday 30 September 2023, 04:10:52 PM.

    Dear students,

    Next Monday(2 October) is a public holiday, and there is no lecture, labs or consultation on that day.

    As a reminder, assignment 1 is due at 5pm next Friday . In case you need support for the assignment, we rescheduled the consultations from Monday to Tuesday. Below are the details of the consultations:

    • Offline: 10am-12am Tuesday, 3 October in room 203, level 2, K17
    • Online: 12am-2pm Tuesday, 3 October, link

    Have a good weekend,

    Junhua

  • More Consultations and Changed Lab Rooms

    Posted by Junhua Zhang Thursday 21 September 2023, 10:00:50 AM.

    Hi students,

    More Consultations. In order to meet the needs of a large number of students and to give you more opportunities to interact with us, we have decided to offer more consultations (two online consultations and two offline consultations) as below, which you can also access via "Consultation" in the menu on the left:

    Consultation(Online) Monday 9:00-11:00 Link
    Consultation Monday 9:00-11:00 K17 203
    Consultation(Online) Friday 10:00-12:00 Link
    Consultation Friday 12:00-14:00 K17 204

    Lab rooms changed. Due to equipment problems in some labs, we have changed the room of some labs, details are below. One of the labs is scheduled at 11:00-13:00 today :

    Time Old Room New Room
    Tuesday 15:00 - 17:00 (Weeks:2-5,7-10) T15A Quadrangle 1043
    Wednesday 11:00 - 13:00 (Weeks:2-5,7-10) W11A Ritchie Theatre
    Wednesday 13:00 - 15:00 (Weeks:2-5,7-10) W13A AGSM Boral Theatre
    Wednesday 16:00 - 18:00 (Weeks:2-5,7-10) W16A Webster 250
    Thursday 11:00 - 13:00 (Weeks:2-5,7-10) H11A F10 June Griffith M11


  • Assignment 1 is released

    Posted by Junhua Zhang Monday 18 September 2023, 11:47:28 AM.

    Hi students,

    We have released the assignment 1. You can access Assignment 1 via the menu on the left "Course Work -> Assignments." Assignment 1 is due at 5 pm Friday of Week 4. This assignment is submitted via Moodle.

    Should you have any questions, please let us know.

    Regards,

    Junhua

  • Lab01 is out, and Assignment 1 is to be released on Monday

    Posted by Junhua Zhang Friday 15 September 2023, 05:12:07 PM.

    Dear students,

    Labs start next week. Lab 01 materials have been released. You can try it yourself. Please let me know if you cannot connect to the CSE machine. To attend a lab, you will need to bring your own laptop . There may be charging ports in the lab room, but we have ~26 labs spread across the campus, so we don’t know the details of each lab room. Before you go, you’d better check it yourself. CSE has a laptop-lending machine. You could borrow one for your lab if you forget your laptop or it is not working.

    Assignment 1 on Data Modelling and Relational Algebra will be released next Monday and due on Friday of Week 4 . You’ll have ~3 weeks to complete the assignment.

    Best Regards,

    Junhua

  • Notice on Limited Classroom Seats

    Posted by Junhua Zhang Monday 11 September 2023, 07:07:03 PM, last modified Monday 11 September 2023, 07:07:56 PM.

    Dear Students,

    We are delighted that so many of you attended today's lecture, both in person and online. It's great to you find that today's lecture both useful and inspiring for all of us. After this first session, there are some matters about attending the lectures we'd like to address.

    Because we have a large number of new students this semester, our current classroom space is insufficient to accommodate everyone. We have noticed that several students enrolled in the online version of this course have chosen to attend today's lecture in person. While we're pleased with your enthusiasm, this has resulted in a shortage of seats for those registered to attend in person, forcing them to leave.

    For fairness, if you're taking the online course, please keep participating online for now. We anticipate that there may be more seats available starts from week 2 or 3. Before you decide to attend in person, please make sure that there are enough seats available for those students who registered for the in-person lectures; otherwise, please attend online lectures.

    We appreciate your understanding and cooperation.

    Best regards,

    Junhua

  • Welcome to 2023 COMP9311 T3 offering of Database Systems

    Posted by Junhua Zhang Wednesday 06 September 2023, 05:14:05 PM, last modified Wednesday 06 September 2023, 05:14:33 PM.

    Hi Students,

    Firstly, welcome to the course COMP9311. This week is the O-Week. I hope you look forward to learning about database systems. In this opening notice, I outline how the course is run in 2023T3 and provide some important information that you may find helpful.

    As required by UNSW, all students must return to campus from 2023T2. In this term, we will run multi-modal courses. Specifically, lectures are delivered in hybrid mode with recordings. Lab sessions are face-to-face in classrooms on yourown laptops. We will also run an online forum and online help sessions (i.e., consultations) where you can get help from our tutors and staffs.

    The main course materials reside on WebCMS3 ( https://webcms3.cse.unsw.edu.au/COMP9311/23T3/ ). All announcements, lecture notes, lab notes, assignment specs, etc., will be posted here. If you're reading this notice, congrats, you've found us.

    Moodle( https://moodle.telt.unsw.edu.au/course/view.php?id... ) provides access to online lectures, recordings, consultations, and assessment submissions.

    Lectures start from Week 1. The face-to-face lectures are scheduled to

    14:00 - 16:00 Monday at Ainsworth G03 (K-J17-G03)

    16:00 - 18:00 Thursday at E19 Patricia O'Shane 104 (K-E19-104).

    The online lectures are scheduled at the same time as the f2f lectures. The links to them will be posted on WebCMS3 before each week.

    All lectures will be recorded, which can be found on Moodle after the first lecture. All lectures will be delivered via Blackboard Collaborate and recorded via ECHO360 in Moodle. There are two ways to access the lecture: 1) We will provide a link to access the lecture (live and recording) in the Lectures tab, next to each week's lecture notes. 2) You may log into Moodle ( https://moodle.telt.unsw.edu.au ) first, find our course, and click "Blackboard Collaborate" to join a live lecture. You may click "Lecture Recordings" to access the recorded lectures.

    Labs start from Week 2. Due to the limited space of school labs, this term we have to run BYOD labs face-to-face in classrooms. So you need to bring your own laptop and make it fully charged. CSE has a laptop-lending machine, so if you forget your laptop or it is not working properly, you could borrow a laptop for a class: https://taggi.cse.unsw.edu.au/FAQ/Borrow_A_Laptop/. During the lab, a tutor will be present to assist you and answer your questions.

    Consultation starts from Week 1. Weekly consultations will also be presented online 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 Friday each week.

    Ed Forums. You can use the Ed forums (linked on the 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 it.

    Best of luck, and I look forward to meeting you all soon.

    Junhua Zhang

    Instructor/Lecturer


Back to top

COMP9311 23T3 (Database Systems) is powered by WebCMS3
CRICOS Provider No. 00098G