Course ID 16СТ42
Programme
  • Applied Informatics
ESPB 7
Number of classes 3+3
Semester 3
Status Core
The main objective of the course is to introduce students to the basic concepts of databases and their models, techniques for designing database schemas at the conceptual and implementation level as well as the structured query language (SQL) of relational databases. With the practical application of a modern database management system the acquired knowledge is applied with the aim of designing and implementing a database of a real information system.
In addition to a thorough understanding of the principles of the databases, students are trained to solve specific problems using scientific methods and procedures. By participating in the development of database projects based on real systems students develop the skills of abstract thinking, the usage and linking of knowledge from different areas as well as easy adaptation to new development environments.
Theoretical training
• Data models
• Database Concepts
• Database management system
• Entity-relationship data model (ER model)
• Relationship data model
• Structured Query Language (SQL) of relational database management systems
• Normal forms and normalization
• Conceptual, logical and implementation design of a database schema
• Object-oriented data model

Practical training
The use of modern tools for the design and implementation of a real database system, its maintenance and search.
Date C. J., (2003) An Introduction to Database Systems, Addison-Wesley
Лазаревић Б., Марјановић З., Аничић Н, Бабарогић С., (2003) Базе података, Факултет организационих наука, Београд
Ramakrishnan R., Gehrke J., (2002) Database Managament Systems, McGrаw-Hill
Teaching Methods • lectures • work in a computer laboratory • class presentations of case studies • debates
Assessment (maximum number of points – 100)
Exam Requirements 55 points Final exam 45 points
Attendance 5 Written exam 20
Ongoing assessment 30 Oral exam 25
Class participation 10  
Case  study 10