Relational Databases, 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)

Barry Avery

One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *