Database Systems COMP3311 24T1

Open Office Hours

Posted by Yuekang Li Thursday 25 April 2024, 01:18:48 PM.

Hi Class,

I'm coming back to Sydney this weekend.
I'll host open office hours next week to answer your questions.

You can find me @ K17 Lv5 508 Consultation Room on:
15:00-17:00 2nd May Thursday.
10:00-12:00 3rd May Friday.

Previous Exam Papers

Posted by Yuekang Li Thursday 25 April 2024, 01:09:23 PM.

Hi Class,

Here are some of the previous exam papers for your reference: https://webcms3.cse.unsw.edu.au/COMP3311/24T1/resources/97973

Please note that you are allowed to bring one A4 page of cheatsheet to the exam this term. Make good use of it.

Allowed Materials for Final Exam

Posted by Yuekang Li Monday 22 April 2024, 03:20:39 AM.

In the final exam:

You will be given:

• documents for Postgres16
• documents for psycopg2
• documents for python3

In addition, you are allowed to bring:

• 1 A4 page of your own cheatsheet (you can play with the font size as far as you can read your notes; you can use both sides of the paper)

You will NOT be allowed to use any AI assistants.

The rationale is:
Most exam questions do not require memorization of a large chunk of knowledge/text. Don't waste your time looking for information in the excessive materials unless you really need to do so.
You are the one who knows the best about yourself. You should know whichever part of the course is hard or requires additional notes for yourself. Different people may have different "hard" parts. So prepare your own unique cheatsheet that fits the best for you!

Additional Exercises for Normal Form and Serialisability Calculations

Posted by Yuekang Li Monday 22 April 2024, 03:10:58 AM.

Hi class, I added more examples for you to practice the calculation of normal forms and serializability:
https://docs.google.com/presentation/d/11Bg7WHAGGPCPAhav55GlKG-DMcTRV-Tum7YpyUDZInM/edit?usp=sharing
The examples are organized in this way:

Example-1: Practice BCNF and 3NF - Both will yield the same result after normalisation.

Example-2: Practice BCNF and 3NF - They will have different results after normalisation.

Example-3: Practice conflict serializability and view serializability - The example is not serializable for both standards to complement the examples in the original lecture notes.

Again, please don't just recite the algorithms. Comprehend them instead!