SLO | EN

Objectives and competences

Students acquire at this course 1. in-depth understanding of the role and importance of computer databases 2. the ability to independently organize and manage databases 3. the ability to independently manage data within modern databases 4. the ability to create organizational and personnel elements in the operation of, and the operation of databases themselves

Content (Syllabus outline)

1. Basic terms used with databases 2. Databases and processes of organizing and management 3. Data modelling (relational and object databases) 4. Database management systems 5. Databases on the web 6. OLAP cube 7. Organizational approaches to databases 8. Data security 9. Future trends in databases (NO-SQL databases, big data, ...)

Learning and teaching methods

Lectures Case studies Exercises Individual work in groups: developing a database

Intended learning outcomes - knowledge and understanding

Knowledge and understanding: • to define the role and importance of computer databases • to plan changes to an existing data model • to perform complex queries in relational database management systems • to organize (day-to-day) operations on a database • to define legal and security aspects of the development and maintenance of databases

Intended learning outcomes - transferable/key skills and other attributes

- ability to analyze a system and - to build and implement a database model in selected database management system; - ability to organize and cooperate in a life cycle of a database

Readings

• Šet A (2017) Načrtovanje in postavitev podatkovnih baz. Ljubljana, i2. • Elmasri R, Navathe SB (2017) Fundamentals of database systems (7. izd.) Boston, MA: Pearson. • Coronel C, Morris S (2017) Database systems: design, implementation, and management (12. izd.). Boston, MA: Cengage Learning. • Kimball R, Ross M, Becker B, Mundy J, Thornthwaite W (2016) The Kimball group reader: relentlessly practical tools for data warehousing and business intelligence remastered collection (2. izd.). Indianapolis, IN: John Wiley & Sons.

Prerequisits

Prerequisites for enrolling: in-depth knowledge of the set theory basic knowledge of ICT understanding of systems analysis basic knowledge of computer programming Exam admission requirement: positive evaluation of a seminar work and its defence and positive examination of tasks at exercises

  • izr. prof. dr. UROŠ RAJKOVIČ, univ. dipl. org.

  • Written examination: 100

  • : 39
  • : 27
  • : 114

  • Slovenian
  • Slovenian

  • ORGANIZATION AND MANAGEMENT OF INFORMATION SYSTEMS - 2nd