Category: Databases

These are materials for the first week of Database Systems

BB3103 Module handbook 1011
Reintroduction to the relational database model
1. Introduction into databases
Database session 1, Database session 2

You should attempt the exercises in the Access notes (in session 1 and 2), and read the Introduction to Databases (chap 1) and Database environment (chap 2) chapters in Connelly & Begg

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)