Advanced databases

1.

Subject title

Advanced databases

Напредни бази на податоци

2.

Code

F23L3S138

3.

Study program

Примена на информациски технологии, Компјутерски науки, Компјутерско инженерство, Интернет, мрежи и безбедност, Примена на информациски технологии, Компјутерски науки, Компјутерско инженерство, Интернет, мрежи и безбедност, Информатичка едукација, Софтверско инженерство и информациски системи, Software engineering and information systems, Software engineering and information systems, Софтверско инженерство и информациски системи, Стручни студии за програмирање, Стручни студии за програмирање, Cloud Computing,

4.

Organizer of the study program (unit, institute, department, division)

Faculty of Information Sciences and Computer Engineering

5.

Study cycle (first, second, third)

Прв циклус

6.

Academic year / semester

3 / Летен

7. Number of ECTS credits

6.0

8.

Instructor

ворн. проф. д-р Ефтим Здравевски проф. д-р Горан Велинов

9.

Prerequisites for enrollment

Освоени најмалку 90 ЕКТС

10.

Subject goals and competencies:

Acquaintance of students with the advanced concepts of relational databases, necessary for modeling, creation, management and maintenance of databases, as well as for the development of data-intensive information systems. With this, students will acquire deep theoretical and practical knowledge in the field of databases. Also, students will be familiar with the modern trends of development and expansion of traditional database management systems, in order to respond to current challenges in the development of information theory and practice.

11.

Subject content:

Lectures: 1. Data storage and file structure 2. Indexing and Hashing 3. Execution of questionnaires 4. Optimization of questionnaires 5. Transaction Management 6. Control of competitiveness 7. Recovery 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 the development of databases

12.

Learning methods:

Предавања поддржани со презентации преку слајдови, интерактивни предавања, вежби (користење на опрема и софтверски пакети), тимска работа, пример случаи, поканети гости предавачи, самостојна изработка и одбрана на проектна задача и семинарска работа, учење во електронско опкружување (форуми, консултации).

13.

Total available time fund

6.0 ECTS x 30 hours = 180 hours

14.

Time distribution

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

15.

Forms of teaching activities

15.1.

Lectures - theoretical teaching

30 hours

15.2.

Exercises (laboratory, classroom), seminars, team work

45 hours

16.

Other forms of activities

16.1.

Project tasks

15 hours

16.2.

Independent tasks

15 hours

16.3.

Homework

75 hours

17.

Grading method

17.1.

Tests

points

17.2.

Seminar work / 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.

Condition for signature and taking final exam

изработени 50% од индивидуални задачи

20.

Language of instruction

македонски и англиски

21.

Quality assurance method

механизам на интерна евалуација и анкети

22.

Literature

22.1.

Mandatory literature

22.2.

Additional literature