Relational Databases Session 3
database 3 2007 handouts 3 slides (PDF) on cartesian product and joins
sqlsession3 (PDF), containing material on CPs and joins in relational algebra and SQL.
Practical work in SQL is done using Office 2007 – session3 2007.accdb (zipped accdb file) is available for the second set of exercises
database 3 join extra 2007 3 slides handouts on different types of Join
session3 extras 2007.accdb for extra slides
Relational Databases Session 2
As there is a Union meeting this week, there won’t be a lecture. The taught part of the database material has been uploaded as a video. You should watch this BEFORE the labs on Wednesday or Friday.
You can download the slides used in this video as a handout database 2 slides
The lab exercises on databases sqlsession2 (PDF), contain material on selection in relational algebra and SQL.
Practical work in SQL is done using Office 2010 – for this session you can use the database you downloaded for session 1
Relational Databases Session 1
Lecture Slides: relational database slides handout 1 (PDF) on the relational model
Lab exercises sqlsession1 2010 (PDF Office 2010), containing an introduction to the relational model, relational algebra and projection in SQL.
Practical work in SQL is done using Office 2010 – session1 2010.accdb (zipped accdb file) is available for the first set of exercises
Here are the tables as SQL statements SQL table creation
The same lab exercises are available for Office 2007 if this is the version you are using sqlsession1 (PDF Office 2007)
Video from a symposium organized by Finland’s Technology Academy Foundation, found at Beet.TV