| Week | Module | Lecture Notes2 | Lecture Recordings |
Readings1 and Additional Material | Tutorials |
Practicals |
Assessment |
|
| 1 |
Introduction to the course Database Systems |
PPT PPT |
Monday 27.02 Wednesday 29.02 |
Chapter 1 | ||||
| 2 | Requirements Engineering | PPT |
Monday 5.03 Wednesday 7.03 |
Chapter 7 of
Hoffer,
George and Valacich, Modern Systems Analysis and Design 4th Edition Web Deli Example Handout in Class on Monday Presentation on making the Web Deli Context Diagram as shown in class on Wednesday | |
|||
| 3 | Entity Relationship Modelling | PPT |
Monday 12.03 Wednesday 14.03 |
Chapter 7 Web Deli Example - Solution for Level 0 DFD and Guidelines for getting started with ER | Tutorial 1 - Requirements Engineering Questions [PDF] Solutions [PDF] |
Get familiar with MS Access |
Database Assignment Issued |
|
| 4 |
Relational Model | Monday 19.03 Wednesday 21.03 |
Chapter 2 (2.1) Chapter 3 | Tutorial 2 - Entity-Relationship Questions [PDF] Solutions [PDF] |
Get familiar with MS Access | |||
| 5 |
ER to Relational Mapping | PPT |
Monday 26.03 Wednesday 28.03 |
Chapter 9 3 Examples handed out in lecture | Tutorial 3 - Relational Model Questions [PDF] Solutions [PDF] |
Designing a Relational Database | ||
| 6 |
FDs and Normalization | PPT |
Monday 02.04 Wednesday 04.04 |
Chapter 15 (excluding 15.6 & 15.7) Chapter 16 (16.1) Mock quiz 1 as discussed in class on Wenesday | Tutorial 4 - ER-Relational Mapping Questions [PDF] Solutions [PDF] |
Understanding Constraints in the Relational Model ER-Relational Mapping |
||
| 7 |
...cont In class Quiz^ |
|
Wednesday 18.04 |
Tutorial 5 - Functional Dependencies Questions [PDF] Solutions [PDF] |
Working with FDs |
In class Quiz |
||
| 8 |
SQL |
PPT |
Monday 23.04 |
Chapter 4 and 5 Optional Material on Design by Synthesis approach to Database Design FD and Normalization Examples (see also LDBM) FAQs on Normalization |
Tutorial 6 - Normalization Questions [PDF] Solutions [PDF] |
Normalization | ||
| 9 |
...cont |
Monday 30.04 Wednesday 02.05 |
Tutorial 7 - Basic SQL Questions [PDF] Solutions [PDF] |
Assignment Work | Database Assignment Due (Group + Individual) |
|||
| 10 |
...cont |
Wednesday 09.05 |
Tutorial 8 - Advanced SQL Questions [PDF] Solutions [PDF] |
SQL |
||||
| 11 |
In class Quiz^ SQL Views |
Wednesday 16.05 |
Advanced SQL Queries Class Exercises |
...cont |
SQL |
|||
| 12 |
DBMS Architecture |
Monday 21.05 Wednesday 23.05 |
Chapter 2 DBMS Languages (ppt presented in class on DDL, DCL and DML) |
Tutorial 9 - SQL-Views Questions [PDF] Solutions [PDF] |
SQL |
In class Quiz |
||
| 13 |
...cont Revision |
|
Revision |
Revision |
1Required reading for each module is given at the end of the lecture presentation. Readings are from the text book by Elmasri & Navathe (6th Edition), unless stated otherwise.
2PPT files are password protected - please access through your UQ (ITS) or ITEE login and password
Printing options 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
^In class quiz will be held in lecture theatre (Monday 10AM)