Date, Time, and Room |
Lecture Title and
Contents |
2 Feb 2009 Monday 10:45 – 12:30 HG 3.02 |
Lecture 1: Introduction to the course
- Course overview
- Modern Database Technology and Applications
|
2 Feb 2009 Monday 13:30 – 15:15 HG 3.02 |
Lecture 2: ER-modelling
- Requirements analysis
- ER modeling: entities, hierarchies and relationships
- Case study
|
3 Feb 2009 Tuesday 10:45 – 12:30 HG 3.02 |
Lecture 3: Transforming the conceptual data model to tables
- Transformation rules and SQL constructs
- Transformation steps
|
3 Feb 2009 Tuesday 13:30 – 15:15 HG 3.02 |
Lecture 4: Querying data with SQL
- Basic Select
- Nested queries
- Aggregation functions
|
4 Feb 2009 Wednesday 10:45 – 12:30 HG 3.02 |
Lecture 5: Data Warehousing and OLAP
- Conceptual and physical DW Modelling
- Data cubes: a multi-dimensional data model
- Basic OLAP operations
|
4 Feb 2009 Wednesday 13:30 - 15:15 HG 3.02 |
Discussion session
|
5 Feb 2009 Thursday 10:45 – 12:30 HG 3.02 |
Lecture 6: Data Mining
- Classification
- Clustering
- Association analysis
|
5 Feb 2009 Thursday 13:30 - 15:15 HG 3.02 |
Tutorial on Data Mining in WEKA
- Classification
- Clustering
- Association analysis
|
6 Feb 2009 Friday 10:45 – 12:30 HG 3.02 |
Lecture 7: Recommender Systems
- Content-based filtering
- Collaborative filtering
- Hybrid approaches
|
6 Feb 2009 Friday 13:30 - 15:15 HG 3.02 |
Discussion of project assignments
|
9 Feb 2009 Monday 10:45 - 12:30 HG 3.02 |
Discussion/Q&A session
|
11 Feb 2009 Wednesday 10:45 - 12:30 HG 3.02 |
Discussion/Q&A session
|
13 Feb 2009 Friday 10:30 – 13:00 HG 3.02 |
Project presentations
|
13 Feb 2009 Friday 13:30 - 15:30 HG 3.02 |
Written exam or multiple-choice test
|