Week 5 - Chapter 3
Chapter 3 covers various aspects of data and knowledge management. It begins by addressing the challenges of managing data, emphasizing the significance of data governance in maintaining data quality and integrity. The chapter then explores the database approach, highlighting the evolution from file management to database management systems (DBMS). It talks about how relational databases work easily and effectively, how SQL helps ask questions from databases, and why data dictionaries are useful for keeping things organized. It also explains how normalization makes data more reliable and looks at some problems that can happen when designing databases. In addition to discussing the importance of data dictionaries and normalization for database design, the chapter emphasizes the crucial role of data warehouses and data marts in supporting decision-making processes. Data dictionaries provide standardized definitions for attributes and ensuring consistency for...