Study Guide

Objective

The student:
- knows what a database system is
- understands how to develop database systems

Content

How to develop database centered applications

Location and time

autumn 2024, Vaasa

Materials

Material on Moodle.

Teaching methods

lectures, computer exercises

Exam schedules

exam: December 2024
re-examination 1: January 2025
re-examination 2, February 2025

Student workload

classroom teaching 60 h, homework and own studies 75 h

Evaluation scale

H-5

Assessment criteria, satisfactory (1)

The student knows the history and current state of data storage. The student knows about different types of data warehouses.
The student knows the basic concept of relational theory and how a simpler relational database is constructed.
The student understands why a database in a higher normal form is better than a database in a lower normal form.
The student can explain the different normal forms,
The student knows and can use simple database commands.
The student can use the graphical user interface of a database management system.

Assessment criteria, good (3)

The student can explain the benefits of relational databases and the structure of the database systems.
The student can use the basic concept of relational theory and describe the structure of a relational database.
The student can normalize a database to 3NF. The student can determine the normal form of a database.
The student knows and can use more advanced database commands.
The student can use a report generator to compose reports from databases.

Assessment criteria, excellent (5)

The student can compare different data storage techniques with each other.
The student understands the mathematical model on which the relational databases are based.
The student can normalize a more extensive database to 3NF.
The student can independently acquire knowledge of database commands and practically apply this knowledge.
The student can, with graphic tools, create user interfaces for reading and writing databases.

Assessment methods and criteria

exam, submission task

Assessment criteria, fail (0)

The student does not meet the criteria for the grade 1.

Assessment criteria, satisfactory (1-2)

The student knows the database administrator's duties.
The student can realize databases containing simple stored procedures, functions and triggers.
The student knows the principles of reporting and data analysis.

Assessment criteria, good (3-4)

The student can perform the database administrator's routine tasks.
The student can implement databases with more advanced stored procedures, functions and triggers.
The student can program client applications that use server-side code.
The student can implement and use databases for reporting and data analysis.

Assessment criteria, excellent (5)

The student can plan and configure the database administration of a database server and its databases.
The student can create software for database applications in multi-user environments where transaction management and locking are needed.
The student can plan, realize and use databases for data analysis.

Qualifications

Database Technology