| ANU Home | Search ANU | Search FEIT
The Australian National University
Faculty of Engineering and Information Technology (FEIT)
Department of Computer Science
Comp2400 and Comp6240 - Relational Databases - Semester Two 2008

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.

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

The course text is Fundamentals of Database Systems, 5th edition, by Elmasri and Navathe, Addison-Wesley, 2007. Fourth edition is OK, and earlier ones too.

Also recommended, especially for high achieving students, is Principles of Database and Knowledge-Base Systems by Jeffrey D. Ullman, Computer Science Press, 1988.

Course information sheet. Course forum on StReaMS.

News

14:36 Friday 31 October - Last years exam paper can be obtained through the library, and the mid-semester test is available here. Sorry, no example answers will be provided.

17:53 Monday 27 October - Greg has a LOT of lab work and late assignments in his email intray, please be patient.

16:05 Thursday 23rd October - some Help for Assignment 2

10:20 Tuesday 14 October - Yes, there will be lectures after the break. Check the lectures page for details.

17:58 Monday 13 October - Students who want to review their mid-semester exam script should make an appointment with Ben (ben.lippmeier at anu.edu.au). Ben will be available for appointments between 2pm and 5pm Monday 20th October.

17:53 Sunday 12 October - assignment 2 is now available. It is due 5pm Friday 24 October.

16:47 Friday 26 September - Assignments can be collected from the DCS office.

19:40 Thursday 25 September - Today's lecture notes and recordings are up (lectures), mid-semester exam results should be visible on StReaMS, lab4 example solutions are on the StReaMS course forum, and have a nice break!

12:06 Wednesday 10 September - There will be a lecture next Wednesday 17th September.

11:46 Wednesday 10 September - Lab 4 will be held in the week 22-26 September instead of next week.

13:05 Tuesday 9 September - DON'T PANIC! If you are really having trouble with this course and wonder whether you will even be able to pass, I suggest you just really focus on the core material, the relational model and SQL. So read Chapters 5 and 8 of the text, and do some of the exercises there. Good luck with the exam tomorrow.

17:12 Thursday 4 September - Bad news for people trying to learn without showing up, there's no audio for the revision lecture. The rest of today's stuff is on the lectures page.

17:52 Monday 1 September - There will be no lecture this Wednesday.

19:25 Thursday 28 August - This weeks lectures are now there.

11:36 Tuesday 26 August - Example solutions for lab 1 are now available on the labs page.

17:38 Thursday 21 August - An updated version of the assignment has been uploaded, with 10 marks instead of 8. (There are 3 kinds of mathematician: those who can count and those who can't.)

10:42 Thursday 21 August - Here is assignment 1. It is due at 5pm, Friday 5th September. That means, really due. The "late penalty" is 100%. Assignments will only be accepted after the due date and time if we see written evidence before that time of some unforseeable situation that prevents timely submission.

19:18 Wednesday 20 August - The mid-semester exam is at Melville Hall at 12:50 on Wednesday 10 September. Here is last years paper.

11:52 Tuesday 19 August - There will be a lecture tomorrow, but its optional. It will be examples and exercises on very basic maths for those with weak math backgrounds. If you know what sets relations and functions are, you probably don't need to be there

19:57 Thursday 14 August - The slides, recordings, example assignment, solution proposal and associated .sql are all on the lectures page. They are not perfect, but good enough to get you an HD in this course. Feel free to discuss this on forum and suggest improvements.

20:05 Monday 11 August - The sections of the course listed in the lectures page now have some references to the text. I recommend reading Chapter 12 before this weeks lectures.

17:12 Thursday 7 August - Recordings of todays lectures are now on the lectures page.

11:11 Wednesday 6 August - The first of tomorrows lectures is now up on the lectures page.

15:51 Friday 1 August - Exercise sheets and .sql files for next weeks labs are now on the labs page.

16:08 Thursday 31 July - Recordings of todays lectures are now on the lectures page.

15:58 Thursday 31 July - The course information sheet is now online. More hard copies will be available at next Thursday's lecture.

15:06 Wednesday 30 July - Bit of bad news for non-lecture-attending students: the mp3 recording of today's lecture didn't work, the batteries went flat.

19:55 Tuesday 29 July - This weeks lecture slides will not be available until after the lectures, sorry.

17:54 Friday 25 July - Muhammad Atif is joining the teaching team as a tutor. Welcome!

16:20 Thursday 24 July - A second basic computer skills session for 9am Thursday 31 July is now on StReaMS

16:14 Thursday 24 July - First 30 minutes of todays 2 hour marathon are on the lectures page. Ran out of space on in my old mp3 stick, sorry.

20:58 Wednesday 23 July - Lecture slides for tomorrow might be "just in time", sorry.

17:00 Wednesday 23 July - Recording of today's lecture is now on the lectures page.

16:25 Wednesday 23 July - Comp6240 students should now be able to register for lab groups. Sorry about the delay there folks.

15:56 Wednesday 23 July - The one-off unix/linux computer skills session is now on StReaMS for registration.

19:08 Monday 21 July - The slides for the first lecture are now on the lectures page.

15:51 Friday 18 July - The lecture timetable has been changed. Lectures are now Wednesday 1pm-2pm and Thursday 2pm-4pm. I only found out about this yesterday afternoon!

20:45 Wednesday 16 July - Very broad outline of this years course is now on the lectures page.

19:30 Wednesday 16 July - Cong Huynh is joining the teaching team as a tutor. Welcome!

20:03 Wednesday 9 July - Hi, just setting up this years web page!

People

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

Student consultation time: not yet organised.

The course tutor is Ben Lippmeier, who will also be taking the lectures after the break.

We also have Kunnal Khiatani, Cong Huynh and Muhammad Atif tutoring.

Assessment

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

StReaMS for forums and tutorial group enrollment

Previous years 2007 2006 2005

Australian Government privacy site.

PostgreSQL

Notes on relational algebra and translation to/from SQL.

Brief overview of UML

A little more detail and advice on UML Class diagrams

The official UML definition (not easy reading, reference material)