Databases

Course title

Databases

Code

F18L3W004

Study programme

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

Faculty of Computer Science and Engineering

Degree level (first, second, third cycle)

First cycle

Academic year / semester

5 / Winter

Number of ECTS credits

Teacher

—

Prerequisites for enrolling in the course

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

10.

Course objectives (competences)

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.

Course content

(2) Physical organisation of data (data structures and indices)
(1) Introduction to DBMS
(2) Conceptual modelling and database design (E-ER 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

Lectures using presentations, interactive lectures, exercises (using equipment and software packages), teamwork, case studies, guest lecturers, 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 the available time

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

15.

Forms of teaching activities

15.1.	Lectures – theoretical teaching	30 hours
15.2.	Exercises (laboratory, auditory), seminars, team work	60 hours

16.

Other forms of activities

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

17.

Grading

17.1.	Tests	10 points
17.2.	Seminar paper / project (presentation: written and oral)	10 points
17.3.	Activity and participation	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.

Requirements for signature and taking the final exam

Activities 15.2 and 16.1 have been completed.

20.

Language of instruction

Macedonian and English

21.

Method of monitoring teaching quality

internal evaluation and survey mechanism

22.

Literature

22.1.	Required literature No. Author Title Publisher Year
22.2.	Additional literature No. Author Title Publisher Year