Databases
| Structure Type: | Study unit |
|---|---|
| Code: | TTKA0713 |
| Type: | Compulsory |
| Curriculum: | AVOIN 2021 TK 2015 / 2016 / 2017 / 2018 / 2019 / 2020 / 2021 |
| Level: | Bachelor of Business Administration |
| Year of Study: | 2 (2016-2017 / 2017-2018 / 2018-2019 / 2019-2020 / 2020-2021 / 2021-2022 / 2022-2023) |
| Credits: | 4 cr |
| Responsible Teacher: | Tuomaala, Raija |
| Language of Instruction: | Finnish |
Courses
| Impl. | Group(s) | Study Time | Teacher(s) | Language | Enrolment |
|---|---|---|---|---|---|
| 1 | T-TK-2-1 | 2016-09-01 – 2016-12-31 | Raija Tuomaala | Finnish | 2016-08-22 – 2016-09-19 |
| 2 | T-TK-2-2 | 2016-09-01 – 2016-12-31 | Raija Tuomaala | Finnish | 2016-08-22 – 2016-09-19 |
| 3 | T-TK-2-1 | 2017-09-01 – 2017-12-22 | Raija Tuomaala | Finnish | 2017-08-21 – 2017-09-18 |
| 4 | T-TK-2-2 | 2017-09-01 – 2017-12-22 | Raija Tuomaala | Finnish | 2017-08-21 – 2017-09-18 |
| 5 | T-TK-2-1 | 2018-08-31 – 2018-12-21 | Raija Tuomaala | Finnish | 2018-08-20 – 2018-09-17 |
| 6 | T-TK-2-2 | 2018-08-31 – 2018-12-21 | Raija Tuomaala | Finnish | 2018-08-20 – 2018-09-17 |
| 7 | T-TK-2-1 | 2019-09-02 – 2019-12-22 | Raija Tuomaala | Finnish | 2019-08-19 – 2019-09-09 |
| 8 | T-TK-2-2 | 2019-09-02 – 2019-12-22 | Raija Tuomaala | Finnish | 2019-08-19 – 2019-09-09 |
| 3001 | TK2019-2A, TK2019-2B | 2020-08-24 – 2020-12-20 | Antti Mäkitalo, Raija Tuomaala | Finnish | 2020-08-17 – 2020-09-11 |
| 3002 | TK2019-2B | 2020-08-24 – 2020-12-20 | Raija Tuomaala | Finnish | 2020-08-17 – 2020-09-11 |
| 3003 | TK2020-2A | 2021-08-23 – 2022-01-15 | Antti Mäkitalo | Finnish | 2021-08-01 – 2021-09-06 |
| 3004 | TK2020-2B | 2021-08-23 – 2022-01-15 | Antti Mäkitalo | Finnish | 2021-08-01 – 2021-09-06 |
| 3006 | TK2021-2A | 2022-08-22 – 2022-12-18 | Antti Mäkitalo | Finnish | 2022-08-01 – 2022-09-06 |
| 3007 | TK2021-2B | 2022-08-22 – 2022-12-18 | Antti Mäkitalo | Finnish | 2022-08-01 – 2022-09-06 |
The descriptions shown below are for the academic year: 2022-2023
Learning Outcomes
Students make database application and the its documentation.
Students know the basic terminology and the management pracises of databases for multi-user environment. Students understand the importance of good database design. They can create a database and its objects and carry out the basic administration tasks.
Student's Workload
Total work load of the course: 104 h
- of which scheduled studies: 52 h
- of which autonomous studies: 56 h
The assesment of student's own learning 1 h is included in contact lessons.
Prerequisites / Recommended Optional Courses
Basics of Programming I and II
Contents
Client/server databases
- problems and solutions of concurrency
- how to create and admin a client/server database
- how to maintain a client/server database
Regional Impact
Companies that develop software in this area use largely the database management system that is teached in this course.
Internationality
Companies that develop software globally in this area use largely the database management system that is teached in this course.
Recommended or Required Reading and Other Learning Resources/Tools
Learning material will be published on the web site of the course.
MSDN Library On-Line Documentation.
Mode of Delivery / Planned Learning Activities and Teaching Methods
Lectures, exercises and project learning.
Assessment Criteria
5=The student creates independently a multifunctional database and its administrative tasks and the database is created according to best practices.
3=The student creates independently and instructed a multifunctional database and its administrative tasks.
1=The student creates independently and instructed a database that is compliant with the minimum requirements.
Assessment Methods
Numeric scale is used (0-5).
Evaluation of
- portfolio of how to manage the client/server database,
- test