Date, Time, and Room |
Seminar Topic and
Contents |
3 Sep 2008 Wednesday
8:45 – 10:30 HG 4.95 |
Seminar 1: Introduction to the course
- Course overview
- What data modeling is about
- Basics of conceptual modeling
- Assignments description
|
10 Sep 2008 Wednesday
8:45 – 10:30 HG 4.95 |
Seminar 2: Requirements Analysis and ER Modeling
- Requirements analysis
- ER modeling: entities, hierarchies and relationships
- Case study
|
15 Sep 2008 Monday
19:00 |
Deadline: submit your requirements analysis |
17 Sep 2008 Wednesday
8:45 – 10:30 HG 4.95 |
Seminar 3: Transforming the conceptual data model to tables
- Transformation rules and SQL constracts
- Transformation steps
|
22 Sep 2008 Monday
19:00 |
Deadline: submit your ER model |
24 Sep 2008 Wednesday
8:45 – 10:30 HG 4.95 |
Seminar 4: Normalization
- Fundamentals of normalization
- Functional dependencies
- Boyce-Codd normal form
|
6 Oct 2008 Monday
19:00 |
Deadline: submit your transformed/normalized model |
8 Oct 2008 Wednesday
8:45 – 10:30 HG 4.95 |
Seminar 5: Question answering session
- Feedback on homework exercises
- Discussion of progress on the assignment
|
15 Oct 2008 Wednesday
8:45 – 10:30 HG 4.95 |
Seminar 6: Student presentations
|
15 Oct 2008 Wednesday
15:30 – 17:15 HG 4.95 |
Seminar 7: Final examination
|