Professional study programme

Back   Schedule   Hrvatski

Data Bases SR402-15

ECTS 7 | P 30 | A 15 | L 30 | K 0 | ISVU 149330 205567 | Academic year: 2020./2021.

Course groups

Prikaži sve grupe na predmetu

Course lecturers

OMRČEN LUKA, Associate
FILKO DAMIR, Associate

Course description

Information system. Business system model. Data bases. Database management system. Information system development. Development methods. Development phases. Data modelling. Conceptual data modelling. Entity relationship model. Object models. Logical data modelling. Relational data model. Relational algebra. SQL. Integrity rules in the relational database model. Normalisation. Network, hierarchical and relational model. Physical data modelling. Data control. Control functions. Computer-aided control.

Knowledge and skills acquired

Basic knowledge of database working principles. Basic knowledge of development methods of a communication system. Knowledge of conceptual, logical and physical data modelling, SQL language use, data normalisation and data management.

Teaching methods

Mandatory lectures and laboratory exercises.

Student requirements

Defined by the Student evaluation criteria of the Faculty of Electrical Engineering, Computer Science and Information Technology Osijek and paragraph 1.9

Monitoring of students

Defined by the Student evaluation criteria of the Faculty of Electrical Engineering, Computer Science and Information Technology Osijek and paragraph 1.9

Student assessment

Successful design of a date base in laboratory exercises, tests, oral examination.

Obligatory literature

1. 1 Hamilton, Bill Programiranje SQL Server 2005 O Reilly, 2006

2. 2 Churcher, Clare Beginning Database Design, 2nd Edition New York: Apress, 2012.

3. 3 D. Grundler Primijenjeno računalstvo Graphis, Zagreb, 2000.

Pretraži literaturu na:

Recommended additional literature

1. 1 E. Codd The Relational model for -base Management Addison Wesley, 1990.

2. 2 L. Budin Informatika za 1. razred gimnazije Element, Zagreb, 1997.

3. 3 J. Martin Computer-base Organization Prentice Hall, 1977.

4. 4 M. Varga Baze podataka DRIP- Zagreb, 1994.

Examination methods

Written and oral exam.

Course assessment

Conducting university questionnaires on teachers (student-teacher relationship, transparency of assessment criteria, motivation for teaching, teaching clarity, etc.). Conducting Faculty surveys on courses (upon passing the exam, student self-assessment of the adopted learning outcomes and student workload in relation to the number of ECTS credits allocated to activities and courses as a whole).

Overview of course assesment

Learning outcomes
Upon successful completion of the course, students will be able to:

1. analyse, describe and define entity relationship diagram

2. convert an ER diagram into a relational model

3. evaluate and apply the normalisation procedure to the relations, compare and distinguish between the basic relational algebra operations

4. create complex relations using SQL

5. create a database, forms for data entry and writing queries and views, and evaluate final database release

6. connect to the database, make queries in the appropriate programming language and evaluate usage of different programming languages

Aktivnosti studenta: Vidi tablicu aktivnosti