TU/e

DG208: Data Modeling


Program: Industrial Design (Bachelor)

Course Info: OWInfo

Lecturer: Mykola Pechenizkiy

Course book: T. Teory, S. Lightstone, T. Nadeau: "Database Modeling and Design", 4th Edition, Morgan Kaufmann, 2006

Course materials can be found in Sakai eLearning environment. Please, create an account and register for the course here.

Course syllabus (tentative)

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
For further questions, please contact