Don't forget to fill out the SES survey
There should be a link on your course's Moodle page
There's a description of the database for Assignment 2 if you want to start looking at it while I continue to populate the database and finish off the assignment spec. There's a highly annotated ER model and a minimally-commented SQL schema . The assignment will require you to write three Python+psycopg2 scripts for extracting data from this database. You can also write SQL views and PLpgQSL functions to assist the Python scripts. We'll give you templates for all of these. We'll talk about Python+psycopg2 in the online sessions this week.
There are two new prac exercises and more on the way.
I hope to have Assignment 2 ready for Monday Week 7. It involves using Python to access a MyUNSW-like student database. It'll be due at the end of Week 9.
If you didn't know, our degrees are currently accredited by the Australian Computer Society (ACS).
This means that you qualify for membership of the ACS when you graduate.
ACS are visiting CSE next week to re-accredit all our degrees. They want to meet (virtually) with students to find out what you think of your degree and how it's preparing you to work in the IT industry.
They plan to meet students over Zoom on Wed 20 October 10.30-11.30.
If you're interested in representing CSE as a student, send email to email@example.com