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)