Archive

Archive for October, 2009

Relational Databases Session 3

October 24th, 2009 No comments

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

Categories: Databases Tags:

Relational Databases Session 2

October 24th, 2009 No comments

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

Categories: Databases Tags:

Relational Databases, Session 1

October 24th, 2009 No comments

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)

Categories: Databases Tags:

Video interview with Tim Berners-Lee

October 14th, 2009 No comments

Video from a symposium organized by Finland’s Technology Academy Foundation, found at Beet.TV