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

	

		
 Course Work1   = 11%  (Individual Work Set 12th Nov, Returned 13th Dec)
		
 Course Work2a  = 11%  (Group Work [2/3] Set 7th Jan, Required 14 Feb)
		
 Course Work2b  = 11%  (Group Work [2/3] Set 7th Jan, Required 21 Mar)
		
 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:

• An Introduction to SQL and Oracle (Plasic Spine)
• Oracle SQL Practicals (Stapled Sheets)

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 (%)

Answers to Coursework

Practical 4 Create Database and Queries

Information Systems Techniques

Program Design

Systems & Networks 1

Artificial Intelligence

Systems Design

Systems & Networks 2

Computer Network Principles & Applications

Database Systems