Chapter 5

Question 1

data governance

Answer 1

managing information across an entire organization

Question 2

master data management

Answer 2

process that spans all of the business processes and applications.

Question 3

master data

Answer 3

set of core data, such as customer, product, employee, vendor, geographic location. Spans all of the enterprises information system.

Question 4

databases

Answer 4

provides all users with access to the data.

Question 5

What does database sytems minimize?

Answer 5

data redundancy, data isolation, data inconsistency.

Question 6

what do database systems maximize?

Answer 6

data security, data integrity, data interdependence.

Question 7

bit (binary digit)

Answer 7

smallest unit of data a computer can process. 0’s or 1’s.

Question 8

data hierarchy

Answer 8

database-file-record-field-byte-bit

Question 9

byte

Answer 9

represents single characters

Question 10

data model

Answer 10

diagram respresenting entities in the database and their relations.

Question 11

instance

Answer 11

specific or unique representation of an entity

Question 12

attribute

Answer 12

characterstic of quality of an entity.

Question 13

primary key

Answer 13

unique identifier

Question 14

secondary keys

Answer 14

other fields not representing the file with complete accuracy.

Question 15

entity relationship modeling

Answer 15

ER diagram. association between two entitites. Diagrams entities, attributes, and relationships.

Question 16

cardinalilty

Answer 16

in entity relationship model. refers to maximum number of instances for entity. 1 or many.

Question 17

modality

Answer 17

in entity relationship mod. refers to minimum number of instances for entity. 0 or 1

Question 18

identifiers

Answer 18

primary key

Question 19

relational database model

Answer 19

two dimensional tables- big files=flat files

Question 20

structured query language

Answer 20

most popular language. used to perform searches with simple statements or keywords. May include key words like SELECT, FROM, WHERE…

Question 21

query by example

Answer 21

user fills out grid or template to construct a sample. Drag and drop.

Question 22

data dictionary

Answer 22

defines the appropriate format for entering the data into the database. Provides information on each attribute.

Question 23

Normalization

Answer 23

reduces relational databases for minimum redundancy, maximum data integrity, and optimal processing performance. Depend only on the primary key.

Question 24

Data warehouse

Answer 24

repository of historical data organized by subject to support decision makers in the organization. Expensive and usually used by larger companies.

Question 25

Data mart

Answer 25

lower cost. Designed for end-user needs in a small organization or strategic business unit (SBU) or a department in a large organization.

Question 26

Characteristics of Data Warehouses and Marts

Answer 26

* organized by business dimension or subject * uses online analytical processing * integrated- customer data can be integrated from internal and external systems and create a comprehensive view of the customer. * Time variant- stores years of data * Nonvolatile- only IT professionals can change or update the data. * Multidimensional- multidimensional structures, unlike tables which are only two dimensional.

Question 27

multidimensional structure

Answer 27

more than two dimensions, data cube.

Question 28

knowledge management

Answer 28

process that helps organizations manipulate important knowledge that is part of the organizations memory, usually in an unstructured format.

Question 29

explicit knowledge

Answer 29

objective, rational, technical knowledge. Policies, procedural guides. Codified knowledge that can be distributed to others or transformed into a process or strategy

Question 30

tacit knowledge

Answer 30

subjective or experiental learning. Trade secrets, skill sets.

Question 31

intellectual assets, intellectual capital

Answer 31

other terms for knowledge.

Question 32

knowledge management systems

Answer 32

the use of modern information technologies

Question 33

best practices

Answer 33

most effective and effecient way of doing things

Question 34

Describe the six steps in knowledge management system cycle.

Answer 34

1. Create knowledge 2. Capture knowledge 3. Refine knowledge 4. Store knowledge 5. Manage knowledge 6. Disseminate knowledge- made avaialabe to other parts of the organization