Subject

Databases

Course Title

Databases
Databases

Code

F23L3W004

Study Programme

Application of Information Technologies, Software Engineering and Information Systems, Computer Science, Computer Engineering, Internet, Networks and Security, Information Literacy Education, Software Engineering and Information Systems, Bioinformatics

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

5 / Winter

Number of ECTS credits

Teacher

Eftim Zdravevski, Georgina Mircheva, Goran Velinov, Kire Trivodaliiev, Slobodan Kajaldjiski, Sonja Gievska, Vangel Ajanoski

Prerequisites for enrolling in the course

Algorithms and Data Structures or Applied Algorithms and Data Structures

10.

Objectives of the course programme (competences)

Familiarizing the student with the basic concepts of working with databases, methods for their modeling and implementation, as well as working with query languages. The student will be able to model databases using semantic and relational modeling and the normalization process, and will know how to practically apply the SQL standard to create, maintain, and manipulate relational databases. The student will have knowledge of the basic concepts of concurrency and transactions.

11.

Course content

(2) Physical organization of data (structures and indexes)
(1) Introduction to SUBP
(2) Real-world model (P-ER diagrams)
(1) Relational data model
(2) Relational algebra and relational calculi
(2) Introduction to SQL - DDL and DML expressions
(1) Advanced Use of SQL
(1) Functional dependencies and normalization of BP
Introduction to Competitive Work and Transactions

12.

Learning methods

Lectures using presentations, interactive lectures, exercises (using equipment and software packages), teamwork, case studies, guest lectures, independent preparation and defense of a project assignment and a seminar paper.

13.

Total available time

6 ECTS x 30 hours = 180 hours

14.

Distribution of available time

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

15.

Forms of teaching activities

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

16.

Other forms of activities

16.1.	Project assignments	10 hours
16.2.	Independent assignments	10 hours
16.3.	Home study	70 hours

17.

Assessment method

17.1.	Tests	10 points
17.2.	Seminar paper / 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.

Requirement for obtaining a signature and taking the final exam

Activities 15.2 and 16.1 have been completed.

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