Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Database Design (17.IZOO20)

Type of studies	Title
Undergraduate Academic Studies	Industrial Engineering (Year: 4, Semester: Winter)

General information:

Category	Professional-applicative
Scientific or art field	Inženjerstvo informacionih sistema Information-Communication Systems
ECTS	5

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.

Authors	Title	Year	Publisher	Language
Elmasri, R., Navathe, S.B.	Database Systems Models, Languages, Design and Application Programming	2010	Pearson, Boston	English
Date C. J.	Database Design and Relational Theory: Normal Forms and All That Jazz	2012	O Reilly Media	English
Date C. J.	Relational Theory for Computer Professionals: What Relational Databases Are Really All About	2013	OReilly Media	English

Course activity	Pre-examination	Obligations	Number of points
Complex exercises	Yes	Yes	10.00
Complex exercises	Yes	Yes	15.00
Test	Yes	Yes	10.00
Oral part of the exam	No	Yes	30.00
Test	Yes	Yes	10.00
Complex exercises	Yes	Yes	10.00
Project task	Yes	Yes	15.00