Monday, 5th and 6th hour (13:30-15:15)
Wednesday, 1st and 2nd hour
(8:45-10:30)
Auditorium 6 (Monday)
Auditorium 12 (Wednesday)
Dragan Bosnacki
mailto:dragan@win.tue.nl
address: WH 3.101
phone: 040-2475159
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 |
|
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. |