Database StructuresLaajuus (3 ECTS)

Objective

Having passed the course, the student is able to install a database management system, improve the performance of a database, protect the database server, and back up and restore a database. The student knows the problematics and techniques of object-relational mapping.

Content

Indexing of databases, optimisation of queries, triggers, priveleges, security, backing up a database, object-relational mapping.

Qualifications

Introduction to Databases

Assessment criteria, satisfactory (1)

- The student is able to install a database management system.
- The student understands the meaning and basic idea of indexing.
- The student knows the most important challenges caused by concurrent use of a database. The student is able to create transactions.
- The student understands the working principles of views and triggers.
- The student knows the factors of database security. They are able to create user accounts and specify the most important privileges. The student is able to back up and restore a database.
- The student understands the challenges of object-relational mapping and knows some of the solutions.

Assessment criteria, good (3)

- The student is able to modify the most important server setting of a database management system.
- The student is able to technicaly implement database indexing.
- The student knows the challenges caused by concurrent use of a database as well as the related consequences.
- The student is able to design adequate transactions. The student can mention some of the techniques that enable the concurrency in database management systems.
- The student is able to create views and triggers.
- The student is able to implement a secured database in a database managements system. they are able to create users and grant, revoke, and modify priveleges. The student knows some backup strategies.
- The student is able to realise object-relational mapping in separate cases.

Assessment criteria, excellent (5)

-The student is able to install the server settings of a database management system according to intended usage.
- The student is able to make an indexing plan of a database according to intended usage.
-The student understands the principles of transaction handling and is able to manage the way transactins are handled in a database management system.
-The student is able to describe techniques that are used to enable concurrent usage in database systems.
-The student understands the applicability of using views and triggers in different situations.
-The student is able to manage user accounts. The student is able to grant, revoke, and modify priveleges for databases, tables, views. The student is able to make a backup plan.
- The student is able to create an object oriented application that implements an object-relational mapping.