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

Recomended reading:
SQL in Easy Steps, 4th Edition : Ideal for Those Who Want to Master SQL Essentials
Mike McGrath

and
Database Modeling and Design : Logical Design
Book Cover Image
by Toby J. Teorey, , Sam S. Lightstone, , Tom Nadeau, , and H.V. Jagadish

Teaching methods

learning by doing

Exam schedules

Assessment is completely based on exercises.
The complete course can be completed with an exam. The date will be agreed upon during the first lesson, but must be within the 1st month (September).
There is no retake for the compensating exam.

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, but must be within the 1st month (September).
The exam is an e-exam done in TUAS e-exam room using Ville system.
The compensating exam can only be taken if a student is enrolled to the course.

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 a business case EhtoisatEllit. 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)