Fundamentals of Relational Databases CS252 - 2009/10

Last year's page can be found here.

Exam Info

Feedback from your Exam

Find a mockup exam here. You can obtain old exams from the secretary, or from the web .

Aims and Objectives

The academic aims, learning outcomes and module content are described here.

This course is a pre-requisite for 'CS253 - Topics in Database Systems'


Hugh Darwen's book, a free download, is based closely on his contribution to CS252.  Its structure and content mirror his lectures.  Much of the lecture material for the whole module is also covered in Date. The Date book "Database Systems" may be useful for those students going on to take the 3rd year Theory of Databases course. The Connolly & Begg book has good material on data modelling. In general, the newer books have better examples and more detailed chapters on SQL. You will find plenty of web resources for SQL, and tutorials on SQL (some links are provided below). The "Database in Depth" book is cheaper but still covers a lot of the material.

H. Darwen, An Introduction to Relational Database Theory, ISBN 978-87-7681-500-4 Bookboon

C. Date, "An Introduction to Database Systems", Addison-Wesley Longman, 2003 (8th ed.)

C. Date, "Database in Depth: The Relational Model for Practitioners", O'Reilly, 2005

C. Begg, T. Connolly, "Database Systems: A Practical Approach to Design, Implementation and Management (International Computer Science S.)", Addison-Wesley Longman, 2004 (4th ed.)

C. Date, "The Relational Database Dictionary", O'Reilly, 2006

Module Organisers

Dr Meurig Beynon (module organizer)
Dr Alexandra Cristea
Hugh Darwen (web), Room 115 (invited lecturer)
Zabin Visram (web), Room 115 (part-time)
Adrian Hudnott (Tutorial-D, Oracle, discussion site support)

Lecture Timetable Term 1, 2009/10

Term starts on Monday 5th October, therefore the first CS252 lecture will be on the 6th October


Tuesday 1:05pm, room F107

Thursday 1:05pm, room F107

Friday 1:05pm, room SO21


Monday 2pm, room CS101
Monday 3pm, room CS101

1 (5Oct-9Oct)


SQL Part 1 with notes and pdf ; pdf slides only and old pdf

Values, Types, Variables, Operators

Worksheet 1


2 (12-16Oct)

Predicates and Propositions

SQL Part 2 with notes and pdf ; pdf slides only and old pdf

Relational Algebra, Part I

Worksheet 2

Seminar 1

3 (19-23Oct)

Relational Algebra, Part II

SQL Part 3 with notes and pdf; pdf slides only and old pdf

Relational Algebra, Part III

Worksheet 3

Seminar 2

4 (26-30Oct)

Constraints and Updating

SQL Part 4 with notes and pdf; pdf slides only and old pdf

Database Design I

Worksheet 4

Seminar 3

5 (2-6Nov)

Database Design II

SQL Part 5 with notes and pdf; pdf slides only and old pdf


Worksheet 5

Seminar 4

6 (9-13Nov)





Seminar 5


Worksheets will be handed out in lectures and should be attempted before the seminar for that worksheet.


Seminars will be held by Zabin Visram on Monday’s in Room CS101 at 2pm and  3pm. The seminars will be used to go through the exercise sheets and answer any queries about SQL.

SQL Resources

Oracle 9i is available on the ITS machine mimosa. To set this up for the first time you should log on and enter:

$ orasetup

Then logout and use the command sqlplus / to enter the SQL terminal client.

$ sqlplus / Press OK on the login screen - you do not need to enter a username or password.

Oracle Support

If you have a problem with the Oracle system on mimosa then please contact the IT Services Help Desk

Online Resources

Oracle 9i Documentation
A First Course in Databases
Tutorial D Reference

Rel Resources

How to run Rel at DCS
Rel Homepage


The coursework will comprise an assignment (worth 30%) given out during the lecture on Thursday the 5thth of November, Week 5 (and will appear here). The deadline is Friday 4th of December (Week 9), noon (12:00 midday).

The Exam

The exam schedule can be found at Examination Timetables.

Past Exam Papers

Past exam papers are available for download from here and questions can be asked on the module forum or by email.

More Information...

Please check the latest posting on the course newsgroup or forum :


Valid HTML 4.01!