COMP3311 Notices

The Exam database is now avalible on WebCMS

Posted by Dylan Brotherston 🕴️ a day ago.

https://webcms3.cse.unsw.edu.au/COMP3311/25T1/resources/107775

Clarification On Exam Conditions

Posted by Dylan Brotherston 🕴️ 4 days ago.

Due to JAS's absence some lecture slides were copied from 23T3, The exam slides indicated that course notes would be available in the exam. This was unfortunately just left over from 23T3.

The 25T1 exam (like the 24T1 and 24T2 exams) will not have course notes available.

Assignment 2 and Quiz 6 Due date Reminder

Posted by Dylan Brotherston 🕴️ 14 days ago.

Reminder that Assignment 2 is due tonight at midnight, ~13 hours from now.

Quiz 6 is due Tomorrow at midnight (yes tomorrow is a public holiday but it should only take 10 minutes)

COMP3311 Exam Clashes

Posted by Dylan Brotherston 🕴️ 15 days ago.

There have been a number of emails today about COMP3311 clashing with first year maths exams, in particular MATH1081.

most first year math courses, including MATH1081, run exams on multiple days.

COMP3311's exam only runs on one day: the 12th of May.

If you are taking a first year maths course you must ensure that it is not at the same time as the COMP3311 exam.

Please email <exams.mathsstats@unsw.edu.au> if you need to change the time of a maths exam.

Assignment 2 autotests now avalible

Posted by Dylan Brotherston 🕴️ 23 days ago.

https://webcms3.cse.unsw.edu.au/COMP3311/25T1/resources/111330

Assignment 2 Q4 Clarifications

Posted by Dylan Brotherston 🕴️ 23 days ago.

Some clarification has been added to Q4 regarding the order of output. If you have already finished Q4 please have a look at the clarifications to make sure your implementation is correct.

A set of autotests will be released later tonight.

Apologies for Yesterday's Lecture

Posted by Dylan Brotherston 🕴️ 23 days ago.

There was no Lecturer at Yesterday's Lecture due to confusion if JAS would be back or not.

Unfortunately JAS will not be back this term.

Jerry He will continue to take the last two lectures, on Thursday this week and next week (next Monday is a public holiday).

Help Session Timetable updated for week09 and week10

Posted by Dylan Brotherston 🕴️ 25 days ago.

week09 and week10 help sessions are now in the Help Session Timetable .

Assignment 2 Q5 is now avalible

Posted by Dylan Brotherston 🕴️ 29 days ago, last modified 28 days ago.

Assignment 2 Q5 is now available, I apologise for the delay.

The Assignment 2 due date has been pushed back 2 days as compensation.

Autotests for Assignment 2 will be released later in the week, but you still have the example page to compare against.

Assignment 1 style marking now available

Posted by Dylan Brotherston 🕴️ about a month ago.

Your full marks for Assignment 1 are now avalible, in the same place you previously viewed your automarking results.

Including marking for people with extensions <= 7 days.

If you have an extensions > 7 days your marking will be avalible this time next week.

Assignment 2 Released

Posted by Dylan Brotherston 🕴️ about a month ago.

Assignment 2 has now been released.

You can view it on webCMS here: https://webcms3.cse.unsw.edu.au/COMP3311/25T1/resources/107746

There are 5 python scripts to write for the assignment, the Spec for the first 4 are currently avalible, the Spec for the last script will be added tonight or tomorrow morning.

Week07 Updates

Posted by Dylan Brotherston 🕴️ about a month ago.

Jerry He will be taking the lectures this week and next week.

The course outline says that assignment 2 will be released today (Monday) but as we have pushed back to due date because of Easter we will be holding off on releasing the assignment for a few days, It will likely be out on Wednesday.

Assignment 1 Performance Marking Now Avalible.

Posted by Dylan Brotherston 🕴️ about a month ago, last modified about a month ago.

You can view your auto-marked, performance, portion of your assignment in webCMS or by running the command
3311 classrun -collect ass1

Note: if you have received an extension, from ELS or Special Consideration, your performance marks will not be available yet.

Tutors will begin marking your style marks shortly, and should be completed by the end of next week.

If you lost marks in the auto-marked section, your tutor will review your solution for partial mark while assessing your style.

UPDATE, there was an issue with Q9 marking where it was calling the Q8 function.
This has now been fixed, some people's marks may have increased or decreased, but most peoples marks have not changed.

Course Update

Posted by Dylan Brotherston 🕴️ 2 months ago.

Hi everyone,

JAS has become unwell and will be take some time off to recover.

Please make sure that any emails are sent to the course email address <cs3311@cse.unsw.edu.au> and not to any individual staff as JAS will likely not be responding to emails.

Week05 lectures will go ahead as normal but I will be giving the lectures.

Lecture recordings will not be uploaded to YouTube for the moment, but can still be found on Echo360 via Moodle.

Professor Wenjie Zhang will also be assisting with the course during week06 as I will also be away.
So again please make sure all emails are sent to the course email address.

Quiz 3 Reminder

Posted by Dylan Brotherston 🕴️ 2 months ago.

Quiz 3 is due tonight at midnight, only 53% of the course has compleated it so far.

If you have not compleated Quiz 3 yet, remember to do so soon.

Assignment 1 Help Sessions

Posted by Dylan Brotherston 🕴️ 2 months ago.

The Help Sessions Timetable for Assignment 1 is now available here:
https://webcms3.cse.unsw.edu.au/COMP3311/25T1/resources/107776

Quiz 2 reminder

Posted by Dylan Brotherston 🕴️ 2 months ago.

Quiz 2 is due tonight at midnight, only 60% of the course has compleated it so far.

If you have not compleated Quiz 2 yet, remember to do so soon.

Assignment 1 Update

Posted by John Shepherd 2 months ago, last modified 2 months ago.

Auto-testing is now available and you can submit your assignment via

give cs3311 ass1 ass1.sql

I'll add any further updates to this Notice ...

Assignment 1 Clarifications

Posted by John Shepherd 2 months ago.

I've had a few questions along these lines, so will answer them here and add them to the spec:

• you can define as many extra views as you like; they must be defined before they are used, so that ass1.sql loads in one pass without error; these extra views can be used in answering multiple questions
• in Q8 and Q9, the cheesemakers must appear in alphabetical order on their names

I may add other bullet points above if other questions are frequently asked.

Assignment 1

Posted by John Shepherd 2 months ago, last modified 2 months ago.

Assignment 1 is available. Full database. Full schema. Full spec .

Update #1: Mon 3 Mar, 9:40am, PLpgSQL functions are now added to the spec and ass1.sql

Update #2: Mon 3 Mar, 11am, Correct ass1.dump installed, replacing 24T2 dump (ahem)

Update #3: Mon 3 Mar, 6pm, Typo in ass1.dump fixed; reload ass1.dump (makes q2 example output work)

Update #4 : Tue 4 Mar, 9:40am, fixed q3 example output; was missing two tuples

More example outputs and auto-testing still to come.

vxdb02 is Back Up

Posted by Dylan Brotherston 🕴️ 2 months ago, last modified 2 months ago.

vxdb02 is currently offline and cannot be connected to.

The Computing Support Group are working to get it (and other servers) back online as quickly as possible.

Update:

vxdb02 is back online.

Quiz 1 Reminder

Posted by Dylan Brotherston 🕴️ 2 months ago.

Quiz 1 is due at Midnight tonight.
200 people haven't completed the quiz yet.
If you have not done so yet, remember to do so soon.

A link to the quiz can be found below, or on the right hand side of the main course page.
https://webcms3.cse.unsw.edu.au/COMP3311/25T1/activities/

CSEsoc Workshop on Python Basics Wed 26 Feb

Posted by John Shepherd 2 months ago.

If you want a quick Python intro, CSEsoc are running one of their weekly LeetCode workshops today (Wed 26 Feb) on Python basics (with arrays and hashing) in K17-113 from 2-4pm.

Week 02

Posted by John Shepherd 2 months ago.

Reminder: each week, I'll post a preview video showing what's happening in the coming week. These videos appear on the Lectures page under (surprise!) Weekly Previews. Here's the Week 02 Video .

Intro Lecture

Posted by John Shepherd 3 months ago, last modified 3 months ago.

Normally, we use the first hour of lectures going over what's in the course, what's the assessment structure, etc. Waste of lecture time in a 9-week term (Flex week don't count). To save time, I've made a video which you can access via the Lectures page.

Week 01 is Here!

Posted by John Shepherd 3 months ago.

And off we go ...

The first lecture is Monday 2pm in K-F8-G04, otherwise known as Law Theatre G04, a delightful theatre just off the main walkway down near Anzac Parade. Even has windows. Hopefully, it also has working audio-visual tech.

While you're waiting, there are a couple of polls that I'd like to use to gauge the class's background. Clearly, we don't assume you know anything about databases, but we will require you to do some simple Python programming later in the term (after Flex week), so you'll need to do some self-study if you're a complete Python newbie. If you're lucky enough to be enrolled in COMP2041, that should sort you out. If not, you could always sneak into the lectures or the course web site.

Welcome to COMP3311 25T1

Posted by John Shepherd 4 months ago, last modified 4 months ago.

Welcome to the fun-filled extravanganza that is COMP3311 a la jas and dylan.

Here's the Welcome Video . Maybe not up to the usual Lynchian* standards, but possibly more informative.

If you think you need to look at the Moodle site (you don't), try here .

* RIP David Lynch ... Eraserhead, Elephant Man, Dune (1984), Blue Velvet, Twin Peaks, Mulholland Drive, ...