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. DB development. Data flow. Entity relationship model. Normalisation. 1,2,3, and other normal forms. DB management system. SQL.

Knowledge and skills acquired

Basic knowledge of the data bases. Basic knowledge of the system and application software.

Teaching methods

Lectures are optional, laboratory practice is obligatory

Student assessment

Successful completion of laboratory practice, tests and 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 examination.

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. Nabrojati osnovne pojmove vezane uz bazu podataka, i upotrijebiti ER dijagram za modeliranje baze podataka

2. Razlikovati modele baze podataka s naglaskom na relacijski model, i izgraditi relacijski model baze podataka iz ER dijagrama

3. Skicirati normaliziranu relacijsku shemu baze podataka uz primjenu normalnih formi

4. Implementirati bazu podataka korištenjem SQL naredbi na različitim sustavima za upravljanje bazom podataka

5. Razumjeti i implementirati jednostavne i složene SQL upite koristeći relacijsku algebru

6. Primijeniti SQL naredbe za osiguranje sigurnosti i integriteta baze podataka te razumjeti vezu između integriteta baze podataka i poslovnih pravila

7. Organizirati rad s transakcijama, kreirati funkcije, pohranjene procedure i poglede



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
Σ Max
0