Information Systems II

This material relates to a second-year course on data analysis and design for a database applications. My contribution was to run SQL workshops and surgeries for the students.

Contents

This Web page contains:

Some useful references

The following references might be useful.

Back to the table of contents.

Workshops

The following table lists the workshops. The column headed Workshop gives links to ppt files that contain the presented material. The column headed Other material gives reading and other material relevant to the workshop. The column headed Glossary lists technical terms appropriate to the workshop. Some of the terms will be used in the workshop presentation, but perhaps not all of them. You might need to consult other sources of information to find out about them.

Date Workshop Other material Glossary
Tuesday 21 February Workshop 1 (Data definition language) Connolly and Begg, Chapter 5, introduction and sections 5.1 to 5.2; Chapter 6.
There is information about some commands available in the Oracle SQL*Plus environment.
The CD Library exercise will be used in this workshop.
@ command, ALTER TABLE statement, anonymous constraint, CONSTRAINT clause, CREATE TABLE statement, DROP TABLE statement, EDIT command, FOREIGN KEY option, host string, INSERT statement, integrity constraint, INTO clause, named constraint, PRIMARY KEY option, PROMPT command, REFERENCES option, SQL*Plus, VALUES clause.
Tuesday 28 February Workshop 2 (Data manipulation language) Connolly and Begg, Chapter 5, sections 5.3 to 5.3.4.
The Lending Library exercise,
the CD Library exercise,
and the University Students and Staff exercise will be used in this workshop.
AND keyword (two uses), ASC option, BETWEEN keyword, column alias, COUNT function, DISTINCT option, equijoin, FROM clause, GROUP BY clause, inner join, IS NULL keyword, LIKE clause, non-equi-join, NOT keyword, OR keyword, ORDER BY clause, SELECT statement, WHERE clause.
Tuesday 7 March Workshop 3 (More data manipulation language) Connolly and Begg, Chapter 5, sections 5.3.5, 5.3.7, and 5.3.9.
The Lending Library exercise,
the CD Library exercise,
and the University Students and Staff exercise will be used in this workshop.
EXCEPT keyword, FULL JOIN keyword, INTERSECTION keyword, LEFT JOIN keyword, nested query, ON clause, RIGHT JOIN keyword, UNION keyword.
Tuesday 14 March Workshop 4 (Updates and Triggers) Connolly and Begg, Chapter 5, section 5.3.10; Chapter 8, section 8.2.7; Chapter 28, section 28.4.12.
The Lending Library exercise,
and the University Students and Staff exercise will be used in this workshop.
AFTER clause, BEFORE clause, CREATE TRIGGER statement, DELETE keyword, DELETE statement, DROP TRIGGER statement, FOR EACH ROW option, FOR EACH STATEMENT option, FROM clause, INSERT keyword, ON clause, SET clause, trigger, UPDATE keyword, UPDATE statement, WHEN clause, WHERE clause.

Surgeries

There are three one-hour surgeries to help with SQL problems that you encounter while trying to work the CA assignment.

Back to the table of contents.


Last updated on 12 September 2006.