Academic year: 2002/2003
Lecturer: Marian
Ursu
| DAY | TIME | TYPE | PLACE |
| Tuesday | 16:00 - 17:00 | Lecture | MB154 |
| Wednesday | 09:00 - 10:00 | Lecture/Workshop/Seminar | MB256 |
| Wednesday | 10:00 - 11:00 | Lecture | MB256 |
| Wednesday | 11:00 - 12:00 | Lab A | WB300/316 |
| Wednsesday | 12:00 - 13:00 | Lab B | WB300/316 |
|
|
|
|
ACT |
|
|
Introduction to database systems | A1
A2 |
|
|
|
Introduction to the relational model and SQL | A3 | |
|
|
The relational model | ||
|
|
SQL |
|
|
|
|
SQL |
|
|
|
|
Reading week | ||
|
|
Semantic / conceptual modelling - the E/R and EE/R model |
|
A4
A5 |
|
|
Semantic / conceptual modelling - the E/R and EE/R model |
|
|
|
|
Normal forms | ||
|
|
Normal forms | ||
|
|
Normal forms
Revision |
|
| Week | Topic |
|
|
Unix
- basics
Unix - a basic tutorial When you think you are sufficiently confident with the commands listed in this tutorial, you can move to the next topic |
|
|
PostgreSQL
- basics you may find useful the tutorial available on Postgres's "Interactive
documentation page"
Read the advice for lab sessions |
|
|
PostgreSQL - DDL component;compare Postgres's SQL with the standard SQL |
|
|
PostgreSQL - DML component;compare Postgres's SQL with the standard SQL |
|
|
work on coursework |
|
|
Reading week |
|
|
Rules in Postgres |
|
|
Views and data security in Postgres |
|
|
The data dictionary in Postgres (and an application using Linux scripts) |
|
|
Microsoft Access and Connecting Microsoft Access with Postgres |
|
|
catch up with pending issues / explore new issues |
|
|
|
|
|
|
|
Databases
and web technologies
PHP and Java to Postgres Transactions - Generalities |
|
|
|
|
Data recovery |
|
|
|
|
Concurrency control |
|
|
|
|
Views | ||
|
|
Data security |
|
|
|
|
Reading week |
|
|
|
|
Query
optimisation
Active Database Concepts |
||
|
|
Distributed databases |
|
|
|
|
Limitations of the relational model and of relational databases |
|
|
|
|
Object
oriented databases
Logic databases and Knoweldge Based Systems |
|
|
|
|
Revision |
| ASSIGNMENT | SPECIFICATION | SUBMISSION |
| Coursework 1 | 9 October 2002 | 29 October 2002 |
| Coursework 2 | 13 November 2002 | 26 February 2003 |
| Coursework 3 | 5 February 2003 | 18 March 2003 |
| DAY | TIME | PLACE |
If you want to print the
solutions then there is no need to print the exam papers, because the questions
are repeated in the documents that contain the solutions.
| PAPERS | SOLUTIONS |
| Mock Exam Paper | |
| 1998/1999 Exam | 1998/1999 Solutions |
| 1999/2000 Exam | 1999/2000 Solutions |
| 2000/2001 Exam | 2000/2001 Solutions |
| 2001/2002 Exam | 2001/2002 Solutions |
| Date | Topic | Speaker |
| 28-01-2003 | Database Systems in the Financial Sector: A Trading and Inventory System | Dr. Richard Keeble (Goldman Sachs, London) |
| 11-02-2003 | Buidling a Content Management System | Mr. Danny Budzack, Head of Information Management and e-Government, Lewisham Council |
| 18-03-2003 | The CEP Programme - The Joining of Various Legacy Databases into one Central Database and the Development of New Applications (Part 1); Data Migration in CEP (Part 2) | Mr. Floyd Gleaves, Business Information Service and Technology Directorate, Home Office |