| 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
|
