Copies of overheads from the lectures will be available for viewing
below. Generally they will be available within 24 hr after the
lecture. (See lecture overheads from 2004 for a preview.)
Note that in most cases the overheads list topic headings and
references to figures in the textbook; the actual lecture is an
exposition or discussion of the topic. You should appreciate that
much more can be covered in a 50 minute lecture, than is in the
lecture notes, which can be read in 5 minutes.
- 19-07-2005 Introduction [PS, PDF for viewing], [PS, PDF 4-up for printing]
- 20-07-2004 Intro to SQL; DDL statements; single table
SELECT
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
21-07-2005 cont. SQL*Plus Session
Log
See Examples for example SQL files used
in the lecture.
- 26-07-2005 SELECT statements
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
SQL*Plus Session Log
Examples
- 27-07-2005 SELECT statements cont.
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
SQL*Plus Session Log
Examples
- 28-07-2005 SQL SELECT aggregation
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
SQL*Plus Session Log
Examples
- 02-08-2005 SQL SELECT other
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
SQL*Plus Session Log
Examples
- 03-08-2005 SQL SELECT final / Relational Data Model
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
SQL*Plus Session Log
Examples
- 04-08-2005 Relational Data Model - Structure,
Constraints - Codd's Rules
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 09-08-2005 Relational Data Model -
Constraints, Operations
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 10-08-2005 Database Design / Entity-Relationship
Modeling
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 11-08-2005 ER Diagrams (cont.)
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
16-08-2005 Review of SQL SELECT
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
SQL*Plus Session Log
- 17-08-2005 Functional Dependencies and Normal Forms
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 18-08-2005 Functional Dependencies and Normal Forms
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
23-08-2005 (cont)
- 24-08-2005 Normalisation
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 25-08-2005 Relation Decomposition
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
30-08-2005 (cont)
- 01-09-2005 Mapping ER Diagram to relations
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 20-09-2005 Integrity Constraints in Oracl9i
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 21-09-2005 Integrity Constraints - SQL Standard
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 22-09-2005 VIEWs
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 27-09-2005 VIEWs (cont.)
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 28-09-2005 Database Security
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 29-09-2005 Database Security - ROLEs
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 04-10-2005 Transactions
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 05-10-2005 Concurrency Control - Serializability
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 11-10-2005 Concurrency Control - Locking
[PS, PDF for viewing],
[PS, PDF for printing]
- 12-10-2005 Concurrency Control - Other Approaches
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
13-10-2005 Review of VIEWs, GRANTs, ROLEs (lec19-lec22)
- 18-10-2005 Database Recovery
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
- 19-10-2005 Database Recovery (cont.)
[PS, PDF for viewing],
[PS, PDF 4-up for printing]
Back to COMP2400 page
Lecture Overheads from 2004
For students who want to see what topics are likely to be covered
next, the 2004 Lecture Notes will give
a good indication. Most of the material will be covered in a very
similar way this year, but there may be some changes in some parts
of the course.
