This subject has a 1 hour tutorial every week. Tutorials mostly consist of exercises from the text book (Elmasri & Navathe 4/5th Edition). Tutorials are scheduled to meet 2 basic objectives: 

• To provide an opportunity to extensively practice and apply the techniques and concepts introduced in the lectures. Although the tutorial exercises are not handed in or marked, proficiency on these techniques and concepts will be assessed in the exams and assignments, and hence attendance and participation in the tutorials is extremely important
• To provide consultation to the students regarding theoretical component of the subject. As far as possible, questions in a particular session should be limited to the topic under discussion. 

The solutions to each week's  tutorial exercises will be made available online on Friday afternoon of the same week. The first tutorial will be in week 3. Questions will be announced on the web site and will also be provided for downloading/printing.

Click here for a glossary of database terms.

Click here for timetable and tutor allocations.

Tutorial 1 - Requirements Engineering
Questions [PDF]  Solutions [PDF]

Tutorial 2 - Entity-Relationship
Chapter 3 / Exercises 3.16, 3.17, 3.18, 3.19 (3rd Edition: no change) 
Questions [PDF]  Solutions [PDF]

Tutorial 3 - Relational Model
Chapter 5 / Exercises 5.1, 5.2, 5.4, 5.10 (3rd Edition: 7.1, 7.2, 7.4, 7.19)   
Questions [PDF]  Solutions [PDF]

Here is an online learning tool for the relational model: http://infs1200.ldbm.itee.uq.edu.au .

You need login with your UQ student account. Please finish this exercise in before 14 September 09.

(This exercise is not to be assessed).

Tutorial 4 - ER-Relational Mapping
Chapter 7 / Exercise 7.5 (3rd Edition: 9.13)   
Questions [PDF]  Solutions [PDF]

Tutorial 5 - Functional Dependencies
Questions [PDF]  Solutions [PDF] A Step-by-Step Solution by Tutor Ling Chen

Tutorial 6 - Normalization
Chapter 10 / Exercises 10.26, 10.27 (3rd Edition: 14.26, 14.27)   
Questions [PDF]  Solutions [PDF]

A tutorial system namely http://sqlzoo.net/  is good for you to practise SQL programming skills.

Here is a Tutorial Note on BCNF Normalization written by Angel Chan checked by Xue Li.

 

Tutorial 7 - Basic SQL
Chapter 8 / Exercise 8.10, 8.15, 8.17 (for the 3rd Edition Textbook: no change)

Extra SQL Exercises
Questions [PDF]  Solutions [PDF]

Tutorial 8 - More on SQL
Chapter 8 / Exercise 8.13, 8.14, 8.16 (for the 3rd Edition Textbook: no change)   
Questions [PDF] Solutions [Q1 PDF, Q2-3 PDF]     

Extra SQL Exercises

Tutorial 9 - SQL-Views
Chapter 9 / Exercise 9.14, 9.15 (3rd Edition: 8.18, 8.19)   
Questions [PDF] Solutions [PDF]