ANU - Comp2400/Comp6240 - Relational Databases - Lectures
The Australian National University
Faculty of Engineering and Information Technology (FEIT)
Department of Computer Science
Computer Science
DCS Home
About DCS
Department News
What Is CS & IT?
Education
Research
People
Lab Registrations
Lab Status
Contact
Quick Links
ANU Home
FEIT Home
Search
Staff Pages
Comp2400/Comp6240 Lectures
course home page

The lectures will be on Wednesdays, 1pm-2pm in Physics lecture theatre, and Thursdays 2pm-4pm in Chemistry lecture theatre 1.

Course Outline

Elmasri and Navathe, Chapters 1, 2 and 3.
title date pdf for printing pdf slides mp3 recording
Lecture 1: Course Overview Wednesday, 23 July 2008 lecture01Print.pdf lecture01Slides.pdf lecture01.mp3
Lectures 2 and 3: The Relational Model and SQL Thursday, 24 July 2008 lecture02Print.pdf lecture02Slides.pdf lecture02.mp3 first 30 mins only sorry
Lecture 4: Database Design and DBMS Implementation Wednesday, 30 July 2008 lecture04Print.pdf lecture04Slides.pdf no recording

SQL and the Relational Data Model

Elmasri and Navathe, Chapters 5 and 8.
title date pdf for printing pdf slides mp3 recording
Lecture 5: Sets, Products, Relations, Functions Thursday, 31 July 2008 lecture05Print.pdf lecture05Slides.pdf lecture05.mp3
Lecture 6: The Relational Model: Updates and Integrity Thursday, 31 July 2008 lecture06Print.pdf lecture06Slides.pdf lecture06.mp3
no lecture onWednesday, 6 August 2008
Lecture 7: Updates and Integrity Constraints Thursday, 7 August 2008 lecture07Print.pdf lecture07Slides.pdf lecture07.mp3
Lecture 8: More SQL Thursday, 7 August 2008 no extra slides but see studentEG*.sql below lecture08.mp3

Student database example: studentEgCreateSchema.sql studentEgPopulate.sql studentEgViolations.sql studentEgQueries.sql studentEgDropSchema.sql

UML Class Modelling and Logical Database Design

Elmasri and Navathe, Chapters 3, 4, and 12.
title date pdf for printing pdf slides mp3 recording
Lecture 9: Modelling and Translation Wednesday, 13 August 2008 lecture09Print.pdf lecture09Slides.pdf lecture09.mp3
Lecture 10: Modelling and Translation Example Thursday, 14 August 2008 lecture10Print.pdf lecture10Slides.pdf lecture10.mp3
Lecture 11: Example Continued Thursday, 14 August 2008 no extra slides but see pickpackEg* below lecture11.mp3

Warehouse Pick and Pack example: requirements statement (last year's Assignment 1), pickpackEgProposal.pdf (new version uploaded 14:18 Friday 15 Aug), pickpackEgCreateSchema.sql pickpackEgPopulate.sql pickpackEgQueries.sql pickpackEgDropSchema.sql

Relational Algebra and Relational Calculus

Elmasri and Navathe, Chapter 6.
title date pdf for printing pdf slides mp3 recording
Lecture 12: Revision - Sets, Products, Relations, Functions Wednesday, 20 August 2008 lecture12Print.pdf lecture12Slides.pdf lecture12.mp3 (possibly incomplete?)
Lecture 13: Relational Algebra Thursday, 21 August 2008 lecture13Print.pdf lecture13Slides.pdf having trouble with mp3 recorder
Lecture 14: More Relational Algebra Thursday, 21 August 2008 lecture14Print.pdf lecture14Slides.pdf
Lecture 16: Relational Calculus and Logic Thursday, 28 August 2008 lecture16Print.pdf lecture16Slides.pdf lecture16.mp3
Lecture 17: Thursday, 28 August 2008 lecture17.mp3

Web Interfaces and PHP

title date notes mp3 recording
Lecture 15: (Guest lecturer Bob Edwards on web database deployment) Wednesday, 27 August 2008 Bob's lecture notes lecture15.mp3
The little example php code, dbtest.php. Similar examples on the PHP web site.

Privacy, Security, Responsibility and Ethics

Elmasri and Navathe, Chapter 23, Australian government privacy web-site.
title date pdf for printing pdf slides mp3 recording
Lecture 18: Security and Privacy Thursday, 4 September 2008 lecture18Print.pdf lecture18Slides.pdf lecture18.mp3
Lecture 19: Revision for Mid-Semester Exam Thursday, 4 September 2008 lecture19Print.pdf lecture19Slides.pdf I don't know why file size = 0 bytes

Functional Dependencies and Normal Forms

Elmasri and Navathe, Chapter 10 (and to a lesser extent 11).
title date pdf for printing pdf slides mp3 recording
Lecture 20: Functional Dependencies and Normalisation Thursday, 11 September 2008 lecture20Print.pdf lecture20Slides.pdf lecture20.mp3
Lecture 21: Functional Dependencies and Normalisation Thursday, 11 September 2008 lecture21Print.pdf lecture21Slides.pdf lecture21.mp3
Lecture 22: Reasoning about Functional Dependencies Wednesday, 17 September 2008 lecture22Print.pdf lecture22Slides.pdf lecture22.mp3
Lecture 23: A BCNF Example, and more! Thursday, 18 September 2008 lecture23Print.pdf lecture23Slides.pdf lecture23.mp3
Lecture 24: Decomposition and Synthesis Thursday, 18 September 2008 lecture24Print.pdf lecture24Slides.pdf sorry guys, batteries again
Carol Edmonson's lecture slides on this topic (lectures 16, 17, 18 and 21) from 2006 are also highly recommended.

Transactions and Recovery

Navathe and Elmasri, Chapters 17, 18 and 19.

title date pdf for printing pdf slides mp3 recording
Lecture 25: Transactions and their Schedules Thursday, 25 September 2008 lecture25Print.pdf lecture25Slides.pdf lecture25.mp3
(no additional slides) Thursday, 25 September 2008 lecture26.mp3

Query Processing and File Access

Navathe and Elmasri, Chapters 13, 14 and 15.

6 lectures by Ben Lippmeier, and a tutorial