Individual course details
Study programme Applied and Computer Physics
Chosen research area (module)  
Nature and level of studies Undergraduate Studies
Name of the course Informational systems and databases
Professor (lectures) Prof Zoran Nikolić
Professor/associate (examples/practical) Prof Zoran Nikolić, Miloš Burger, Dragan Pantić
Professor/associate (additional)  
ECTS 4 Status (required/elective) Elective
Access requirements  
Aims of the course Introduction to the basics of information systems and databases. Implementation of databases in systems of complex scientific and technical information.
Learning outcomes Adoption of theoretical foundations of organization and data processing and knowledge of the basics of information systems. Adopting basic concepts of modern databases. Acquiring practical knowledge necessary for the development of complex relational databases on various development platforms based on SQL language. Application of acquired knowledge in the design and implementation of databases in systems of scientific and technical information.
Contents of the course
Lectures 1. Informatics and information system. Information and entropy. Information and data. 2. Organizational data units. Data Structures. 3. Access to data. Processing files. 4. File types. 5. Database concept. Conceptual scheme. Physical scheme. 6. Basic database properties. Data redundancy control. Independence and reliability of data. Database management. 7. Database languages. Types of databases. Relational databases. The term relation and table. Relational operations. 8. Basics of SQL Language. Tables, queries keys and indexes. 9. SQL functions. Operators in SQL Predictions. Parameters in queries. Structure of SQL sentences. Ugneždeni vpiti. Decomposition of complex queries. 10. Advanced Techniques in Microsoft Access. Forms and reports. Manage Microsoft Access databases using developed programs.11. Advanced techniques in MySQL. Manage MySQL databases using developed programs with direct access to MySQL libraries. 12. Universal access to databases via ODBC connection.13. Marking systems. Creation and use of nomenclature. 14. Centralized and distributed information systems. Administrative information systems. Automated communication systems. 15. Systems of scientific and technical information. Finding information online. WEB environment.
Examples/ practical classes Computational exercises follow the lectures.
Recommended books
1 P. DuBois, MySQL The definitive guide to using, programming, and administering MySQL 4.1 and 5.0, Sams, (2005).
2 A. Baron, K. Getz, P. Litwin, Access Cookbook,  O'Reilly, (2004).
3  
4  
5  
Number of classes (weekly)
Lectures Examples&practicals   Student project Additional
2 2      
Teaching and learning methods Lectures and exercises, consultations, homeworks.
Assessment (maximal 100)
assesed coursework mark examination mark
coursework 10 written examination 20
practicals   oral examination 40
papers      
presentations 30