Study Guide

Objective

After completing the course the student is able to:
- understand different types of databases and evaluate their feasibility for different purposes.
- plan and implement a database based on requirements and search and modify data in the database
- use at least one well-known database management system
- describe database management tasks

Content

- Different types of databases
- Definition, planning and implementation of databases
- SQL basics
- Database administration with DBMS
- Management principles for databases

Materials

course material in itslearning

Teaching methods

learning by doing

International connections

Weekly topics are handled with
- lecture
- examples
- class exercises, that are returned
- assessed network exercises
- db exercises

Completion alternatives

The complete course can be completed with an exam. The date will be agreed upon during the first lesson.

Student workload

lessons and rehearsals 45h
assessed network exercises 45h
DB exercises 45h

Content scheduling

Using a database (QBE, SQL)
Planning and implementing a database (entity analysis, ER model, DB structure model, populating a database)

During the Database (autumn 2024) and Object-oriented Programming (spring 2025) courses we are developing an application for EhtoisatEllit, which is an example business case.?Every (database and OO-program) version reflects the evolution of Ehtoisat Ellit business from estate management company to home and care service provider and their needs at each stage.

Evaluation scale

H-5

Assessment methods and criteria

Assessment is completely based on exercises. NOTE! exercises returned late are not assessed



- 5 mandatory class exercises, assessment pass/fail during the class (there are total of 10 class exercises).
- 5 quiz, each 5 points
- 5 DBlabs, each 5 points


if all 5 mandatory class exercises are passed the grade is 1
each 10 points from quizzes and labs add 1 grade
If a student fails a mandatory class exercise, points from quizzes and labs are used to compensate it and10 points compensate for one class exercise.

Assessment criteria, fail (0)

missing mandatory accepted class exercises and not enough points to compensate them

Assessment criteria, satisfactory (1-2)

all mandatory class exercises done (grade 1) and additional 10 points (grade 2)

Assessment criteria, good (3-4)

all mandatory class exercises done (grade 1) and additional 20 points (grade 3) or 30 (grade 4)

Assessment criteria, excellent (5)

all mandatory class exercises done (grade 1) and additional 40 points (grade 5)

all mandatory class exercises done (grade 1) and additional 50 points (grade 5 and 6 credits)