Proposed Lecture Schedule for Database Management

Note that the lecture material available via the links below may change up until shortly before the lecture concerned

The following sessions take place on Wednesday evenings (6pm-9pm) in the Spring (second) term.

Week18:00-19:2019:40-21:00
1 Introduction to Databases (print version) Entity-Relationship Model (print version)
2 Entity-Relationship Model (continued)
ERD notation (from [SKS11])
ERD exercise
Relational Model (print version)
3 SQL - single table queries (print version) Laboratory session
4 SQL - multi-table queries (print version) Laboratory session
5 SQL - subqueries and aggregation (print version) Laboratory session
6 Coursework made available
SQL updates, views and transactions (print version)
Laboratory session
7 Relational Database Design - integrity constraints (print version) Relational Database Design - integrity constraints (print version)
8 Relational Database Design - normal forms (print version) Relational Database Design - normal forms (print version)
9 Relational Database Design - normalisation algorithms (print version) Relational Database Design - normalisation algorithms (print version)
10 Coursework deadline
Non-Relational Databases (print version)
SQL Programming and the Web (print version)
11 SQL Programming and the Web (print version) Laboratory session