MIS EXAM 3 QUESTIONS WITH 100%
CORRECT ANSWERS18
Affordances - ANSWERS -Are physical properties of an object that show functionality
Their appearance shows the use how to use the object without the need for labels, instructions,
ect
Users know what to do instinctively
Dont need explanation
Time - ANSWERS -How long will it take?
What is the business value of a database? - ANSWERS --Organize
-Analysis and decision making
-Communicate and collaborate
What information-related issues does a database solve? - ANSWERS --Data Redundancy
-Data Isolation
-Data Inconsistency
Entity relationship Diagram - ANSWERS -Model of data and relationship
What does an ER diagram tell us? - ANSWERS --Actors in the design (Entities)
,-Relationship among actors (Links)
-Organizational structure
Entity - ANSWERS -A specific person, place or thing
Entity Class - ANSWERS -An abstract representation of ALL atrributes of a particuar type of
entity
Primary Key - ANSWERS -attributes that uniquely identifies a record
Unqiue like number ID
Foreign Key - ANSWERS -Shared file that allows relational tables to link to one another and
minimize data redundancy.
DOES NOT HAVE TO BE UNQIUE
BI - ANSWERS -
Data mart - ANSWERS -Smaller version of data warehouse
KPI - ANSWERS -Key Performance Indicator
Drill Down - ANSWERS -Accessing the supporting detailed data
CSF - ANSWERS -Critical Success Factor
, Issue central to success of the task
Exception Reporting - ANSWERS -Identifies metrics outside of tolorance
Types of Business Management Decisions - ANSWERS -Strategic Planning: Capability- Senior
management
Management Control: Execution- Middle Management
Operational Control: Process- Operational management
The Three Phase Decision Making Process - ANSWERS -Intelligence Phase (Scoping)
Design Phase (Algorithm)
Choice Phase (Execution)
A Structured problem - ANSWERS -An optimal solution that can be reached through a single set
of steps
Parameters - ANSWERS -Categories of data considered in algorithm
Unstructured Problem - ANSWERS -Exists when algorithm doesn't exist, the options are very
complex or the calculation requires an impractical amount of time.
Data Mart - ANSWERS -
OLAP - ANSWERS -Online Analytical Processing
Set of functions which use multi-dimensional data analysis
CORRECT ANSWERS18
Affordances - ANSWERS -Are physical properties of an object that show functionality
Their appearance shows the use how to use the object without the need for labels, instructions,
ect
Users know what to do instinctively
Dont need explanation
Time - ANSWERS -How long will it take?
What is the business value of a database? - ANSWERS --Organize
-Analysis and decision making
-Communicate and collaborate
What information-related issues does a database solve? - ANSWERS --Data Redundancy
-Data Isolation
-Data Inconsistency
Entity relationship Diagram - ANSWERS -Model of data and relationship
What does an ER diagram tell us? - ANSWERS --Actors in the design (Entities)
,-Relationship among actors (Links)
-Organizational structure
Entity - ANSWERS -A specific person, place or thing
Entity Class - ANSWERS -An abstract representation of ALL atrributes of a particuar type of
entity
Primary Key - ANSWERS -attributes that uniquely identifies a record
Unqiue like number ID
Foreign Key - ANSWERS -Shared file that allows relational tables to link to one another and
minimize data redundancy.
DOES NOT HAVE TO BE UNQIUE
BI - ANSWERS -
Data mart - ANSWERS -Smaller version of data warehouse
KPI - ANSWERS -Key Performance Indicator
Drill Down - ANSWERS -Accessing the supporting detailed data
CSF - ANSWERS -Critical Success Factor
, Issue central to success of the task
Exception Reporting - ANSWERS -Identifies metrics outside of tolorance
Types of Business Management Decisions - ANSWERS -Strategic Planning: Capability- Senior
management
Management Control: Execution- Middle Management
Operational Control: Process- Operational management
The Three Phase Decision Making Process - ANSWERS -Intelligence Phase (Scoping)
Design Phase (Algorithm)
Choice Phase (Execution)
A Structured problem - ANSWERS -An optimal solution that can be reached through a single set
of steps
Parameters - ANSWERS -Categories of data considered in algorithm
Unstructured Problem - ANSWERS -Exists when algorithm doesn't exist, the options are very
complex or the calculation requires an impractical amount of time.
Data Mart - ANSWERS -
OLAP - ANSWERS -Online Analytical Processing
Set of functions which use multi-dimensional data analysis
