omis ch5-9

Question 1

step by step process for performing a task in a finite amount of time, has a certain output

Answer 1

Algorithm

Question 2

the ability of a system to gracefully accommodate growing sizes of inputs/amounts of workload

Answer 2

Scalability

Question 3

how long it takes to perform a task

Answer 3

Running time

Question 4

T(n) = maximum time of algorithm on any input of size n

Answer 4

Worst case running time

Question 5

= O(n)

Answer 5

Linear search

Question 6

= O(logn), only if input is sorted

Answer 6

BInary search

Question 7

theoretical definition of complexity of an algorithm as a function of the size, Order of magnitude of complexity

Answer 7

Big O

Question 8

search methods with most inefficient performance

Answer 8

exponential and factorial runtime

Question 9

walk down list, comparing adjacent elements, swapping them if they are in the wrong order until list is sorted

Answer 9

Bubble sort algorithm

Question 10

internal sources, personal sources, external sources, new sources

Answer 10

sources of data

Question 11

what goes wrong with data

Answer 11

lost, stolen, deleted, hacked

Question 12

data increases exponentially, data scattered, outdated, new sources

Answer 12

difficulties managing data

Question 13

people/processes and procedures of data in order to improve data security, increase consistency and reduce fines

Answer 13

Data governance

Question 14

semi permanent data or permanent data that you want records of e.g. customer name, telephone number

Answer 14

master data

Question 15

activities or events

Answer 15

transaction data

Question 16

Database management systems minimize 3 problems

Answer 16

Data redundancy
Data isolation (security)
Data inconsistency

Question 17

Database management systems maximize 3 problems

Answer 17

Data integrity
Data security
Data independence

Question 18

unique identifier generated by system or you

Answer 18

primary key

Question 19

primary key from another table to connect btwn tables

Answer 19

foreign key

Question 20

data is stored in files but there is no connection between files

Answer 20

flat file

Question 21

model similar to a corporate organization chart, each element has a single parent record but may have multiple child records, only relationship with its parent or child records

Answer 21

Hierarchical

Question 22

similar to hierarchical model but allows many to many relationships

Answer 22

Network

Question 23

data is stored in tables, relationships between data are created via keys (most common, used in SQL)

Answer 23

Relational

Question 24

attributes in the table depend only on the primary key

Answer 24

normalization

Question 25

STRUCTURED QUERY LANGUAGE

Answer 25

SQL

Question 26

DIVERSE, HIGH-VOLUME, HIGH-VELOCITY INFORMATION ASSETS THAT REQUIRE NEW FORMS OF PROCESSING TO ENABLE ENHANCED DECISION MAKING, INSIGHT, DISCOVERY, AND PROCESS OPTIMIZATION

Answer 26

big data

Question 27

transaction process system, is information processing system for business transactions involving the collection, modification and retrieval of all transaction data

Answer 27

TPS

Question 28

enterprise resource planning, software that organizations use to manage day to day business activities e.g. accounting, procurement, risk management etc.

Answer 28

ERP

Question 29

expert system, software programmed using AI techniques, use databases of expert knowledge to offer advice or make decisions e.g. medical diagnosis, stock trading

Answer 29

ES

Question 30

decision support system, computerized program used to support determinations, judgements and courses of action in an organization/business. DSS sifts through and analyzes massive amounts of data, compiling comprehensive info that can be used to solve problems/decision making

Answer 30

DSS

Question 31

routine decisions with definite procedures e.g. restock inventory, special offers to customers

Answer 31

Structured decisions

Question 32

new, non routine decisions requiring judgement and insights e.g. approve capital budget, decide corporate objectives

Answer 32

Unstructured decisions

Question 33

only part of decision has clear cut answers provided by accepted procedures e.g. allocate resources to managers, develop a marketing plan

Answer 33

Semi-structured decisions

Question 34

financial management, operations management, human resources management and add ons - customer relationship management and supply chain management

Answer 34

Core ERP modules

Question 35

procurement process which originates in warehouse department and ends in accounting department

Answer 35

Procure to pay (P2P)

Question 36

fulfillment process, originates in sales department, ends in accounting department

Answer 36

Order to cash (OTC)

Question 37

-production process originates from warehouse department, and ends in warehouse department

Answer 37

Demand to build

Question 38

allows for joint execution, integration, data sharing, flow of information

Answer 38

ERP benefits

Question 39

companies may need to change processes - may not be optimal for every company, transition can be complex, expensive and time consuming, staff retraining and resistance may be met

Answer 39

ERP limitations

Question 40

strategy to manage and nurture customer interactions in order to garner future returning sales and word of mouth marketing

Answer 40

Customer relationship management (CRM)

Question 41

customer facing operation will help service provider reach customer face to face, customer touching operation not face to face

Answer 41

Operational CRM

Question 42

helps managers to understand how customers work and give paths for decision making related to customers e.g. cross selling, up selling

Answer 42

Analytical CRM

Question 43

when retailers make inaccurate demand projections, gap gets bigger and bigger up along the supply chain

Answer 43

bullwhip effect