Data management in database design

2022/2023

Учебный год

ENG

Обучение ведется на английском языке

3

Кредиты

Кто читает:

Департамент бизнес-информатики

Статус:

Курс обязательный

Когда читается:

2-й курс, 1 модуль

Преподаватели

Вольпе Михаил Борисович

Гоменюк Кирилл Сергеевич

Неклюдов Дмитрий Юрьевич

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.

Learning Objectives

• Can use special software to design a relational database
• Know design methods applicable to operational and analytical databases

Expected Learning Outcomes

• Can evaluate quality of relational data model
• Able to explore dependencies of attributes and solve data redundancy problems
• Able to design conceptual data models
• Develop a relational database from ER diagram
• Analyze business activity and identify relevant information objects to be included in the data model
• Design a dimensional model for a data mart

Course Contents

• Data redundancy problem in relational data models. Normalization.
• Entity-relationship approach to database design. Mapping of conceptual model to relational schema.
• Introduction to data warehouses

Assessment Elements

• Activity on practice lessons
• Database development project
• Homeworks
• Exam

Interim Assessment

• 2022/2023 1st module
  0.3 * Activity on practice lessons + 0.3 * Exam + 0.2 * Database development project + 0.2 * Homeworks

Bibliography

Recommended Core Bibliography

• Database systems : design, implementation, and management, Rob, P., 2007
• Harrington, J. L., & Harrington, J. L. (2016). Relational Database Design and Implementation (Vol. Fourth edition). Amsterdam: Morgan Kaufmann. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1214612

Recommended Additional Bibliography

• Elmasri, R., & Navathe, S. (2014). Fundamentals of Database Systems: Pearson New International Edition (Vol. Sixth edition). Harlow, Essex: Pearson. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1418149
• Linstedt, D., & Olschimke, M. (2015). Building a Scalable Data Warehouse with Data Vault 2.0. Amsterdam: Morgan Kaufmann. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1065504