Lectures

This course has three hours of lectures every week. There are 8 modules in this course, which will be covered during lecture time.

A Plan of Weekly Lectures can be seen from here.

These modules are given as below:

Module		Lecture Notes²	Lectopia link (Available Weekly after lecture)	Class Exercises, Additional Notes	Readings¹
	Introduction to the course	PPT, Screen, Handout	10-10:50am, 27/7/09		Course Profile
Module 1:	Database Systems	PPT, Screen, Handout	as above		Chapter 1
Module 2:	Requirements Engineering	PPT, Screen, Handout	2-2:50pm, 27/7/09 10-11:50am, 2-2:50pm, 3/8/09	Web deli example (DFD) Getting started with DFD for Web deli	Chapter 7 of Hoffer, George and Valacich, Modern Systems Analysis and Design 4th Edition
Module 3:	Entity Relationship Modelling	PPT, Screen, Handout	10-11:50am, 2-2:50pm, 10/8/09	Web deli example (DFD)	Chapter 3, Chapter 4 (4.1 - 4.3, 4.7) A Reference Paper by P.P. CHEN
Module 4:	Relational Model	PPT, Screen, Handout	10-11:50am, 2-2:50pm, 17/8/09	Web deli example (Mapping)	Chapter 2 (2.1), Chapter 5
Module 5:	ER to Relational Mapping	PPT, Screen, Handout	10-11:50am, 2-2:50pm, 24/8/09	More mapping examples Online Exercise (Please finish it before 14/09/09)	Chapter 7
Module 6:	FDs and Normalization	PPT, Screen, Handout	10-11:50am, 2-2:50pm, 31/8/09 10-11:50am, 2-2:50pm, 7/9/09	FD and Normalization FAQ A Simple Guide to Five Normal Forms	Chapter 10, Chapter 11 (11.1)
Module 7:	SQL	PPT, Screen, Handout	10-11:50am (picture lost) 2-2:50pm, 14/9/09 10-11:50am (picture lost) 2-2:50pm, 5/10/09 10-11:50am, 2-2:50pm, 12/10/09	An Online Tutorial by SQLZoo Extra SQL Exercises	Chapter 8
Module 8:	DBMS Architecture	PPT, Screen, Handout	10-11:50am, 2-2:50pm, 19/10/09		Chapter 2, Chapter 9 (Optional)
	Course Revision and Discussions on Final Exam.	PPT, Screen, Handout (No afternoon lecture)	10-11:50am,26/10/09^new ~~2-2:50pm~~ (Only morning lectures)		www.itee.uq.edu.au/~infs1200/Exams/

¹Required reading for each module is given at the end of the lecture presentation. Readings are from the text book by Elmasri & Navathe (4th Edition), unless stated otherwise.

²PPT files are password protected - please access through your UQ (ITS) or ITEE login and password

Printing options will be made available through POD (Print on Demand).

To better meet learning requirements, slight variations of these files may occur during the course of the semester. Updated version if and when provided, will be announced on the website