CHAPTER 3 WEEK 5
CHAPTER 3 WEEK 5 Managing data involves ensuring it is accurate, complete, timely, consistent, accessible, relevant, and concise. However, managing data is challenging due to the increasing amount of data, its scattered nature, and potential issues like data degradation, data rot, and conflicting data. Data governance is managing information across an organisation, allowing for consistent, accurate, and timely storage, maintenance, exchange, and synchronisation. Database management systems, such as relational databases, provide tools for data access, modification, and analysis. Query languages like SQL data dictionaries and normalisation help in managing data effectively. Data warehouses and data marts are historical data repositories used for decision-making in organisations. They use Online Analytical Processing (OLAP) and are integrated, time-variant, nonvolatile, and multi-dimensional. Knowledge management systems help organisations manipulate unstructured information. IT uses data...