Subject: Database Design (17 - IZOO20)


Basic Information

CategoryProfessional-applicative
Scientific or art field:Information-Communication Systems
InterdisciplinaryNo
ECTS5
Native organizations units

Course native organizational units not found!
Course specification

Course is active from 05.05.2014..


Precondition courses

Course idMandatoryMandatory
Introduction to Information System EngineeringYesYes
Acquiring in-depth knowledge in the field of contemporary data base systems, data base design techniques and involvement into real data base design project.
By the end of the course, students should be able to: demonstrate understanding of the principles of database systems generally and the Entity-relational and the relational database models specifically; explain the basic principles and common trade-offs in designing a relational database, and to design it; set up, query, and update a relational database using interactive SQL.
Development of procedures for data management and data base concept. Fundamental concepts and characteristics of data models. Entity Relationship (ER) data model. Relational data model. Classification and types of constraints in relational data model. Functional dependencies and equivalent keys of relation scheme. Update anomalies. Normal forms. Techniques for relational data base schema design. Structured Query Language (SQL) for data definition and data manipulation.
Lectures; laboratory exercises; individual consultations; team work on the design of conceptual data base schema; individual work (assignments). Students are encouraged to communicate, to reason critically, to work independently and to contribute actively to teaching process.
AuthorsNameYearPublisherLanguage
Mogin, P., Luković, I.Principi baza podataka1996Fakultet tehničkih nauka, Novi SadSerbian language
Mogin, P., Luković, I., Govedarica, M.Principi projektovanja baza podataka2004Fakultet tehničkih nauka, Novi SadSerbian language
Date C. J.Relational Theory for Computer Professionals: What Relational Databases Are Really All About2013OReilly MediaEnglish
Date C. J.Database Design and Relational Theory: Normal Forms and All That Jazz 2012O Reilly MediaEnglish
Elmasri, R., Navathe, S.B.Database Systems Models, Languages, Design and Application Programming2010Pearson, BostonEnglish
Mihajlović, D.Informacioni sistemi i projektovanje baza podataka1998Fakultet tehničkih nauka, Novi SadSerbian language
Kordić, S. i dr.Baze podataka : zbirka zadataka2018Fakultet tehničkih nauka, Novi SadSerbian language
Course activity Pre-examination ObligationsNumber of points
Complex exercisesYesYes10.00
Complex exercisesYesYes15.00
Complex exercisesYesYes10.00
Project taskYesYes15.00
TestYesYes10.00
TestYesYes10.00
Oral part of the examNoYes30.00
Name and surnameForm of classes
Missing picture!

Ristić Sonja
Full Professor

Lectures
Missing picture!

Antanasijević Dajana
Assistant - Master

Computational classes
Missing picture!

Spasojević Ivana
Assistant - Master

Computational classes
Missing picture!

Petrovački Jelena
Teaching Associate

Computational classes
Missing picture!

Gladić Dejana
Teaching Associate

Computational classes