Subject

Advanced databases

Course Title

Advanced databases
Advanced databases

Code

F23L3S138

Study Programme

Software Engineering and Information Systems

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

Faculty of Computer Science and Engineering

Degree level (first, second, third cycle)

First Cycle

Academic year / semester

6 / Summer

Number of ECTS credits

Teacher

Eftim Zdravevski, Goran Velinov

Prerequisites for enrolling in the course

At least 90 ECTS credits earned

10.

Objectives of the course programme (competences)

Introducing students to the advanced concepts of relational databases necessary for modeling, creating, managing, and maintaining databases, as well as for developing data-intensive information systems. By doing so, students will acquire deep theoretical and practical knowledge in the field of databases. Students will also be introduced to the current trends in the development and extension of traditional database management systems, in order to address the current challenges in the development of information theory and practice.

11.

Course content

Lectures:
1. Data Storage and File Structure
2. Indexing and Hashing
3. Administering questionnaires
4. Questionnaire Optimization
5. Transaction Management
6. Competitiveness Control
7. Restoration Systems
8. Architectures of database management systems;
9. Parallel databases
10. Distributed databases
11. Analytical Databases - Data Warehouses and Data Mining
12. Object and Object-Relational Databases
13. Trends in database development

12.

Learning methods

Lectures supported by slide presentations, interactive lectures, exercises (using equipment and software packages), teamwork, case studies, guest lecturers, independent preparation and defense of a project assignment and seminar paper, learning in an electronic environment (forums, consultations).

13.

Total available time

6 ECTS x 30 hours = 180 hours

14.

Distribution of available time

30 + 45 + 15 + 15 + 75 = 180 hours

15.

Forms of teaching activities

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

16.

Other forms of activities

16.1.	Project assignments	15 hours
16.2.	Independent assignments	15 hours
16.3.	Home study	75 hours

17.

Assessment method

17.1.	Tests	0 points
17.2.	Seminar paper / project (presentation: written and oral)	15 points
17.3.	Activities and learning	10 points
17.4.	Final exam	10 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

50% completed from individual tasks

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 1. Avi Silberschatz, Henry F. Korth, S. Sudarshan \| Database System Concepts \| McGraw-Hill \| 2010 2. Joseph M. Hellerstein, Michael Stonebraker, James Hamilton \| Architecture of a Database System, Foundations and Trends in Databases, \| NOW Publishers \| 2007 3. Salahaldin Juba, Achim Vannahme, Andrey Volkov \| Learning PostgreSQL \| 2015
22.2.	Additional literature No. Author Title Publisher Year