Skip to main content

Data Management Systems (5 cr)

Code: LTD6036-3001

General information


Enrollment
01.10.2020 - 31.10.2020
Registration for the implementation has ended.
Timing
08.01.2021 - 26.02.2021
Implementation has ended.
Number of ECTS credits allocated
5 cr
Local portion
0 cr
Virtual portion
5 cr
Mode of delivery
Distance learning
Unit
Tradenomi / Tietojenkäsittely (DD)
Campus
Wärtsilä Campus Karjalankatu 3
Teaching languages
Finnish
Seats
20 - 120
Degree programmes
Degree Programme in Business Information Technology
Teachers
Jyri Kemppainen
Mika Matveinen
Mikko Anttonen
Teacher in charge
Mikko Anttonen
Scheduling groups
Pienryhmä 1 (Size: 50 . Open UAS : 0.)
Pienryhmä 2 (Size: 50 . Open UAS : 0.)
Groups
LTDNS20
Information Technology (BBA), Full-time Studies, Fall, 2020
Small groups
Pienryhmä 1
Pienryhmä 2
Course
LTD6036

Evaluation scale

H-5

Objective

Student
- knows the principles of DBMS, base functions and purposes
- knows different kind of DBMSs
- can implement drawing of database based on requirements
- understands different kind of database models and can choose DBMS for model
- can implement database that works
- can make use of database as a part of system
- can implement different kind of database systems

Execution methods

Pre-recorded theory lectures and voluntary weekly exercises.

Accomplishment methods

Exercises, project work (50%) and exam (50%).

Content

- SQL-language basics (queries, DML- and DDL -commands)
- normalizing
- data models
- DBMSs, especially for PostgreSQL, MySQL/MariaDB, Oracle, MS SQL Server
- going through small database application development

Go back to top of page