Subject

Advanced Database Concepts

Course Title

Advanced Database Concepts
Advanced database concepts

Code

m23_w_040

Study Programme

—

Organizer of the study programme (unit, institute, department or division)

Faculty of Computer Science and Engineering

Degree level (first, second, third cycle)

Second cycle

Academic year / semester

9 / Winter

Number of ECTS credits

1000

Teacher

Goran Velinov, Vangel Ayanovski

Prerequisites for enrolling in the course

—

10.

Objectives of the course programme (competences)

The goal of the course will be to provide the student with knowledge of advanced concepts, such as
both in conventional relational and in non-relational databases.
Upon completion of the course, the student is expected to know the rigorous theoretical aspects.
which are built into modern database management systems, as well as
the latest trends and open problems from a theoretical and practical perspective in the development of
databases.

11.

Course content

The topics covered in this course are:
Data modeling – models, techniques, and tools;
Multi-model databases;
Relational database model – advanced concepts (relational algebra,
relational calculus, functional dependencies, normalization);
Architecture of Modern Database Management Systems – An Overview
from the inside; noun
Many large databases, spatial, semi-structured, and unstructured databases;
Object-relational and object-oriented databases
Semantic databases;
File-organized and distributed databases;
Memory databases;
Blockchain and databases.

12.

Learning methods

13.

Total available time

1000 ECTS x 30 hours = 180 hours

14.

Distribution of available time

30 + 30 + 0 + 0 + 0 = 180 hours

15.

Forms of teaching activities

15.1.	Lectures - theoretical instruction	30 hours
15.2.	Exercises (laboratory, auditory), seminars, teamwork	30 hours

16.

Other forms of activities

16.1.	Project assignments	0 hours
16.2.	Independent assignments	0 hours
16.3.	Home study	0 hours

17.

Assessment method

17.1.	Tests	0 points
17.2.	Seminar paper / project (presentation: written and oral)	0 points
17.3.	Activities and learning	0 points
17.4.	Final exam	0 points

18.

Grading criteria (points / grade)

up to 50 points	5 (five) (F)
from 51 to 60 points	6 (six) (E)
from 61 to 70 points	7 (seven) (D)
from 71 to 80 points	8 (eight) (C)
from 81 to 90 points	9 (nine) (B)
from 91 to 100 points	10 (ten) (A)

19.

Requirement for obtaining a signature and taking the final exam

completed activities 15.1 and 15.2

20.

Language of instruction

Macedonian and English

21.

Method for monitoring the quality of teaching

internal evaluation and survey mechanism

22.

Literature

22.1.

Required literature

22.2.

Additional literature

No. Author Title Publisher Year