Database Systems

These pages support CS2 and CSP3 students studying Database Systems. Updates will be made at weekends to include all new activities and data picked up at the Thursday lectures. Check back weekly to see what's new.


SDD Coursework Project Groups



Systems Marking Schemes


	
  1. Course Work1 = 11% (Individual Work Set 12th Nov, Returned 13th Dec)
  2. Course Work2a = 11% (Group Work [2/3] Set 7th Jan, Required 14 Feb)
  3. Course Work2b = 11% (Group Work [2/3] Set 7th Jan, Required 21 Mar)
  4. Exam = 67%


Resources


There does not appear tom be any course delivery information on the UoH website for this course. The best we have is the paper timetable distributed in week 2.
Database Systems HomePage
Free Toad Software Download
Oracle Homepage
PDF Files of 1999 and 2000 DS Exam Papers
Answers to 1999 and 2000 DS Exam Papers

Don't forget to pick up the two books from the Information Sciences Reception:

Please note: I have looked through the first one and there are a number of errors in the text which may catch you out as follows:

  1. Page 10 Query 14 change MAX to SUM
  2. Page 12 Query 24 change '9' to 'p9'
  3. Page 13 Query 32 change minus (-) to underscore (_)
  4. Page 13 Query 32 remove the space in front of percent (%)
There are probably more, but that's enough to get on with.

Answers to Coursework

Practical 4 Create Database and Queries

FIG Coursework ER and Queries

Ivory Towers Coursework ER, DB files and Queries

Information Systems Techniques

Program Design

Systems & Networks 1

Artificial Intelligence

Systems Design

Systems & Networks 2

Computer Network Principles & Applications

Database Systems