Lecturers: Dr. John Old, Dr. Uta Priss
|
Study materials: G. Russell's Online Notes Tutorial Notes Table of Contents Student Notes |
Coursework Resit Coursework Resit support |
When is the exam?
Exam preparation: Past papers Revision Questions |
Resources: SQL Quick Reference Normalisation Overview ER diagram for jobs database Musician's database |
Search database resources:
 Custom Search |
| Week No | Lecture A | Lecture B | Practical | Revision |
|---|---|---|---|---|
| 02 | Introduction | SQL1, tutorial info | On-line SQL | |
| 03 | public holiday | no lecture | Continue with On-line SQL | |
| 04 | AND, OR and NOT (printable copy) puzzle (with solution), ER1 | SQL2 | Continue with On-line SQL | Quiz1 Answers |
| 05 | ER2 | SQL3 | Continue with On-line SQL | |
| 06 | ER3 | SQL4, SQL Extra | MySQL practical | Quiz2 Answers |
| 07 | ER4 , Tutorial 1 Answers | Normalisation1 | On-line ER practical | |
| 08 | Admin and Security | Review, Normalisation2 | On-line Normalisation practical | |
| 09 | Relational Algebra 1 | Time for coursework | ||
| 10 | Embedded SQL | Relational Algebra 2, Equivalence | Coursework demonstrations | |
| 11 | Transactions, Concurrency | Visualising DB Data | Coursework demonstrations | Quiz |
| 12 | Recovery, example | DBMS Implementation | no practical | |
| 13 | Revision, Possible exam questions will be discussed. | no practical | ||
To pass the module, students need to achieve an overall mark of 40% and at least 30% in the exam and in the coursework. (For example, a student could pass with 46% in the exam, 30% in the coursework. Another student could pass with 30% in the exam, 55% in the coursework).
Resit students need to achieve 40% in any component that they are resitting.
Past papers are available at the past papers webpage. (Several of the 2002 exams contain the solutions at the end.)
Sample solutions to multiple choice questions (similar to the ones in the exam) can be found in the on-line multiple choice quiz.
