Managing Knowledge and Data Ch5

Managing Knowledge and Data

 

Identify three common challenges in managing data. And describe one way organizations can address each challenge using data governance.
Three common challenges in managing delta are:
• Data are scattered throughout organizations and are collected by many individuals using vinous methods and devices. These data are frequently stored in numerous servers and locations and in different computing systems, databases, formats, and human and computer languages.
• Data come from multiple sources.
• Information system that support particular business processes imposes unique requirements on data, which results in repetition and conflicts across an organization.

One strategy for implementing data governance is master data management. Master data management provides companies with the ability to store, maintain, exchange, and synchronize a consistent, accurate, and timely "single version of the truth" for the company's core master data. Master data management consistently manages data gathered from across an organization, data from multiple sources, and data across business processes in an organization.

 

 Name six problems that can be minimized by using the database approach.
The database approach minimizes the following problems: data redundancy, data isolation, data inconsistency, data security, data integrity, and data independence.
Demonstrate how to interpret relationships depicted in an entity- relationship diagram.
See Figures 53 and 5.4 for a demonstration of interpreting relationships in an ER diagram.

 

Discuss at least one main advantage and one main disadvantage of relational databases.
Relation database enable people to compare information quickly by row or column. In addition, users can retrieve items by finding the point of intersection of a particular row and column. However, large-scale relational databases can be composed of many interrelated tables, making the overall design complex with slow search and access times.