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
Additional information on implementation and assessment - written exam 100 %
Written exam can be substituted with active participation at lectures