| 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 | |||||||||