[Lectures]   [Lecture Schedule] [Course Information]   [COMP2400/6240 Home]
Coloured Line

Lecture Schedule

Subject to Change Without Notice

Coloured Line

Lectures will not be held on public holidays.
Other lecture slots in which a lecture will not be held are indicated by  -----.

Links to lecture outlines will become operational during the semester
This web page may contain links to draft versions, or to updated versions, of Lecture Outlines.

You may like to look at the Lecture Overheads from last year .
Note that significant changes have been made to this course since last year.


Teaching
Week 		Monday
12:00-13:00
MCC T3 		Thursday
15:00-16:00
MCC T2 		Friday
10:00-11:00
MCC T3
1
17/7

Lecture 01

Introduction to COMP2400/6240

The Relational Model

Lecture 02

Sets

Logic

Lecture 03

SQL

select
2
24/7

Lecture 04

Database Systems

create table

drop table

Lecture 05

Metadata

select

Lecture 06

Test Data

insert

update

delete
3
31/7

Lecture 07

Conceptual Modelling

ER Diagrams

Lecture 08

Entities in ER Diagrams

Lecture 09

Relationships in ER Diagrams
4
7/8

Lecture 10

Primary Keys and Foreign Keys in Relational Tables

Joining Tables in SQL

Set Membership in SQL

Lecture 11

Nulls in SQL

Subqueries in SQL

Set Operations in SQL

 Lecture 12

Aggregation in SQL

alter table
5
14/8 		Lecture 13

ER to Relational Conversion

 Lecture 14

Views

create view

drop view

 Lecture 15

Relational Algebra

select_list
6
21/8 		Lecture 16

Functional Dependencies

 Lecture 17

Keys

 Lecture 18

Normal Forms
7
28/8 		Lecture 19

Revision by Request
Lectures 01-15

ER Diagrams

Mid-Semester Exam

-----
Lecture Break Lecture Break Lecture Break Lecture Break
8
18/9 		Lecture 20

Mid-Semester Exam Feedback

 Lecture 21

Finding Candidate Keys Using FDs

Parameters in Oracle SQL

-----
9
25/9 		Lecture 22

search_condition

Assignment 1 Feedback

 Lecture 23

Transactions

Database Recovery

-----
10
2/10 		Labour Day Lecture 24

Grants and Roles

-----
11
9/10 		Lecture 25

Integrity

 Lecture 26

Modification Anomalies

-----
12
16/10 		Lecture 27

Trouble I've Seen

 Lecture 28

Not Worth Living

-----
13
23/10 		Lecture 29

Many Forms of a Fact

 Lecture 30

All's Well That Ends

-----

[Top]

Coloured Line

Carol Edmondson   <carol@cs.anu.edu.au>
URL: http://computer/student/comp2400.2006/lecs/LectureSchedule.shtml
Last modified: Wednesday, 11-Oct-2006 19:47:20 EST