Data modellering en -verwerking (8C020)

 

Fall 2006, Semester 1, Block C

Contents:

 

Announcements:

No lecture on Wednesday, November 29.

The deadline for the delivery of part A of the term project is Monday, December 18, 18:00 h.

Deadline extension: The new deadline for the delivery of the corrected Part A and Part B is January 31, 18:00 h

Time:

Monday, 5th and 6th hour (13:30-15:15)

Wednesday, 1st and 2nd hour (8:45-10:30)

Place:

Auditorium 6 (Monday)

Auditorium 12 (Wednesday)

Lecturer:

Dragan Bosnacki
mailto:dragan@win.tue.nl
address: WH 3.101
phone: 040-2475159

Literature:

Term Project:

 

Links:

Previous Exams and Exercises:

Schedule:                                      

 

No

Lecture date

Subjects

Remarks

1

November 27

Introduction, Information Systems, Data Bases, Entity-Relationship Model. Slides

Lecture Notes Sections 3.1-3.5 (Sections 2.1-2.6 optional), Book Sections 2.1-2.5

2

December 4

Cardinality, Weak entities, Aspects of the ER-modeling: Multivalued attributes, repeating group, time-depending data, ISA-relationship, UML. Slides

Lecture Notes Sections 3.4, 3.5, 3.6, Book Sections 2.5-2.11

3

December 6

Exercise E-R Modeling: Hospital Example (Solution), Relational Model, Relational Approach, Tables, Normalization. Cleaning Services Example. Slides

Lecture Notes Chapter 4, Book Section 3.1

4

December 11

Hospital Example (RM model), Query Languages, Data definition and manipulation in SQL, Exercises. Slides

Lecture Notes Sections 5.1-5.3, Book Chapter 3

 

5

December 13

SQL: Joins and Subqueries, Exercises, Normalisation: 1st, 2nd, 3rd normal forms,  Solutions to Exercises Section 5.5. Slides

Lecture Notes Sections 5.4, 5.5, Book Chapters 3, 7, http://en.wikipedia.org/wiki/Database_normalization

6

December 18

Process Modeling, Transitions Systems, Graphs, Classical Petri Nets: Introduction, Formal Definition of Structure, Behavior, Examples. Slides

Lecture Notes Sections 7.1-7.6

 

7

December 20

Discussion of the Term Project Part A, QBE, Microsoft Access, Combining SQL with Programming Languages, Using SQL from Java, JDBC, Petri Nets Modeling Aspects: The Role of Tokens, Examples. Slides

Lecture Notes Sections 6, 7.7, Book Chapter 5, Sections 4.12-13

8

January 8

Modeling, Typical Network Structures, Applications of Petri Nets in Bioinformatics: Metabolic Pathways, Genetic Regulatory Networks. Examples in Yasper: Activation, Inhibition, Positive Circuit, Negative Circuit. Slides

Lecture Notes Sections 7.7, 7.9, additional lecture notes: Modeling Genetic Networks with Petri Nets

9

January 10

Applications of Petri Nets in Bioinformatics: Genetic Networks – Positive and Negative Feedbacks, Oscillators and Steady states. Petri Net Tools. SQL in Access: Inner Join. XML and Databases on the Web. Formal Methods in Biomedical Engineering, Wrap-up. Slides

Modeling Genetic Networks with Petri Nets, XML in tien punten, XML & Databases.

 

Acknowledgments:

Most of the course material (slides, exercises, exams) on this page is based on material by Nico Kuijpers and Geert-Jan Houben.