Bachelor
2023/2024
Data management in database design
Type:
Compulsory course
Area of studies:
Business Informatics
Delivered by:
Department of Business Informatics
Where:
Graduate School of Business
When:
2 year, 1 module
Mode of studies:
offline
Open to:
students of one campus
Language:
English
ECTS credits:
3
Contact hours:
36
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
Interim Assessment
- 2023/2024 1st module0.3 * Activity on practice lessons + 0.2 * Database development project + 0.3 * Exam + 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