Opinto-opas

Objective

Upon completing the course the student knows the principles and key practices in logical and physical database design. He/she is able to model the structure and dependencies of data. The student is able to design a relational database both on database-first and code-first basis. He/she can implement a database in such a way that its structure, performance and security are of high standards. The student is familiar with challenges in object-relational mapping, and he/she masters the key related technologies. The student understands the principles of database concurrency control.

Content

Data-first and code-first database design, normalization of databases, installation and configuration of a database server, indexing, query optimization, views, triggers, user privileges, security, backup policies, object-relational mapping and its technical solutions, means of concurrency control.

Evaluation scale

0-5

Assessment criteria, satisfactory (1)

The student has achieved the course objectives fairly. The student will be able to identify, define and use the course subject area’s concepts and models. The student has completed the required learning exercises in minimum requirement level.

Assessment criteria, good (3)

The student has achieved the course objectives well, even though the knowledge and skills need improvement on some areas. The student has completed the required learning exercises in good or satisfactory level. The student is able to define the course concepts and models and is able to justify the analysis.

Assessment criteria, excellent (5)

The student has achieved the objectives of the course with excellent marks. The student master commendably the course subject area’s concepts and models. The student has completed the required learning exercises in good or excellent level. The student is able to make justified and fluent analysis.

Assessment criteria, approved/failed

The student has achieved the course objectives fairly. The student will be able to identify, define and use the course subject area’s concepts and models. The student has completed the required learning exercises in minimum requirement level.

Qualifications

Basics of object-oriented programming.
Basic SQL knowledge.