Data management in database design

2024/2025

Academic Year

ENG

Instruction in English

3

ECTS credits

Delivered at:

Department of Business Informatics

Course type:

Compulsory course

When:

2 year, 1, 2 module

Instructor

Gomenyuk, Kirill

Course Syllabus

Abstract

This course on data management for 2nd year students is the 2nd part of SQL course. The course focuses on relational database design. Topics discussed include theoretical aspect of data modeling, conceptual and logical design, and introduction to data warehouses.After completing the 2nd year Data Management course students will know how to create a a relational database from business requirements using special software, understand difference between operational and analytical databases, and learn to analyze data structure. Curriculum consists of three parts: data redundancy problem and normalization methods, entitiy-relationship approach to database design, brief overview of data warehouse architecture.