Data and Knowledge Management Test Bank Chapter 5 Exam Prep

Package Title: Chapter 5, Testbank

Course Title: Rainer, IS 5e

Chapter Number: 5

Question type: Multiple Choice

1) Vivametrica was asked to compare the data collected from the claimant’s

Fitbit to the general population health data and_______.

a) Judge whether they were below normal for someone in her age range and of her former

professionb) Judge whether they were above normal for someone in her age range and of her former

professionc) Judge whether they were below normal for someone in her weight range and of her former

profession

d) Judge whether they were normal for someone in her age range and of her former

profession

Difficulty: Easy

Section Reference 1: Opening Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

2) We leave valuable trails of data behind when we use tracking and recording devices called data ________.

a) debris

b) exhaust

c) markers

d) roads

Difficulty: Easy

Section Reference 1: Opening Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

3) A connected vehicle is equipped with Internet access and usually with a wireless ________.

a) LAN

b) MAN

c) PAN

d) WAN

Difficulty: Easy

Section Reference 1: IT’s About Business 5.1

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

4) IHS Automotive estimates that the average connected car will produce up to 30 _____ of data each day.

a) KB

b) GB

c) TB

d) MB

Difficulty: Easy

Section Reference 1: IT’s About Business 5.1

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

5) Which of the following companies is NOT developing cars and self-driving technology/services?

a) Amazon

b) Apple

c) Google

d) IBM

Difficulty: Easy

Section Reference 1: IT’s About Business 5.1

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

6) ________ are those data that visitors and customers produce when they visit a website and click on hyperlinks.

a) Clickstream data

b) Cookies

c) ERP

d) RFID

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

7) Which of the following is NOT a reason managing data is difficult?

a) Data are generated from multiple sources.

b) Data are scattered throughout organizations.

c) Data are subject to data rot.

d) The amount of data is decreasing exponentially with time.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

8) Data ________ refers primarily to problems with the media on which the data are stored.

a) clickstreaming

b) degradation

c) scattering

d) rot

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

9) You recently inherited an Alvin and The Chipmunks “A Chipmunk Christmas” record. Since you don’t have a record player, you need to find a way to convert the record into a CD. This is an example of data ________.

a) clickstreaming

b) degradation

c) scattering

d) rot

Difficulty: Medium

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Application

Standard 1: AACSB || Technology

10) ________ is an approach to managing information across an entire organization.

a) Big data

b) Data governance

c) Master data

d) Master data management

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

11) ________ is a process that spans all organizational business processes and applications.

a) Big data

b) Data governance

c) Master data

d) Master data management

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

12) ________ are a set of core data that span the enterprise information systems.

a) Data governance

b) Master data

c) Master data management

d) Transaction data

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

13) From the mid-1950s until the early 1970s, organizations managed their data in a _________; this created ________.

a) database; a centralized location for information

b) database; information silos

c) file management environment; a centralized location for information

d) file management environment; information silos

Difficulty: Hard

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge, Synthesis

Standard 1: AACSB || Technology

14) Database systems minimize ________.

a) independence

b) integrity

c) redundancy

d) security

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

15) Database systems minimize ________.

a) inconsistency

b) independence

c) integrity

d) security

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

16) Database systems maximize ________.

a) inconsistency

b) independence

c) isolation

d) redundancy

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

17) Databases ________ redundancy; this means ________.

a) maximize; the same data are stored in multiple locations

b) maximize; various copies of the data do not agree

c) minimize; the same data are stored in multiple locations

d) minimize; various copies of the data do not agree

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

18) Databases ________ inconsistency; this means ________.

a) maximize; the same data are stored in multiple locations

b) maximize; various copies of the data do not agree

c) minimize; the same data are stored in multiple locations

d) minimize; various copies of the data do not agree

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

19) Databases minimize _________; this means ________.

a) independence; applications cannot access data associated with other applications

b) independence; applications and data are not linked to each other, so all applications are able to access the same data

c) isolation; applications cannot access data associated with other applications

d) isolation; applications and data are not linked to each other, so all applications are able to access the same data

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

20) Databases maximize _________; this means ________.

a) independence; applications cannot access data associated with other applications

b) independence; applications and data are not linked to each other, so all applications are able to access the same data

c) isolation; applications cannot access data associated with other applications

d) isolation; applications and data are not linked to each other, so all applications are able to access the same data

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

21) Which of the following is an accurate representation of the data hierarchy from smallest to largest?

a) bit, byte, field, record, file, database

b) bit, byte, field, file, record, database

c) byte, bit, field, record, file, database

d) byte, bit, field, file, record, database

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

22) A ________ represents the smallest unit of data a computer can process.

a) bit

b) byte

c) field

d) file

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

23) A ________ is a group of eight ________.

a) bit; bytes

b) byte; bits

c) field; files

d) file; fields

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

24) Microsoft ________ is a popular example of a relational database.

a) Access

b) Excel

c) PowerPoint

d) Word

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

25) The relational database model is based on the concept of ________-dimensional tables.

a) one

b) two

c) three

d) four

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

26) Each relational database table contains records (listed in _______) and attributes (listed in ______) .

a) columns; columns

b) columns; rows

c) rows; columns

d) rows; rows

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

27) A ________ generally describes an entity.

a) byte

b) field

c) file

d) record

Difficulty: Hard

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

28) A(n) ________ of an entity refers to each row in a relational table, which is a specific, unique representation of the entity.

a) attribute

b) field

c) instance

d) record

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

29) Each characteristic or quality of a particular entity is called a(n) ________.

a) attribute

b) field

c) instance

d) record

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

30) The category “student” is a(n) ________.

a) attribute

b) database

c) entity

d) instance

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Application

Standard 1: AACSB || Technology

31) All the information about you in your university’s database is a(n) ________.

a) attribute

b) database

c) entity

d) instance

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Application

Standard 1: AACSB || Technology

32) Your name in your university’s database is a(n) ________.

a) attribute

b) database

c) entity

d) instance

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Application

Standard 1: AACSB || Technology

33) The ________ key is an identifier field that uniquely identifies a record.

a) alien

b) foreign

c) primary

d) secondary

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

34) The ________ key has some identifying information but does not identify the record with complete accuracy.

a) alien

b) foreign

c) primary

d) secondary

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

35) The ________ creates links between two tables.

a) alien

b) foreign

c) primary

d) secondary

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

36) Considering the following tables, ________ is a primary key.

a) Class Table: PID

b) Professor Table: Name

c) Student Table: Expected Graduation Year

d) Student Table: ID

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Application

Standard 1: AACSB || Technology

37) Considering the following tables, ________ is a foreign key.

a) Class Table: PID

b) Professor Table: Name

c) Student Table: Expected Graduation Year

d) Student Table: ID

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Application

Standard 1: AACSB || Technology

38) Industry experts estimate that ________ percent of data in an organization is unstructured.

a) 10–20

b) 40–50

c) 60–70

d) 80–90

Difficulty: Hard

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

39) Industry experts estimate that 80-90 percent of data in an organization is ________.

a) part-structured

b) semi-structured

c) structured

d) unstructured

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

40) Which of the following is TRUE?

a) Big Data becomes less useful over time since data changes too frequently for a system to maintain.

b) Big Data is so large and complex that it must be managed by using a traditional DBMS.

c) Big Data predictions come from teaching computers to think like humans.

d) Big Data systems perform well because they contain huge amounts of data on which to base their predictions.

Difficulty: Medium

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

41) Which of the following is NOT a characteristic of Big Data?

a) Variety

b) Velocity

c) Viscous

d) Volume

Difficulty: Easy

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

42) Which of the following is NOT a problem associated with Big Data?

a) Big Data can be structured, unstructured, or semi-structured.

b) Big Data can come from untrusted sources.

c) Big Data changes.

d) Big Data lacks quality.

Difficulty: Hard

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

43) Google’s Cloud Spanner is a globally distributed ___ database that ____.

a) NewSQL; synchronizes time

b) NewSQL; tracks users

c) SQL; synchronizes time

d) SQL; tracks users

Difficulty: Medium

Section Reference 1: IT’s About Business 5.2

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Comprehension

Standard 1: AACSB || Technology

44) NewSQL is a class of modern relational database management system that attempts to provide the same scalable performance of ___ systems for ___.

a) NoSQL; OLAP

b) NoSQL; OLTP

c) SQL; OLAP

d) SQL; OLTP

Difficulty: Easy

Section Reference 1: IT’s About Business 5.2

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

45) _______ have been the primary mechanism in many organizations for performing analytics, reporting, and operations. However, they are too rigid to be effective with Big Data.

a) CRMs

b) EDWs

c) ETLs

d) SCMs

Difficulty: Easy

Section Reference 1: IT’s About Business 5.3

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

46) A data _______ is a central repository that stores all of an organization’s data, regardless of their source or format.

a) exhaust

b) lake

c) pond

d) trail

Difficulty: Easy

Section Reference 1: IT’s About Business 5.3

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

47) A data ________ is a repository of historical data that are organized by subject to support decision makers in the organization.

a) mart

b) shop

c) store

d) warehouse

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

48) A data ________ is a low-cost, scaled-down version of a data ________ that is designed for the end-user needs in an SBU or an individual department.

a) mart; store

b) mart; warehouse

c) warehouse; mart

d) warehouse; store

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

49) Data marts can be implemented ________ compared to data warehouses.

a) less quickly

b) more quickly

c) at the same pace

d) It depends on the situation.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

50) Data marts can be implemented ________ quickly than data warehouses and support ________ control.

a) less; central

b) less; local

c) more; central

d) more; local

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

51) Data marts and data warehouses typically use ________.

a) ERP

b) OLAP

c) OLTP

d) RFID

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

52) Data marts and data warehouses are ________; this means they ________ be updated by users.

a) non-volatile; can

b) non-volatile; cannot

c) volatile; can

d) volatile; cannot

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

53) ________ is an example of a source system for a data warehouse.

a) DSS

b) ERP

c) OLAP

d) Web browser

Difficulty: Medium

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

54) Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization’s memory, usually in a(n) ________ format.

a) part-structured

b) semi-structured

c) structured

d) unstructured

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

55) Intellectual capital is another term for ________.

a) data

b) information

c) knowledge

d) wisdom

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

56) ________ is an intellectual asset.

a) Data

b) Information

c) Knowledge

d) Wisdom

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

57) ________ deals with more objective, rational, and technical knowledge.

a) Explicit information

b) Explicit knowledge

c) Tacit information

d) Tacit knowledge

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

58) ________ is the cumulative store of subjective or experiential learning.

a) Explicit information

b) Explicit knowledge

c) Tacit information

d) Tacit knowledge

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

59) Suppose you are a salesperson. You take great pride in knowing each customers’ favorite places to eat and their favorite meals. This is an example of ________.

a) explicit information

b) explicit knowledge

c) tacit information

d) tacit knowledge

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Application

Standard 1: AACSB || Technology

60) Suppose you work for XYZ Corporation. You know you can contribute 6% of your salary to a 401K and the company will match that 100% after 6 years of service because it is in the employee handbook. This is an example of ________.

a) explicit information

b) explicit knowledge

c) tacit information

d) tacit knowledge

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Application

Standard 1: AACSB || Technology

61) Which of the following is the correct order of the KMS cycle?

a) capture, create, refine, store, manage, disseminate

b) capture, create, refine, store, disseminate, manage

c) create, capture, refine, store, manage, disseminate

d) create, capture, refine, store, disseminate, manage

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

62) Laurie heads up a team creating a new process for the shipping department of her company. She worked with external consultants and wrote a process diagram. The team is now asking the VP of shipping to review the process diagram and give opinions. Laurie’s team is at the ________ knowledge stage of the KMS cycle.

a) capture

b) disseminate

c) refine

d) create

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Application

Standard 1: AACSB || Technology

63) Laurie heads up a team creating a new process for the shipping department of her company. She worked with external consultants and wrote a process diagram. After getting upper management’s opinions the team posted the new diagram to a corporate portal site. They are now demonstrating the new process to all shipping department employees. Laurie’s team is at the ________ knowledge stage of the KMS cycle.

a) capture

b) disseminate

c) refine

d) create

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Application

Standard 1: AACSB || Technology

64) ________ is the most popular query language used for interacting with a database.

a) ETL

b) RFID

c) SQL

d) TPS

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

65) Microsoft Access uses ________ to conduct queries.

a) ETL

b) QBE

c) RFID

d) TPS

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

66) The ________ provide(s) information on each attribute and why the attribute is needed in the database, who uses it, and how it should be updated.

a) business rules

b) cardinality

c) data dictionary

d) modality

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

67) ________ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity.

a) Business rules

b) Cardinality

c) Data dictionary

d) Modality

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

68) Two vertical lines represent the ________ cardinality symbol.

a) mandatory many

b) mandatory single

c) optional many

d) optional single

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

69) A circle with a vertical line represents the ________ cardinality symbol.

a) mandatory many

b) mandatory single

c) optional many

d) optional single

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

70) A vertical line with a “chicken leg” to the entity represents the ________ cardinality symbol.

a) mandatory many

b) mandatory single

c) optional many

d) optional single

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

71) A circle with a “chicken leg” to the entity represents the ________ cardinality symbol.

a) mandatory many

b) mandatory single

c) optional many

d) optional single

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

72) A ________ relationship exists when an association is maintained within a single entity.

a) binary

b) solitary

c) ternary

d) unary

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

73) A ________ relationship exists when two entities are associated.

a) binary

b) solitary

c) ternary

d) unary

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

74) A ________ relationship exists when three entities are associated.

a) binary

b) ternary

c) tertiary

d) unary

Difficulty: Hard

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

75) Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance.

a) maximum; maximum

b) maximum; minimum

c) minimum; maximum

d) minimum; minimum

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

76) Functional dependencies are similar to ________ keys.

a) foreign

b) primary

c) secondary

d) useful

Difficulty: Hard

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Synthesis

Standard 1: AACSB || Technology

77) Which of the following technologies was NOT deployed in the 2018 Tour de France bicycles?

a) Augmented reality

b) GPS

c) RFID

d) Rechargeable battery

Difficulty: Easy

Section Reference 1: Closing Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

78) Each bicycle in the 2018 Tour de France produced a total of more than 3 ____ data points during the course of the race.

a) thousand

b) million

c) billion

d) trillion

Difficulty: Easy

Section Reference 1: Closing Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

79) The 2018 Tour de France bicycles transmitted data over a ___ network.

a) data

b) mesh

c) personal area

d) satellite

Difficulty: Easy

Section Reference 1: Closing Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

Question type: True/False

80) January 2017, a grand jury indicted Compton on felony charges of aggravated arson and insurance fraud.

Difficulty: Easy

Section Reference 1: Opening Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

81)

The more connected, convenient, and intelligent our devices become, the more they have the potential to expose the truth. .

Difficulty: Easy

Section Reference 1: Opening Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

82) In the early 2010s, a personal trainer in Calgary, Alberta was injured in an automobile accident, this case was the first known court case that used Fitbit activity data.

Difficulty: Easy

Section Reference 1: Opening Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Comprehension

Standard 1: AACSB || Technology

83) As we incorporate more and more technology into myriad aspects of daily life, so too are we presented with a whole new set of legal questions that must be answered.

Difficulty: Easy

Section Reference 1: Opening Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Comprehension

Standard 1: AACSB || Technology

84) Infotainment in cars is a new concept facilitated by social media technologies.

Difficulty: Easy

Section Reference 1: IT’s About Business 5.1

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

85) While late-model cars often utilize any number of technologies to make the driving experience more enjoyable and safer for drivers, there has yet to be a car that is completely autonomous.

Difficulty: Easy

Section Reference 1: IT’s About Business 5.1

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Comprehension

Standard 1: AACSB || Technology

86) The process of acquiring, keeping, and managing data is becoming easier.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

87) Sarbanes-Oxley requires that private companies evaluate and disclose the effectiveness of their internal financial controls.

Difficulty: Hard

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

88) Sarbanes-Oxley requires that public companies evaluate and disclose the effectiveness of their internal operational controls.

Difficulty: Hard

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

89) Sarbanes-Oxley holds CIOs personally responsible for financial disclosures since they manage the systems that hold financial information.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

90) A byte is the smallest unit of data a computer can process.

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

91) A relational database is basically one big table; it is also called a flat file.

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

92) A foreign key is a primary key in another file.

Difficulty: Hard

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Application

Standard 1: AACSB || Technology

93) A secondary key can be a foreign key.

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

94) Unstructured data can reside in a traditional relational database.

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

95) Big Data is a collection of data so large and complex that it is difficult to manage using traditional database management systems.

Difficulty: Easy

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

96) Big Data is so large and complex that it must be managed using a traditional DBMS.

Difficulty: Medium

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

97) The term “Big Data” refers simply to huge amounts of data.

Difficulty: Easy

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

98) Organizations can use Big Data to conduct experiments.

Difficulty: Easy

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

99) Organizations can use Big Data to microsegment customers.

Difficulty: Easy

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

100) Organizations can use Big Data to create new business models.

Difficulty: Easy

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

101) Computer network transmissions speeds are faster than the processing speeds of the computers themselves.

Difficulty: Easy

Section Reference 1: IT’s About Business 5.2

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

102) The collection of qualities to which NewSQL systems for online transaction processing are measured against are Autonomy, Consistency, Independence, and Durability.

Difficulty: Easy

Section Reference 1: IT’s About Business 5.2

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

103) Before Spanner, one of the major problems that Google encountered with respect to consistency among databases was that of keeping time without constant, intense communication.

Difficulty: Easy

Section Reference 1: IT’s About Business 5.2

Learning Objective 1: Define Big Data and explain its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

104) It is difficult for business analysts and data scientists who rely on EDWs to ask ad hoc questions of the data.

Difficulty: Easy

Section Reference 1: IT’s About Business 5.3

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

105) A data mart is a low-cost, scaled down version of a data warehouse.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

106) Data marts and data warehouses are typically organized by business dimension or subject.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

107) Data marts and data warehouses use OLTP.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

108) Data warehouses are information silos.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

109) Data marts and data warehouses maintain historical data.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

110) Data warehouses and data marts are updated by users.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

111) Data warehouses and data marts are multidimensional.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

112) Knowledge is distinct from data and information.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

113) Information is knowledge that is contextual, relevant, and useful.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

114) Knowledge is information in action.

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

115) Explicit knowledge deals with more objective, rational, and technical knowledge.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

116) Tacit knowledge is easily codified.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

117) Tacit knowledge is more unstructured than explicit knowledge.

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

118) KMS are useful for creating best practices in an organization.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

119) Organizations may need to reward employees to get them to add their expertise to a KMS.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

120) Once a KMS is set-up, it is updated automatically by Big Data the organization collects.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

121) Learning about and adjusting to your organization’s culture increases your explicit knowledge.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

122) The MIS department creates the business rules necessary to develop an ER diagram.

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

123) A circle for cardinality represents a single relationship.

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

124) A “chicken leg” for cardinality represents a many relationship.

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

125) The join operation combines records from two or more tables in a database to obtain information that is located in different tables.

Difficulty: Medium

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

126) GPS data can be corrupted by signal noise during transmission.

Difficulty: Easy

Section Reference 1: Closing Case

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

Question Type: Text Entry

127) ___ are those data that visitors and customers produce when they visit a website and click on hyperlinks.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

128) ___ is an approach to managing information across an entire organization.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

129) ___ is a process that spans all organizational business processes and applications.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

130) ___ are a set of core data that span the enterprise information systems.

Difficulty: Easy

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

131) A(n) ___ is a collection of logically related records.

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

132) A data file is a collection of logically related ___.

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

133) A byte is a group of ___ bits.

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

134) A ___ is a set of programs that provide users with tools to create and manage a database.

Difficulty: Easy

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

135) The three distinct characteristics of Big Data are ___.

Difficulty: Medium

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

136) A data ___ is a repository of historical data that are organized by subject to support decision makers in the organization.

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

137) A data ___ is a low-cost, scaled-down version of a data ___.

Answer 1: mart

Answer 2: warehouse

Difficulty: Medium

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

138) ___ is a process that helps organizations manipulate important knowledge that comprises part of the organization’s memory, usually in an unstructured format.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

139) ___ knowledge deals with more objective, rational, and technical knowledge.

Difficulty: Easy

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

140) ___ knowledge is generally imprecise and costly to transfer.

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

141) ___ is a method of analyzing and reducing a relational database to its most streamlined form to ensure minimum redundancy, maximum data integrity, and optimal processing performance.

Difficulty: Easy

Section Reference 1: Appendix

Learning Objective 1: Understand the processes of querying a relational database, entity-relationship modeling, and normalization and joins.

Bloomcode: Knowledge

Standard 1: AACSB || Technology

Question type: Essay

142) List and describe the nine issues that make managing data so difficult. Discuss how your university may struggle with each issue. Now evaluate how a business like Amazon may struggle with each issue.

Difficulty: Hard

Section Reference 1: 5.1

Learning Objective 1: Discuss ways that common challenges in managing data can be addressed using data governance.

Bloomcode: Evaluation

Standard 1 : AACSB || Communication

Standard 2 : AACSB || Analytic

Standard 3 : AACSB || Technology

Standard 4 : AACSB || Reflective Thinking

Solution: Amount of data increasing – more new students every year, more employees, need to keep all the data on students (transcripts) , etc.; hopefully new customers placing new orders
Data are scattered – lots of different systems (class management, payment, hospital, registration, etc.) ; Amazon has to deal with different suppliers – maybe third party inventory systems aren’t as up-to-date (so customers may get an “out of stock” message after they place an order when inventory was available at the time of the order)
Data are generated from multiple sources
o Internal – grades, paychecks, etc.; Amazon’s corporate databases or documents
o Personal – Facebook, memes, etc.; Amazon’s employees have opinions and customers can write reviews
o External – government reports (if public), university website, etc.; other websites referencing Amazon
Data degrade – employees moving, students moving (in-state vs. out-of-state), etc.; customers moving, etc.
Data rot – storing data in less than ideal places (lots of paper for most universities); same for Amazon
Data security, quality, integrity – protecting social security numbers, grades; protecting customer credit card information
Diverse systems that deal with specific business processes – most universities probably have many, many systems that need to be maintained; they may have specific systems for managing orders, inventory, and credit card numbers
Federal regulation – FERPA, HIPAA; SOX
Too much unstructured data – social media causes problems for both of these

143) Draw a simple relational database (at least two tables with at least three columns and three rows). Label the data hierarchy (except the bit). Label the primary, secondary, and foreign keys.

Difficulty: Medium

Section Reference 1: 5.2

Learning Objective 1: Discuss the advantages and disadvantages of relational databases.

Bloomcode: Comprehension, Application

Standard 1 : AACSB || Communication

Standard 2 : AACSB || Technology

Standard 3 : AACSB || Reflective Thinking

Solution:
Student Table Professor Table Class Table

Byte = any single character (e.g., “1” from Student Table)
Field = any cell
Record = any row
File = any table
Database = all three tables
Primary = SID, PID, or ID (respectively in each table)
Secondary = any column except those listed under primary
Foreign = PID in the Class Table

144) List and describe the three characteristics of Big Data. Should your university address Big Data? Why or why not? Describe at least one business (not your university if you answered “yes” to the previous questions) that has to deal with Big Data. Explain why you chose that business.

Difficulty: Medium

Section Reference 1: 5.3

Learning Objective 1: Define Big Data and its basic characteristics.

Bloomcode: Analysis

Standard 1 : AACSB || Communication

Standard 2 : AACSB || Analytic

Standard 3 : AACSB || Technology

Solution: 1) Volume – lots of data
2) Velocity – data flowing into organization rapidly increasing
3) Variety – can get structured, unstructured, or semi-structured data (most is unstructured) and changes rapidly (except for the structured)
Most students will have to say yes because everyone has to deal with social media and what students or other people say on social media
A student could pick just about any business because social media impacts everyone

145) Consider the data warehouse framework. Describe a source system and the main problem associated with these systems. What options do organizations have for storing data; which one is most effective? What is metadata? Why is data quality so important? What are the two categories of users?

Difficulty: Easy

Section Reference 1: 5.4

Learning Objective 1: Explain the elements necessary to successfully implement and maintain data warehouses.

Bloomcode: Comprehension

Standard 1 : AACSB || Communication

Standard 2 : AACSB || Technology

Solution: Source system = POS, ERP, legacy, OLTP, external web documents (any place where collect data to feed into the data warehouse); main problem = data quality
Storing = one central data warehouse, independent data marts, or hub and spoke (central warehouse that pushes to data marts); data marts are NOT effective because they create information silos and have data quality problems
Metadata = data about data
Quality = users won’t trust the data and won’t use it
Users = information producers (create information) and information consumers (use information)

146) What are the benefits and drawbacks of KMSs? Suppose you are a salesperson; would you want to use a KMS? Why or why not?

Difficulty: Medium

Section Reference 1: 5.5

Learning Objective 1: Describe the benefits and challenges of implementing knowledge management systems in organizations.

Bloomcode: Comprehension, Synthesis

Standard 1 : AACSB || Communication

Standard 2 : AACSB || Analytic

Standard 3 : AACSB || Technology

Solution: Benefits = create most effective and efficient way of doing something, improves overall organizational performance, improved customer service, more efficient product development, improved employee morale and retention
Drawbacks = people have to be willing to share personal, tacit knowledge; must keep it up to date; must be willing to invest resources (time and money to put in the system and update it)
Salesperson = students should discuss the benefits and drawbacks of sharing tacit knowledge = may be hard to codify what you know (some things may simply be instinct; other things like how to shake hands with that person or if they prefer a bow to a certain height or a kiss on a particular cheek); other things someone may not want to share because they will be afraid to get replaced by another human or a computer