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 Monday evenings (6pm-9pm) in the Spring (second) term.
Week
18:00-19:20
19: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
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