Undergraduate study programme

Ak.g.2014./2015.2015./2016.2016./2017.2017./2018.

Back   Loomen   Schedule   Hrvatski

Data Bases PRK501

ECTS 7 | P 45 | A 15 | L 15 | K 0 | ISVU 74228

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

Lectures are optional, laboratory practice is obligatory

Student assessment

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

Obligatory literature

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

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

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

Pretraži literaturu

Recommended additional literature

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

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

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

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

ECTS credits

An ECTS credit value has been added according to calculation of time required for studying and successful course completion.

Examination methods

Written and oral exam.

Course assessment

At the end of the semester an official enquiry can be conducted concerning students` evaluation of the course lectures and lecturers participating in the course teaching

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. Sketch a normalized relational database schema using normalisation.

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

5. Understand simple and complex SQL queries using relational algebra

6. Apply 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



Learning outcomes available only as desktop version    Export to Excel

Prvo unesite postotak evidencije nazočnosti!

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
Attendance
Lectures, Auditory exercises, Laboratory exercises

ECTS
Lectures, Auditory exercises, Laboratory exercises Attendance register. Mandatory attendance percentage is:
%

This percentage defines the minimum workload for the activity. The maximum is defined by the study programme.
Min

Max

Oral exam Workload
ECTS

Oral exam Assessment of student's answers Min

Max

Σ Activities Σ Workload
0
Σ ECTS
0
Nisu svi ishodi odabrani! Σ Max
0