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