Data Management Systems (5 cr)
Code: LTD6036-3002
General information
- Enrollment
- 01.04.2020 - 30.04.2020
- Registration for the implementation has ended.
- Timing
- 19.10.2020 - 30.12.2020
- 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
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