Basics in Bioinformatics and Databases
Part 1: Basics in Databases
This is the first part of a course on
Basics in Bioinformatics Tools and Databases, given as part of the
Research School in Genomics
and Bioinformatics.
The tutor for this part of the course is
Graham Kemp,
(Chalmers University of Technology).
Schedule
Wednesday 1 October 2003
11:00-11:10 Welcome and Introduction (S4)
11:10-12:00 Database Management Systems: Components and Concepts (S4)
12:00-13:15 Lunch
13:15-16:00 Data Modelling and the Relational Data Model (S1)
16:00-17:00 Exercise: Conceptual Modelling (S4)
Thursday 2 October 2003
08:30-09:00 Relational Query Languages (S4)
09:00-10:00 The Functional Data Model (S4)
10:00-10:15 Break
10:15-12:00 Practical: SQL (Computer Lab L)
12:00-13:15 Lunch
13:15-13:30 Case Studies (S1)
13:30-15:00 Practical: Bioinformatics
Schemas (Computer Lab L)
15:00-15:30 Reports on Conceptual Modelling Exercise (S4)
15:30-16:00 Databases and the Internet (S4)
16:00-16:15 Break
16:15-17:15 Database Integration (S4)
17:15-18:00 Exercise: Hierarchical Data Organisation (S4)
Friday 3 October 2003
Overview
08:30-09:00 Exercise: Hierarchical Data Organisation (S4)
09:00-09:45 Hierarchies in Biological Data (S4)
09:45-10:00 Break
10:00-11:00 Representing Hierarchies in Computer Systems: Database Schemas (S1)
10:45-11:00 Break
11:00-11:45 Representing Hierarchies in Computer Systems: Frame Systems (S1)
11:45-13:15 Lunch
13:15-13:45 Databases and Hierarchical Vocabularies (S4)
13:45-14:15 Databases and Object-Oriented Programming (S4)
14:15-15:00 Discussion and Close (S4)
Assignment
The assignment for this part of the course is available
on-line.
Last Modified: 2003/08/21
kemp@cs.chalmers.se