Databases

1.

Subject title

Databases

Бази на податоци

2.

Code

F23L3W004

3.

Study program

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

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

Алгоритми и податочни структури или Примена на алгоритми и податочни структури

10.

Subject goals and competencies:

Introducing the student with the basic concepts for using the databases; the ways of their modeling and implementation; as well as the application of the query languages. The student will be able to model databases through semantic and relational modeling and database normalization, he/she will know how to practically apply the SQL standard for creating, maintaining and manipulating relational databases. The student will have knowledge of the basic concepts of concurrency control and transactions.

11.

Subject content:

(2) Physical organisation of data (data structures and indices) (1) Introduction to DBMS (2) Conceptual modelling and database design (E-ЕR diagrams) (1) The relational data model (2) Relational algebra and relational calculus (2) Introduction to SQL - DDL and DML statements (1) Advanced usage of SQL (1) Functional dependencies and database normalization (1) Introduction to transaction processing and concurrency control

12.

Learning methods:

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

13.

Total available time fund

6.0 ECTS x 30 hours = 180 hours

14.

Time distribution

30 + 60 + 10 + 10 + 70 = 180 hours

15.

Forms of teaching activities

15.1.

Lectures - theoretical teaching

30 hours

15.2.

Exercises (laboratory, classroom), seminars, team work

60 hours

16.

Other forms of activities

16.1.

Project tasks

10 hours

16.2.

Independent tasks

10 hours

16.3.

Homework

70 hours

17.

Grading method

17.1.

Tests

10 points

17.2.

Seminar work / project (presentation: written and oral)

10 points

17.3.

Activities and learning

10 points

17.4.

Final exam

70 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

Реализирани актибвности 15.2 и 16.1

20.

Language of instruction

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

21.

Quality assurance method

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

22.

Literature

22.1.

Mandatory literature

22.2.

Additional literature