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 is made available (due 13th March, 6pm)
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 Query Processing (print version) Query Processing (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