G51DBS Database Systems 2009-2010
Last year's lecture slides, coursework and model answers,
previous exam papers and answers can be found
here.
Here are 2008-9 exam paper and answers:
Labs
Labs start on the 16th of February (Tuesdays 11-13 in A32).
Coursework
There will be 5 pieces of coursework,
each worth 5% of the final mark. Deadlines are: cw1 12 Feb, cw2 26 Feb, cw3
5 Mar, cw4 19 Mar, cw5 26 Mar. This year, there will be no optional cw6
available to everyone, it will only be for students who missed some of
cw1-cw5 due to illness or some other extenuating circumstances.
- Coursework 1 on E/R modelling: cw1 .
Deadline 12 February 15:00 submit to the School office (exceptionally by
email to me, see the coursework instructions).
You will need to use the material in lectures 3 and 4.
Solution will be published on the 20th of February (after this no
late submissions accepted), marks emailed before the 5th of March.
- Model answer to coursework 1 .
- Feedback lecture on coursework 1 (typo on slide 11 fixed: Drug:Volunteer was drawn as M:M and it
is 1:M).
- Before coursework 2:
set up an Oracle account.
- Coursework 2 on creating tables and inserting tuples: cw2 .
Deadline 26 February, but try to get it marked in the labs on the 16th and 23rd. Late submissions
possible until the 5th of March but marks will be deducted. On the 6th of March, model solution will be published.
Marks will be emailed before the 12th of March.
- Model answer to coursework 2 .
- Coursework 3 on SQL SELECT: cw3 .
Deadline 5 March, late submissions possible until 12 March.
Marks will be emailed on the 19th of March.
- Model answer to coursework 3 .
- Coursework 4: cw4 . Deadline 19 March, late
submissions possible until the 26th of March, solution will be published
on the 27th. Marks will be emailed on the 1st
of April.
- Model answer to coursework 4 .
- Coursework 5: cw5 . Deadline 26 March, 15:30 to the
School office. Late submissions possible until the 1st of April. Solution will
be published on the 2nd of April.
Added on the 16th of March: assume that we cannot have the same film
in the same cinema on the same day at exactly the same time on different
screens. This is to avoid a case when there are two identical tuples in the
table which represent showings of the same film on different screens, which
confused some people when defining candidate keys.
- Model answer to coursework 5 .
- Marker's comments on common mistakes in cw5
Lecture slides
This file is maintained by Natasha Alechina
Last updated June 30, 2010.