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 
TypeCourse   
  Grading1 - 5, pass, fail 
 
   
Unit Information Processing Science DP 

Teachers
Name
Iisakka, Juha Veikko 

Description
ECTS Credits 

7 ECTS credits/187 hours of work

 
Language of instruction 

Finnish

 
Timing 

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.

 

 
Contents 

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

 
Mode of delivery 

Face-to-face

 
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 

Examination

 
Grading 

1-5

 
Person responsible 

Juha Iisakka

 
Working life cooperation 

No

 


Current and future instruction
No instruction in WebOodi

Future examinations
No examinations in WebOodi