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.
• 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
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
Lazarević B., Marjanović Z., Aničić N, Babarogić S., (2003) Baze podataka, Fakultet organizacionih nauka, Beograd
Ramakrishnan R., Gehrke J., (2002) Database Managament Systems, McGraw-Hill
Teaching Methods • lectures • work in a computer laboratory • class presentations of case studies • debates