Skip Navigation | ANU Home | Search ANU | Search FEIT | Feedback

Comp2400 and Comp6240 - Relational Databases - Semester Two 2007

This course aims to provide an understanding of relational databases. The central topics are the relational data model, and SQL. This will include a little of the underlying mathematics and notions of intergrity, constraints and normalisation. We will also learn conceptual modelling for database design and DBMS techniques for performance, security and recoverability.

Here is the course outline handout.

This page will be updated frequently with news, lecture notes, lab exercises and handouts. Bookmark it and come back often!

News

12:57 Friday 26 October - Greg now has the remaining assignments from Kunnal's groups, so they can be collected this afternoon during consultation time. It was Greg's bad, not Kunnal's that they were not available this morning, sorry.

11:32 Friday 26 October - Todays notes and mp3 are now on the lectures page. Probably worth a look, since it gives a good idea of whats in the exam :-)

19:43 Wednesday 24 October - Extra consultation time this Friday, 26 October 3-5pm N322.

20:13 Sunday 21 October - Assignment 2 submission has been working for a while, but for those of you waiting for some instructions to appear here, you do
submit comp2400 Assignment2 ass2.txt
from a unix shell in one of the DCS machines. (Or comp6240 if that's your course.) You can ssh in if that's more convenient.

19:17 Sunday 21 October - Solutions to labs 3 through 5 are now available. Warning! There may be mistakes - if you think a solution is wrong, please ask.

11:08 Friday 19 October - No lecture on Tuesday 23 October. Time to start revising for the exam!

23:55 Monday 15 October - Lab 6 is now available from the labs page.

18:13 Sunday 7 October - Here is assignment 2. Its due on Monday 22 October at 5pm. Submission will be electronic, so put your work in a plain text file ass2.txt. Technical submission details coming soon.

14:02 Friday 28 September - Approval has been granted for the marking scheme to change to a "redeemable" one, so if you do better in the final exam than you did in the mid-test, the final will count for 70% and the mid-test for nothing.

People

The lecturer is Greg O'Keefe greg.okeefe@anu.edu.au

Student consultation time: Thursday from 3pm to 5pm in DCS room N322.

The course tutor is Robin Garner robin.garner@anu.edu.au

We also have Kunnal Khiatani u4341119@anu.edu.au and Linda Buisman linda.buisman@rsise.anu.edu.au as tutors.

Assessment

revised 28 September 2007

For both courses, the assessment will be

if final exam result is better than the mid-semester exam
70% - Final Exam
20% - Assignments (2 at 10% each)
10% - Laboratory exercises
otherwise
50% - Final Exam
20% - Mid-Semester Exam
20% - Assignments (2 at 10% each)
10% - Laboratory exercises

Some questions in the exam and the assignments will have a version for the undergraduates (Comp2400) and a version for the postgraduates (Comp6240).

Links

Australian Government privacy site.

lecture notes and recordings, Lab exercises StReaMS for forums and tutorial group enrollment

Example Mid-Semester test

Assignment 1, Assignment cover sheet, assignment 1 marking guide

PostgreSQL, Notes on relational algebra and translation to/from SQL, Reading on UML Class diagrams

Lecture notes from 2006 (sorry some links are broken in there)

ACM Programming Contest http://www.sppcontest.org