Objectives and competences
The objective of this course is to introduce students to the basic concepts and approaches related to data storage and querying in modern IT systems, and to qualify them for the database implementation. The course addresses the available data models for storing data for different use cases, introduces the steps necessary for implementing a database for a given domain, and the query language syntax for retrieving data stored in a database.
Content (Syllabus outline)
• Introduction to databases – basic concepts.
• Data models (relational, non-relational) for data storage.
• Basic features and functioning of Database Management Systems (DBMS).
• Database design – basic concepts and elements of the conceptual data model.
• Database implementation and management in a DBMS.
• Use cases of database implementation in different domains.
• Data querying approaches. Database query types.
• SQL query language – basic concepts and syntax.
• The role of databases in the development of modern applications.
Learning and teaching methods
• lectures,
• laboratory exercises
Intended learning outcomes - knowledge and understanding
On completion of this course the student will be able to
• understand the basic concepts of databases;
• identify an appropriate data model for storing data in a given use case;
• design a database for a given application domain;
• use the selected Database Management System (DBMS) to implement a database;
• use the query language syntax to retrieve data stored in a database.
Transferable/Key skills and other attributes:
• Communication skills: oral project defence.
• Use of information technology: use of computer tools and the selected DBMS for database design and implementation.
• Problem solving: designing a database that meets the domain-related requirements, using technologies for data storage and querying appropriately.
Readings
• G. Powell: Database Modeling Step by Step, CRC Press, 2020.
• T. M. Connolly, C. E. Begg: Database Solutions, A Step-by-step Guide to Building Databases, Pearson Addison Wesley, 2004.
• J. L. Harrington: Relational Database Design Clearly Explained, 2nd Edition, Morgan Kaufmann, 2002.
• B. Brumen: SQL : osnove strukturiranega poizvedovalnega jezika. 1. Izd., DZS, 2013.
