Structure Type: Course
Code: KL04BT50020
Level: Bachelor
Credits: 4.0 points
Responsible Teacher: Lahti, Markku
Language of Instruction: Finnish

Course Implementations, Planned Year of Study and Semester

Curriculum  Semester  Credits  Start of Semester  End of Semester
TITE-2013   2 autumn   4.0   2014-09-01   2014-12-31  
TITE-2014   2 autumn   4.0   2015-08-01   2015-12-31  
TITE-2015   2 autumn   4.0   2016-08-01   2016-12-31  
TITE-2016   2 autumn   4.0   2017-08-01   2017-12-31  

Learning Outcomes

The aim of the course is to familiarize the student with the basics of data management. The student understands the relational model, relational database and learns the stages of the information analysis. Students will have command of SQL language.

Student's Workload

104 h, of which scheduled studies 52 h and autonomous studies 52 h

Prerequisites / Recommended Optional Courses

No previous studies are required.


The course comprises the following:
- Relational model
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)

Recommended or Required Reading

Lecture materials,
Additional material: Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo

Connolly Thomas - Begg Carolyn: Database Systems, Addison Wesley

Mode of Delivery / Planned Learning Activities and Teaching Methods

Lectures and exercises

Assessment Criteria

- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language

- Good (3-4): The student masters well the principles of database design and basic of SQL language

- Satisfactory (1-2) The student knows the basics

Assessment Methods

Class exercises and an examination