Tut/Lab Sessions Schedule

Subject to Change Without Notice

Coloured Line

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

Teaching Week	Tutorial Worksheet	Lab Worksheet	Exercise	Solution Notes
1 17/7	-----	-----	-----	-----
2 24/7	Tutorial 1 The Relational Model Sets Logic	Lab Session 1 SQL Queries	Exercise 1 SQL Query	Tutorial 1 Solution Notes Exercise 1 Solution Notes Queries against the SQL, Bugs, and Rock 'n' Roll Database Solution Notes
3 31/7	-----	-----	-----	-----
4 7/8	Tutorial 2 ER Diagrams	Lab Session 2 Copying Public Tables	Exercise 2 Copy One Public Table and Create One Row of Test Data	Tutorial 2 Solution Notes Exercise 2 Solution Notes
5 14/8	-----	-----	-----	-----
6 21/8	Tutorial 3 ER to Relational Conversion	Lab Session 3 Creating Views and Querying Views	Exercise 3 Create One View	Tutorial 3 Solution Notes Exercise 3 Solution Notes
7 28/8	-----	-----	-----	-----
*Lecture Break*	*Lecture Break*	*Lecture Break*	*Lecture Break*	*Lecture Break*
8 18/9	Tutorial 4 Relational Theory	Lab Session 4 Assignment X	Exercise 4 SQL Query using `max`	Tutorial 4 Solution Notes Exercise 4 Solution Notes
9 25/9	-----	-----	-----	-----
10 2/10	Tutorial 5 Transactions	Lab Session 5 Assignment 2	Exercise 5 SQL Query using a parameter	Tutorial 5 Solution Notes Exercise 5 Solution Notes
11 9/10	-----	-----	-----	-----
12 16/10	Tutorial 6 Integrity	Lab Session 6 Revision	Exercise 6 SQL Query using `nvl`	Exercise 6 Solution Notes Extra Queries 1 to 9 against the SQL, Bugs, and Rock 'n' Roll Database Solution Notes
13 23/10	-----	-----	-----	-----

Coloured Line

URL: http://computer/student/comp2400.2006/tutlabs/TutLabSchedule.shtml
Last modified: Monday, 30-Oct-2006 11:05:12 EST