• Semester 6, position 4

The main goal of this course is to understand the basic concepts necessary for the design, implementation and use of a functional database.

Students will be able to apply basic techniques of database design and implementation without anomalies. They will also acquire the skills for database manipulation that are necessary for both database administration and database application development.

Concepts and architecture of database management systems. Data model. Conceptual data model, entity relationship model. Logical data model, relational model. Relational algebra, SQL. Data anomalies, functional dependence. Armstrong's rules. Normal forms and decomposition. Physical model, secondary memory. I/O computation model. File organization. Index files, indexes. Parallel processing, transactions.

Real system database design and implementation development in a modern environment by using certain database management system.

No prerequisites for attending classes

Computer lab

Total assigned hours: 75

New material: 20
Elaboration and examples (recapitulation): 10

Auditory exercises: 10
Laboratory exercises: 20
Calculation tasks: 0
Seminar paper: 0
Project: 0
Consultations: 0
Discussion/workshop: 0
Research study work: 0

Review and grading of calculation tasks: 0
Review and grading of lab reports: 0
Review and grading of seminar papers: 0
Review and grading of the project: 15
Test: 0
Test: 0
Final exam: 0

Activity during lectures: 0
Test/test: 0
Laboratory practice: 0
Calculation tasks: 0
Seminar paper: 0
Project: 40
Final exam: 60
Requirement for taking the exam (required number of points): 30

Gordana Pavlović-Lažetić; Uvod u relacione baze podataka; Matematički fakultet;1999; Ramakrishnan, Gehrke; Database Management Systems; McGraw-Hill; 2002