Category: Course Databases

We are excited to announce a new course setup for the topics Information Modeling and Databases that will be combined this year into a single new course. We will consider design practices and tools that are relevant for the entire software system’s life cycle. We will study how to accurately model a system by understanding the domain under consideration, to specify the boundaries of the domain, to identify the relevant concepts in the domain and their relationships, and to specify the rules or constraints of the behaviour of those concepts. We will use relational database technology — one of the most successful inventions in computer science — to implement the data part of our model. Relational databases are great tools for storing large amounts of data persistently, and they allow efficient, safe, multi-user access to that data. We will study SQL to formulate and answer complex questions on the data in a declarative way. The course consists of lectures and practical assignments. More information will be published shortly on Brightspace.

Wishing you a fruitful, interesting course,
Patrick van Bommel and Djoerd Hiemstra.

TOM or MOOC?

This year, students can pass our course “Gegevensbanken” (Dutch for “Databases”) by following the massive open online course DB 2014 from Stanford University

In 2013/2014 we offered our course “Gegevensbanken” (Dutch for Databases) for the last time. From this year on, students will study Databases as part of the module Data and Information. We advise students that failed the course last year, and that do not want to enroll in the Twente Educational Model (TOM: Twents Onderwijs Model), to follow the excellent Stanford DB 2014 massive open on-line course (MOOC) by Jenifer Widom.

The course takes the following 8 lectures (mini courses) from the full Stanford Database class. Students should finish roughly one mini course each week in Quarter 1.

1. Introduction and Relational Databases
2. Relational Algebra
3. SQL
4. Relational Design Theory
5. Unified Modeling Language (UML)
6. Indexes and Transactions
7. Constraints and Triggers
8. Views and Authorization

Students that submit their Statements of Accomplishment via Blackboard for each mini course (except the Introduction mini course) will get 0.2 bonus grade point per Statement, 1.5 bonus grade points if all Statements of Accomplishment are submitted. There are two exams for “Gegevensbanken”:

1. 30 October, 13.45 h. – 16.45 h.
2. 30 January, 8.45 h. – 11.45 h. (resit)

Students that fail both exams can enroll in the new Twente Educational Model bachelor module “Data & Information” which takes place in Quarter 4.