Professional study programme

Back   Schedule   Hrvatski

Database Design SIR607-17

ECTS 5 | P 30 | A 0 | L 30 | K 0 | ISVU 175217 | Academic year: 2018./2019.

Course groups

Prikaži sve grupe na predmetu

Course lecturers

LUKIĆ IVICA, Lecturer
KRPIĆ ZDRAVKO, Lecturer

Goals

The aim of this course is to clarify the process of database design according to different models, as well as design of interfaces and background applications that will make use of the created database. Students will be introduced to various development environments used in database design, depending on the database model. Students will be introduced to the state-of-the-art tools for rapid development of upgradable databases of high quality, by using a relational model and the latest NoSQL databases.

Conditions for enrollment

Requirements met for enrolling in the third year of the study programme

Course description

Design databases using different technologies and software solutions. Introduction to NoSQL databases. Database utilisation in various technologies such as JavaScript (Angular, NodeJS), PHP (Laravel, Zend). The advantages and disadvantages of relational databases compared to NoSQL databases. Advanced applications and applications in practice. Part of the course conducted through independent research work, as well as monitoring of basic sources and the latest technologies.

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

Obligatory literature

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

2. 2 Shackelford, Adam Beginning Amazon Web Services with Node.js New York: Apress, 2015.


Pretraži literaturu na:

Recommended additional literature

1. 1 K. Williamson Learning AngularJS Published by O Reilly Media, Inc., 1005 Gravenstein Highway North Sebastopol, CA 95472, 2015.

2. 2 R. Nixon Learning PHP, MySQL & JavaScript With jQuery, CSS & HTML5 O Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472, 2014.

3. 3 C. Pitt Pro PHP MVC, Apress, Apress Media LLC 233 Spring Street New York, NY 10013, 2012.

4. 4 L. Ullman PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide (3rd Edition) Peachpit Press, 1301 Sansome Street, San Francisco, CA 94111, 2012.

5. 5 Sadalage, Pramod J.; Fowler, Martin NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence 1st Edition RR Donnelley in Crawfordsville, Indiana, November 2014.

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. compare different database models

2. compare different technologies for database design

3. use complex logical database models, upgrade them according to needs for different database management systems

4. analyse and solve a specific problem, combine different technologies and development environments for database design

5. understand and implement simple and complex queries depending on the database model

6. maintain database, make backup and documentation for users and database administrators



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)6021,2,3,4,5,6Predavanja (PR), Laboratorijske vježbe (LV)Predavanja (PR), Laboratorijske vježbe (LV)610
Pisanje priprema za LV, analiza rezultata, te pisanje izvještaja3012,3,4,5Laboratorijske vježbe (LV)Provjera pripreme za LV, nadzor provođenja LV-a, provjera napisanih izvještaja1520
Priprema za usmeni ispit i usmeno odgovaranje na pitanja3011,2,3Usmeni ispitProvjera danih odgovora2040
Projekt3013,4,5,6Samostalna izrada Web aplikacijeProvjera riješenog zadataka1530