2004/2005, term 2, lecturer: Marian Ursu
| Day | Time | Type | Venue |
| Monday | 10:00 - 11:00 | Lab | WB300/WB316 |
| Monday | 11:00 - 12:00 | Lab | WB300/WB316 |
| Monday | 14:00 - 15:00 | Lecture | Small Hall |
| Monday | 15:00 - 16:00 | Lecture | Small Hall |
| Monday | 15:00 - 17:00 | Seminar/Lecture | Small Hall |
| Week | Main Topic | Details | Notes 2004-2005 | Notes 2003-2004 |
| 1 | Database Design Methodology - overview | Methodology
Overview Requirements Specification (data and transaction) ER/EER modelling Transformation of ER/EER model into Relational Model Validation of Relational Model through Normal Forms Physical Design Monitoring and Tuning |
notes1 notes2 notes3 | |
| Normal Forms | Motivation - update anomalies
Basis - Functional Dependencies Keys and Functional Dependencies Example |
Lecture | ||
| 2 | Normal Forms | Definitions (one candidate
key) Boyce-Codd Normal Form Dependency Preservation Higher Normal Forms |
Lecture Notes (doc) Notes (pdf) |
notes1 notes2 notes3 notes4 notes5 notes6 |
| 3 | Normal Forms | Continue with issues pending from the previous weeks. |
Notes (doc) Notes (pdf) |
notes1 |
| 4 | Physical Design: Constraints, Views and Security | Base Tables and Enterprise Constraints Views - generalities Updating through views Security - generalities Security through views |
Lecture |
notes1 notes2 |
| 5 | Physical Design: Efficient Access | Analysis of
Transactions File Organisation Indexes |
Lecture | Lecture |
| 6 | Reading Week | |||
| 7 | End-User Applications and Databases | Generalities PHP to Databases Java to Databases |
||
| 8 | Transactions | Transaction Management
Concurrency Control Data Recovery - optional |
Lecture Opt-Lecture |
|
| 9 | Distributed Databases | Generalities | Lecture | |
| 10 | Limitations of the Relational Model Other Models |
|||
| 11 |
Template for submission of lab work
| Week | Topic |
| 1 | Rules in Postgres |
| 2 | Displaying data from a database in a web page -- PHP (scripting language) |
| 3 | Creating a web interface to a database - PHP, including dynamic SQL, and HTML forms |
| 4 | Accessing a Postgres database from within a Java application |
| 5 | Work on topics introduced in weeks 2, 3 and 4 |
| 6 | Reading Week |
| 7 | Oracle - Generalities |
| 8 | If you have not completed
last week's lab, continue from where you left it. Oracle PL/SQL |
| 9 | Oracle PL/SQL - Exercises |
| 10 | Oracle - The System Catalogue |
| 11 | Finish work on topics
introduced this term. If you completed all the work, then attempt the optional topics below. |
| optional | Introduction
to Oracle and Java ... and the required jar file Oracle and Java - more advanced topics ... and the required jar file |
| Topic | Deadline |
| Coursework 2 | 7 March 2005 |
Past Exams (also follow the "Old Resources" link below, for past papers)
| Exam 2003 (sat by internal students) | Solutions 2003 |
| Exam 2004 (sat by internal students) | Solutions 2004 |
Page maintained by Marian Ursu. Created: January 2005. Updated frequently.
