Data on the course

Show instruction and examinations
811380A Basics of Databases, 7 ECTS cr 
Code 811380A  Validity 01.01.1950 -
Name Basics of Databases  Abbreviation Basics of Datab 
Scope7 ECTS cr   
Type Intermediate Studies Discipline3259 Information Processing Science 
  Grading1 - 5, pass, fail 
Unit Information Processing Science DP 

Iisakka, Juha Veikko 

ECTS Credits 

7 ECTS credits/187 hours of work

Language of instruction 



Timing: 2 nd year, autumn semester, period 2, and spring semester, period 3

Learning outcomes 

After completing the course, students understand what databases are and what their meaning for information systems is. They can model conceptually for database designing purposes, design a high-quality relational database and make queries to it. They have constructed a small MySQL database application. They are able to throw simple XML-database with XML Schema definitions, and they know how to use an object database in an object-oriented programme. They understand transactions, schedules of transactions, serialiseability of schedules and recovery choices of schedules. They also know what different SQL Isolation levels means to safety of transactions.



Conceptual modelling (ER- and EER-diagrams), relational model (theory, databases, query techniques and normalization), XML-databases, object-oriented databases, transactions.

Mode of delivery 


Learning activities and teaching methods 

Lectures 45h, compulsory exercises 24h and (reading 20h) and assignments 27h. Exams 21h. Self-studying 52h.

Target group 


Prerequisites and co-requisites 

Course 812346A “Object Oriented Analysis and Design” or knowledge about object oriented class models.

Recommended optional programme components 


Recommended or required reading 

Silberschatz, Korth & Sudarshan: Database system concepts

Assessment methods and criteria 




Person responsible 

Juha Iisakka

Working life cooperation 



Current and future instruction
No instruction in WebOodi

Future examinations
No examinations in WebOodi