Lecturers: Dr. Uta Priss, Dr. John Old
|
Study materials: G. Russell's Online Notes Tutorial Notes Table of Contents Student Notes |
Coursework Coursework FAQ Coursework Solutions Resit Coursework Resit support |
Exam preparation: Past papers Revision Questions |
Resources: SQL Quick Reference Normalisation Overview ER diagram for jobs database |
Search database resources:
 Custom Search |
| Week No | Lecture A | Lecture B | Practical | Revision |
|---|---|---|---|---|
| 02 | Introduction | SQL1 | On-line SQL | |
| 03 | AND, OR and NOT (printable copy) puzzle (with solution), | SQL2 | Continue with On-line SQL | |
| 04 | ER1 | SQL3 | Continue with On-line SQL | Quiz1 Answers |
| 05 | ER2 | SQL4 | Continue with On-line SQL | |
| 06 | ER3 | Normalisation1 | MySQL practical | Quiz2 Answers |
| 07 | ER4 , Tutorial 1 | Normalisation2 | On-line ER practical | |
| 08 | Admin and Security | Normalisation Review | On-line Normalisation practical | |
| 09 | SQL Extra | Relational Algebra 1 | Time for coursework | |
| 10 | Embedded SQL | Relational Algebra 2, Equivalence | Coursework demonstrations | |
| 11 | Transactions, Concurrency | DBMS Implementation | Coursework demonstrations | Quiz |
| 12 | Recovery, example | DB visualisation | 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.
The exam consists of 40 multiple choice questions, each question having 5 options. No negative marking is used.
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.
