Management Information Systems Test #1

Front 1

What does SCM stand for?

Back 1

supply chain management

Front 2

_________ tracks inventory and information among business processes and across companies

Back 2

Supply chain management (SCM)

Front 3

_________ is an IT system that supports supply chain management.

Back 3

Supply chain management (SCM) system

Front 4

Supply chain management is all about _________.

Back 4

costs

Front 5

method for producing or delivering a product or service just at the time the customer wants it

Back 5

Just-in-time (JIT)

Front 6

JIT is a key feature of effective _________. The key for the success of JIT is to maintain _________.

Back 6

supply chain management (SCM), quality

Front 7

SCM is a _________ strategy. It has overall _________ leadership and a _________ initiative. The goal is to squeeze out every penny of cost possible in the supply chain. This will optimize fulfillment, logistics, production, revenue and profit, and cost and price.

Back 7

business, cost, bottom-line

Front 8

_________ uses information about customers to gain insight into their needs, wants, and behaviors in order to serve them better.

Back 8

Customer relationship management (CRM)

Front 9

What does CRM stand for?

Back 9

customer relationship management

Front 10

CRM includes _________ service delivery, multiple ways in which customers can interact with a business.

Back 10

multi-channel

Front 11

CRM is a _________ strategy. It concentrates on _________ and _________. It has a _________ initiative (_________). Its focus is on growing the organization.

Back 11

business, differentiation, focus, top-line, revenue

Front 12

CRM has a _________-line initiative.

Back 12

top (revenue)

Front 13

SCM hasa _________-line initiative.

Back 13

bottom (cost)

Front 14

_________ is the use of technology to support:
(1) work activities with integrated collaboration environments
(2) knowledge management with knowledge management systems
(3) social networking with social networking systems
(4) learning with e-learning tools
(5) informal collaboration to support open-source information

Back 14

e-collaboration

Front 15

environment in which virtual teams do their work

Back 15

integrated collaboration environment (ICE)

Front 16

What does ICE stand for?

Back 16

integrated collaboration environment

Front 17

A team whose members are located in varied geographical locations is known as a _________ team.

Back 17

virtual

Front 18

An integrated collaboration environment (ICE) can be as basic as e-mail or more sophisticated as in:
*_________ system- automation and management of business processes (processing a loan in a bank, processing a sales order, etc.)
* _________ system - manages a document through all stages of processing

Back 18

Workflow, Document management

Front 19

automation and management of business processes (processing a loan in a bank, processing a sales order, etc.); type of an ICE

Back 19

workflow system

Front 20

manages a document through all stages of processing, type of an ICE

Back 20

document management system

Front 21

system that supports the capturing, organizing, and dissemination of knowledge through the organization (knowledge of facts, sources of information; solutions, patents, and trademarks; best-practice processes)

Back 21

Knowledge Management (KM) System

Front 22

What does KM stand for?

Back 22

knowledge management?

Front 23

collection of integrated software for business management, accounting, finance, supply chain management, inventory management, customer relationship management, e-collaboration, etc.

Back 23

Enterprise resource planning (ERP) system

Front 24

What does ERP stand for?

Back 24

enterprise resource planning

Front 25

How do you bring together SCM, CRM, and e-collaboration systems?

Back 25

With an enterprise resource planning (ERP) system

Front 26

gathering and processing information and updating existing information to reflect the processed information

Back 26

online transaction processing (OLTP)

Front 27

What does OLTP stand for?

Back 27

online transaction processing

Front 28

manipulation of information to support decision making

Back 28

online analytical processing (OLAP)

Front 29

What does OLAP stand for?

Back 29

online analytical processing

Front 30

OLTP:
- supports _________ processing
- sales orders, accounts receivable, etc. (operational reports)
- supported by _________ databases & DBMSs

Back 30

operational (x2)

Front 31

[OLTP/OLAP] supports operational processing. It is supported by operational databases and DBMSs. Examples include sales orders, accounts receivable, etc.

Back 31

OLTP

Front 32

OLAP:
- helps build business _________
- supported by data _________ and data-mining tools

Back 32

intelligence, warehouses

Front 33

[OLTP/OLAP] helps build business intelligence. It is supported by data warehouses and data-mining tools.

Back 33

OLAP

Front 34

OLTP addresses _________ questions.

Back 34

simple

Front 35

OLAP addresses _________ questions.

Back 35

complicated

Front 36

collection of information that you organize and access according to the logical structure of the information

Back 36

database

Front 37

series of logically related two-dimensional tables or files for storing information

Back 37

relational database

Front 38

Relation = _________ = _________

Back 38

table, file

Front 39

_________ is the most popular database model.

Back 39

Relational database

Front 40

Database characteristics:
- collections of _________
- created with _________ structures
- include _________ ties within the information
- include built-in integrity _________

Back 40

information, logical, logical, constraints

Front 41

Databases are created with _________ structures and include _________ ties within the information. They are about _________, know what they mean.

Back 41

logal, logical, connections

Front 42

A _________ contains the logical structure for the information in a database.

Back 42

data dictionary

Front 43

field (or group of fields) that uniquely describes each record

Back 43

primary key

Front 44

primary key of one file that appears in another file

Back 44

foreign key

Front 45

Databases have built-in _________ constraints.

Back 45

integrity

Front 46

rules that help ensure the quality of information

Back 46

integrity constraints

Front 47

A _________ defines type of information - numeric, date, and so on.

Back 47

data dictionary

Front 48

_________ keys must be found as primary keys in another file.

Back 48

Foreign

Front 49

Two built-in integrity constraints include:
1)
2)

Back 49

data dictionary, foreign keys

Front 50

A _________ helps you specify the logical requirements for a database and access and use the information in a database.

Back 50

database management system (DBMS)

Front 51

What does DBMS stand for?

Back 51

database management system

Front 52

5 components of a DBMS:
1) DBMS _________
2) Data _________ subsystem
3) Data _________ subsystem
4) _________ generation subsystem
5) Data _________ subsystem

Back 52

engine, definition, manipulation, Application, administration

Front 53

What is the most critical component of any DBMS?

Back 53

DBMS engine

Front 54

A _________ accepts logical requests from other DBMS subsystems, converts them into the physical equivalents, and access the database and data dictionary on a storage device.

Back 54

DBMS engine

Front 55

_________ view - how information is physically arranged, stored, and accessed on a storage device

Back 55

physical

Front 56

_________ view - how you need to arrange and access information to meet your needs

Back 56

logical

Front 57

A _________ helps you add, change, and delete information in a database and query it to find valuable information

Back 57

data manipulation subsystem

Front 58

A data manipulation subsystem is most often your _________ interface.

Back 58

primary

Front 59

A _________ helps you manage the overall database environment by providing facilities for...
- backup and recovery
- security management
- query optimization
- reorganization
- concurrency control
- change management

Back 59

data administration subsystem

Front 60

_________ is for backing p information and restarting (recovering) from a failure

Back 60

Backup and recovery

Front 61

_________ is for CRUD (create, read, update, and delete) access

Back 61

Security management

Front 62

What does CRUD stand for?

Back 62

create, read, update, and delete

Front 63

The purpose of _________ is to minimize response times for large, complex queries.

Back 63

query optimization

Front 64

_________ is for physically rearranging the structure of the information according to how you most often access it

Back 64

Reorganization

Front 65

_________ is what happens if two people attempt to make changes to the same record.

Back 65

Concurrency control

Front 66

_________ looks at how structural changes will impact the overall database.

Back 66

Change management

Front 67

collection of information (from many places) that supports business analysis activities and decision making

Back 67

data warehouse

Front 68

Data _________ and data _________ help you build and work with business intelligence and some forms of knowledge.

Back 68

warehouses, mining

Front 69

Data Warehouse characteristics:
*_________ - rows, columns, and layers
*Support _________ not _________
- Contain summaries of information not every detail

Back 69

Multidimensional, decision making, transaction processing

Front 70

software tools you use to query information in a data warehouse

Back 70

data-mining tools

Front 71

subset of a data warehouse in which only a focused portion of the data warehouse information is kept

Back 71

data mart

Front 72

Access - To get to design view select the _________ Tab and select _________.

Back 72

Create, Table Design

Front 73

Access - Under _________ insert the field data provided.

Back 73

field name

Front 74

Access - Under _________ specify the correct formatting for each field.

Back 74

data type

Front 75

Access - Under _________ explain how this field will be used.

Back 75

description

Front 76

Access - The _________ specifies the amount of characters that can be used.

Back 76

field size

Front 77

Access - a field or set of fields that uniquely identify each record stored in a table

Back 77

primary key

Front 78

Access - a field in one table that is indexed in another

Back 78

foreign key

Front 79

To select a primary key, go to the _________ tab and click the _________ button.

Back 79

design, primary key

Front 80

Accept - When creating relationships, make sure to select the enforce _________ check box.

Back 80

referential integrity

Front 81

Access - Ask questions about your query
* _________ information do I need to answer this query?
* _________ can I find these information? What tables(s) do I need to find this information
* Are there any _________ for the information I need?
* Can I find the _________ information in the table I found in question two?
- If yes, move on to design in Access.
- If no, where can I find this information

Back 81

what, where, criteria, criteria

Front 82

Access - In the relationship diagram, there is a 1 coming from the _________ key to connect to the _________ key where there's an infinity sign.

Back 82

primary, foreign