Information Structures and Database Systems

The course includes, but is not limited to, the following topics:

• Basic concepts of database and database management systems.
• Conceptual data modeling.
• Introduction to relational model, constraints and relational algebra.
• Logical database design and normalization.
• SQL for defining, manipulating and querying database.
• XML data, XML Schema, XPath and XSLT.

After completing the course successfully,

The student has knowledge of:

- Database management systems - characteristics and general structure.

- Data modeling with a focus on conceptual modeling.

- Relational model, its characteristics and integrity constraints.

- Query language ​​for relational model.

- Logical design and normalization for relational databases.

- Structuring and management of semi-structured data using XML.

The student acquires the skills to:

- Create and assess conceptual and associated logical data models.

- Construct relational database solutions based on conceptual and logical models.

- Employ normalization to evaluate and assess relational databases.

- Make use of SQL for defining, manipulating and querying relational databases.

- Utilize XML technologies for storing and processing semi-structured data.

The student acquires general competence in:

- Knowledge of database systems - their applications, benefits and limitations.

- Creating abstract models and solutions for practical problems.

- Assessing alternatives for storing and managing digital data.

- Using computer tools for developing software systems.

Lectures, in-class exercises, laboratory work, assignments.