mis midterm Flashcards
1
Q
a list of components required to create a product is called a?
A
bill of materials
2
Q
some cloud computing vendors off ERP systems over the web. such systems are almost certainly ___ processing systems.
A
online transaction
3
Q
computerized information systems are composed of what components?
A
hardware, software, personnel, procedures, data
4
Q
what are the characteristics of continuous improvement?
A
- routine action to address minor problems
- limited to immediate organizational environment
- driven by workforce, possibly without senior management knowledge
5
Q
true or false: in a relational database, every table must have a primary key.
A
true
6
Q
a field (or set of fields) in a database table that uniquely identifies each record is?
A
primary key
7
Q
simple graphical symbols used to show the organization of and relationships between data tables.
A
entity relationship diagram
8
Q
true or false: an mis involves less analytical complexity than a tps.
A
false
9
Q
ERP software vendors provide online “hosted” versions of their software for small and medium sized businesses to use. What are characteristics of hosted ERP software?
A
everything but riskier implementation
- faster to implement and start using Correct
- vulnerable to Internet disruptions Correct
- pay-as-you-go approach is less expensive Correct
- potential problems with software vendor Correct
- requires less in-house technical expertise Correct
- security risk with corporate data
10
Q
What are Porter’s Five Forces?
A
- Threat of New Entrants
- Threat of Substitute Products/Services
- Supplier Power
- Rivalry among Existing Competitors
- Buyer Power
11
Q
true or false: An ERP system can be used to capture data for accounting software.
A
true
12
Q
Match the characteristics of valuable information with the appropriate description.
- Information is error free.
- Information is available when needed.
- Information must be of greater value than the cost to obtain it.
- Information is appropriate for the decisions to be made.
- Information cannot be accessed by unauthorized users.
A
- accurate
- timely
- economical
- relevant
- secure
13
Q
true or false: Investigation after the Columbia shuttle disaster found the accident might have been avoided if NASA managers had understood basic technical concepts behind spaceflight and physics when making decisions.
A
true
14
Q
Place the three major stages of business use of information systems in the order.
A
- cost reduction and productivity
- competitive advantage
- performance based management
15
Q
Type of management report produced when an unusual or “out of acceptable bounds” situation occurs which requires management attention.
A
exception report
16
Q
An organizational structure based on major products, services, or initiatives.
A
project organizational structure
17
Q
A system that manages information for designing, engineering, and producing new products.
A
PLM
18
Q
Which statement(s) are generally true for associative entities?
A
- associative entities typically require more than one attribute for a primary key
- associative entities must have foreign keys
19
Q
Strategic decisions require information characterized by:
A
u,i,i,i,l
- unstructured information
- information from external data sources
- information at a summarized level
- infrequent updates
- long-term time horizon
20
Q
A managerial report that is created once for a special situation is classified as _______.
A
an ad hoc report
21
Q
Major underlying beliefs, values, operational philosophy, and assumptions found in an organization.
A
organizational culture
22
Q
A collection of facts organized and processed in such a manner they have additional value beyond that of the individual facts.
A
information
23
Q
true or false: Currently, the most commonly-used database paradigm is the network paradigm.
A
false
24
Q
Calculated by subtracting the cost of a new system from the revenue increase attributable to use of the new system.
A
value added
25
true or false: In a project organizational environment, each project unit typically has its own traditional functions (like marketing, sales, production, etc.), embedded in the project group.
true
26
A/n _______ model that finds an acceptable solution, but not one that is necessarily the best solution.
satisficing
27
Put the phases of the Gartner Hype Cycle in chronological order.
- technology trigger
- peak of inflated expectations
- trough of disillusionment
- slope of enlightenment
- plateau of productivity
28
What are the stages of problem-solving?
all are checked
- implementation
- intelligence
- choice
- design
- monitoring
29
In which stage of transaction processing cycle are POS, UPC, and RFID technologies most likely to be used?
data collection
30
In which stage of transaction processing cycle are POS, UPC, and RFID technologies most likely to be used?
data collection
31
true or false: Every table in a relational database must have a foreign key.
false
32
A group of fields in a database about an individual person, place, or thing.
record
33
The ________ database paradigm was developed by E.F. Codd at IBM during the 1970s.
relational
34
A formal process for cleaning-up data in a relational database.
normalize
35
true or false: Knowledge of computer hardware, software, and networking is referred to as "systems design."
false
36
A logical and physical description of an entire database along with relationships and user access rules.
schema
37
true or false: CRM is usually easy to implement since it simply a clerical tool to automate existing customer relationship practices.
false
38
A decision support system developed to assist with a recurring type of decision is referred to as a/n ________ DSS.
institutional
39
true or false: Salespeople from tech industry vendors tend to be techies with no understanding of your industry or the problems you face.
false
40
Computer system capable of relating data to maps.
GIS
41
Primary activities in a value chain includes which of the following?
- warehousing
- inbound logistics
- productive
42
A management specified objective of a system characterizing some aspect of its operation. (For example, a defect rate in a manufacturing process, an out-of-stock rate in inventory management, or the turnover rate in personnel.)
system performance standard
43
You learn that your small business will be adopting an online hosted ERP system. Which of the following should concern your company?
- problems caused by internet disruption.
- security of confidential corporate data
- loss of control to ERP software vendor
44
true or false: An MIS involves greater analytical complexity than a TPS.
true
45
A specific value for an attribute.
data item
46
true or false: Currently, the most commonly-used database paradigm is the file system paradigm.
false
47
true or false: Associative entities are created in database modeling in order to resolve many-to-many relationships between other entities.
true
48
A management report that allows a manager to access summary data at a desired level of detail. Must be screen-based (not a printed report).
drill-down report
49
Limiting visibility of records in a data table according to specific criteria.
select
50
A form of data processing in which transactions are processed immediately without delay.
OLTP
51
Awareness and understanding of information and how that information can be useful for specific purposes.
knowledge
52
true or false: A supply chain management system helps acquire and stage production materials but does not address production scheduling.
false
53
true or false: Every table in a relational database must have a foreign key.
false
54
What are the stages of decision-making?
- intelligence
- choice
- design
55
The ________ database paradigm is efficient when data is sorted and accessed by a single attribute – much like a file cabinet with hanging files and folders.
hierarchical
56
Commonly accepted guidelines or procedures for finding a good solution are called _______.
heuristics
57
true or false: Virtual organizations generally work best when their core business activities are conducted at a central physical facility (e.g., are not "virtual").
true
58
Decision-making and authority flow downward from strategic management to operational management and non-management personnel in a hierarchical structure.
traditional organizational structure
59
Match the characteristics of valuable information with the appropriate description.
- information is error free.
- information is at an appropriate level of detail for decision-makers.
- information can be easily obtained in the right format and at the right time by authorized personnel.
- information is available when needed.
- information has multiple users.
- information is appropriate for the decisions to be made.
- accurate
- simple
- accessible
- timely
- flexible
- relevant
60
whats true about primary keys?
- every entity must have a primary key
| - a primary key must be unique.
61
Which of the following are disadvantages or problems in implementing ERP systems?
all but replacement and improved
- may force disrupted changes to established procedures.
- complex implementation
- expensive customization of software
- high failure rate of ERP projects
62
true or false: Knowledge of how data and information are used by individuals and organizations is referred to as "information systems literacy."
true
63
How integral or essential the use of technology is within an organization.
technology infusion
64
A decision support system developed to assist with a unique or infrequent type of decision is referred to as a/n ________ DSS.
ad hoc
65
What are characteristics of BPR?
cots
- cuts across organizational boundaries
- significant action taken to address serious problems
- often led by consultants
- top-down change driven by upper management
66
A diagram showing the organization of all an organization's data is called a/an _____________.
enterprise data model
67
Which company highlighted in the course's digital videos uses a technique known as Internet behavioral pricing?
orbitz
68
true or false: a tps does not provide much support for decision making.
true
69
enterprise software used for day to day operation of an organization typically features the following types of reports:
detail reports
summary reports
exception reports
70
which of the following business rules are defined by the above entity relationship diagram? small at to bigger b
1. each a is related to one or many b's
| 2. each b is related to zero or one a
71
the stages of lewing and schein three phase change
unfreeze-move-refreeze
72
a detailed description of all data items used in a database, including tables, field names, and data type for each field.
data dictionary
73
a decision addressing unusual or exceptional situations
nonprogrammed
74
which of the following systems, techniques, and concepts involve the management of inventory?
jerm
rop
jit
eoq
mrp
75
an organizational structure based on work groups. these groups may be large or small and may be long-term or temporary.
team organizational structure
76
you hear a technical staff member in company referred to as a "paper cert." this means?
he/she has a vendor certification, but has difficulty actually solving real world technical problems
77
limit visibility of columns in a data table
project
78
true or false: to maintain security, erp and accounting systems should never directly share data
false
79
the simple erd shows just the entities and keys. which of the following is true? course, enrollment, student
1. the enrollment modality for the course-enrollment relationship is "one"
2. the course modality for the course-enrollment relationship is "one"
80
match the definition of the transacting processing stage with the appropriate term:
1. capturing and gathering the necessary data to complete processing transactions
2. checking data for validity and completeness
3. updating databases with new transaction data.
4. performing calculation and other data transformations using transaction data.
5. generating printouts and reports using transaction data
6. re-entering data that was improperly typed or scanned
1. data collection
2. data editing
3. data storage
4. data manipulation
5. document production
6. data correction
81
type of management report produced on an as-needed basis
demand report
82
cloud computing is most likely in the _____ phase of the gartner hype cycle
peak of inflated expectations
83
model that determines factors that can lead to better attitudes toward use of technology
technology acceptance
84
knowledge of computer systems and equipment is referred to as?
computer literacy
85
a _______ model finds the best possible solution to a problem, often using quantitative techniques
optimization
86
true or false: crm typically requires training since crm often represents a new approach to interacting with customer
true
87
calculated by dividing a measure of output by a measure of input
efficiency
88
raw facts
data
89
longer term management of an organization (not management of day to day operations) typically features the following types of reports:
demand reports
ad hoc reports
scheduled reports
90
true or false: an organization can achieve a flatter organizational structure by empowering employees with more control over their jobs
true
91
a system of integrated computer programs that manage key business operations for an entire company, even across multiple sites
erp
92
a general class of persons, places, or things for which data is collected and stored in a database
entity
93
knowledge of how data and information are used by individuals and groups is referred to as ?
information systems literacy
94
the following simple erd shows just the entities and keys. where could you put the student grade?
enrollment entity
95
the sum of all costs of an information systems over the full lifetime of that system. this includes costs of hardware and software acquisition, support costs, administrative costs, and the costs of end-user training and operations.
tco
96
the _____ database paradigm requires extensive programming when data structure or data content changes.
file system
97
operational decisions require information characterized by?
1. short-term time horizon
2. internally generated information
3. highly structured data
4. detailed information
5. frequent updates
