Chapter 6 Foundations of Business Intelligence: Databases and Information Management 243 MyLab MIS To complete the problems with MyLab MIS, go to the EOC Discussion Questions in MyLab MIS. Review Questions 6-1 What are the problems of managing data 6-3 What are the principal tools and technologies resources in a traditional file environment? for accessing information from databases to - List and describe each of the components improve business performance and decision in the data hierarchy. making? - Define and explain the significance of enti- - Define big data and describe the technoloties, attributes, and key fields. gies for managing and analyzing it. - List and describe the problems of the tradi- - List and describe the components of tional file environment. a contemporary business intelligence infrastructure. 6-2 What are the major capabilities of database management systems (DBMS), and why is a - Describe the capabilities of online analytirelational DBMS so powerful? cal processing (OLAP). - Define a database and a database manage- - Define data mining, describing how it difment system. fers from OLAP and the types of informa- - Name and briefly describe the capabilities tion it provides. of a DBMS. - Explain how text mining and web mining - Define a relational DBMS and explain how differ from conventional data mining. it organizes data. - Describe how users can access informa- - List and describe the three operations of a tion from a company's internal databascs relational DBMS. - Explain why non-relational databases are through the web. useful. 6-4 Why are information policy, data administration, and data quality assurance essential for - Define and describe normalization and refmanaging the firm's data resources? erential integrity and explain how they con- - Describe the roles of information policy tribute to a well-designed relational database. and data administration in information - Define and describe an entity-relationship management. diagram and explain its role in database - Explain why data quality audits and data design. cleansing are essential