Data Management Systems (5cr)
Code: LTD6036-LTA19V1
General information
- Timing
- 01.08.2019 - 31.12.2019
- 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
Materials
Ilmoitetaan opintojakson alussa.
Student workload
Luennot 2 tuntia/vko, yht. 16 tuntiaHarjoitukset 2 tuntia/vko, yht. 16 tuntiaitseopiskelu 95 tuntiatentti, arviointi ja palaute 6 h.