Subject: Databases
Course: Databases
ECTS credits: 6
Language: Croatian
Duration: 1 semester
Status: compulsory
Method of teaching: 2+2
Prerequisite: none
Assessment: written and oral exam

Course description:
The role and problems of databases in information systems. Management system, logical schemas and database content. Database and OS relations. Normalization, integrity and data protection. Programming languages for the work with databases. Basic elements of a relational database. Data types. Management system. Logical field, database and table. Catalogues. Data protection. Planning and design of schema. Schema refreshing. Other operations on schemas. Operations on tables. Inserting data into a table. Deleting data from a table. Table refreshing. Sorting. Queries and database searching. Searching conditions. Compound queries. Arithmetic operators. Relational operators. Logical operators. Operators for working with strings. Operators for working with dates. Database selection and field selection. Working with multiple tables. Data conversion. Reports. Report types. Selection and design of report. Object oriented databases. Objects, methods and messages. Objects and classes. Classes, instances and collections.
Practical classes use examples that closely follow lectures.

Course objectives:
Students are expected to become familiar with the concepts, possibilities and role of databases and retrieval systems inside the information system. Practical classes will enable student to familiarize him/herself and become proficient in different methods of database management. Some of well-known PC databases will be used for these purposes.

Quality check and success of the course: Quality check and success of the course will be done by combining internal and external evaluation. Internal evaluation will be done by teachers and students using survey method at the end of semester. The external evaluation will be done by colleagues attending the course, by monitoring and assessment of the course.

Reading list:
1. Radovan, M.: Baza podataka, Informator, Zagreb, 1993.
2. Tkalac, S.: Relacijski model podataka, Informator, Zagreb, 1988.
3. Ullman, D. J.: Database and Knowledge – base Systems, Computer Science Press, 1999.