Undergraduate study programme

Back   Loomen   Schedule   Hrvatski

Data Bases PRK501

ECTS 7 | P 45 | A 15 | L 15 | K 0 | ISVU 74228 | Academic year: 2018./2019.

Course groups

Prikaži sve grupe na predmetu

Course lecturers

ROMIĆ KREŠIMIR, Associate
KRPIĆ ZDRAVKO, Associate
LUKIĆ IVICA, Lecturer

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.

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. list basic database terms, and use ER diagram for database modeling

2. differentiate database models with the emphasis on a relational model, and create a relational database model from an ER diagram

3. comprehend a normalised relational database schema and sketch a database using normalisation

4. create a database using SQL queries on various database management systems

5. evaluate and implement simple and complex SQL queries using relational algebra

6. create SQL queries to ensure database security and integrity, and understand the link between database integrity and business rules

7. organize transactions, create functions, stored procedures and views



Aktivnosti studenta:

Student's activity Workload ECTS (Workload/30) Learning outcomes
Upon successful completion of the course, students will be able to:
Teaching
method
Assessment method Points
Pohađanje Predavanja (PR), Auditorne vježbe (AV), Laboratorijske vježbe (LV)752.51,2,3,4,5,6,7Predavanja (PR), Auditorne vježbe (AV), Laboratorijske vježbe (LV)Predavanja (PR), Auditorne vježbe (AV), Laboratorijske vježbe (LV)35
Rješavanje zadataka6022,3,4,5Kontrolne zadaće (pismeni ispit)Provjera riješenih zadataka2550
Pisanje priprema za LV, analiza rezultata, te pisanje izvještaja3014,5,6,7Laboratorijske vježbe (LV)Provjera pripreme za LV, nadzor provođenja LV-a, provjera napisanih izvještaja815
Priprema za usmeni ispit i usmeno odgovaranje na pitanja451.51,2,3,5Usmeni ispitProvjera danih odgovora1530