Databases
| Structure Type: | Study unit |
|---|---|
| Code: | TTKA0713 |
| Curriculum: | TK 2020 |
| Level: | Bachelor of Business Administration |
| Year of Study: | 2 (2021-2022) |
| Semester: | Autumn |
| Credits: | 4 cr |
| Responsible Teacher: | Niittykoski, Jukka |
| Language of Instruction: | Finnish |
Courses During the Academic Year 2021-2022
| Impl. | Group(s) | Study Time | Teacher(s) | Language | Enrolment |
|---|---|---|---|---|---|
| 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 |
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