IS 201 MIDTERM 2 | QUESTIONS AND ANSWERS | 2026
UPDATE | WITH PASSED SOLUTION
Information granularity Answer - "The scale or level of detail present in a set of
data or other phenomenon."
Transactional information Answer - "Real-time business processes."
Analytical information Answer - "Inferences relevant to the organization."
Real-time information/systems Answer - Transactional information refers to the
data that is generated by real-time business processes. "Real-time" means that
the data is recorded temporally as the transaction occurs.The transactional
data generated by an ATM withdrawal would include the date and time,
amount, customer, account, and location.
Measures of information quality
Accuracy
Completeness
Consistency
Uniqueness
Timeliness Answer - accuracy-"Whether or not the information gathered is
correct."
, completeness-"Whether or not there is anything missing from the information
provided."
consistency-"Whether or not accounts that should have the same information
do have the same information."
uniqueness-"Whether or not the information provided is a duplicate of
customer information."
timeliness-"Whether or not the data is recent or old."
"Satisficing" Answer - "The idea that it is not always optimal to make a
"perfectly informed" decision because there is a cost of obtaining perfect
information. Established by management theorist Herbert Simon (1956)"
Relational database Answer - "solve the problem of data redundancy"
DBMS Answer - "The software system used to store data electronically and
provide advanced features for ensuring and maintaining data quality as well as
managing the security and availability of the data."
Normalization Answer - separating data into a set of related tables
Business-critical integrity constraint Answer - rules that enforce basic and
fundamental informaiton-based constraints
You are the manager of the newest Provo startup, Keith Co., a new trendy
grocery store for college students. You have just completed your first year of
sales, and you have a large amount of data to analyze about its efficiency and
profitability. Your assistant manager has run an in-depth analysis of the data
and has a few questions, recommendations, and issues that he needs you to
address.
UPDATE | WITH PASSED SOLUTION
Information granularity Answer - "The scale or level of detail present in a set of
data or other phenomenon."
Transactional information Answer - "Real-time business processes."
Analytical information Answer - "Inferences relevant to the organization."
Real-time information/systems Answer - Transactional information refers to the
data that is generated by real-time business processes. "Real-time" means that
the data is recorded temporally as the transaction occurs.The transactional
data generated by an ATM withdrawal would include the date and time,
amount, customer, account, and location.
Measures of information quality
Accuracy
Completeness
Consistency
Uniqueness
Timeliness Answer - accuracy-"Whether or not the information gathered is
correct."
, completeness-"Whether or not there is anything missing from the information
provided."
consistency-"Whether or not accounts that should have the same information
do have the same information."
uniqueness-"Whether or not the information provided is a duplicate of
customer information."
timeliness-"Whether or not the data is recent or old."
"Satisficing" Answer - "The idea that it is not always optimal to make a
"perfectly informed" decision because there is a cost of obtaining perfect
information. Established by management theorist Herbert Simon (1956)"
Relational database Answer - "solve the problem of data redundancy"
DBMS Answer - "The software system used to store data electronically and
provide advanced features for ensuring and maintaining data quality as well as
managing the security and availability of the data."
Normalization Answer - separating data into a set of related tables
Business-critical integrity constraint Answer - rules that enforce basic and
fundamental informaiton-based constraints
You are the manager of the newest Provo startup, Keith Co., a new trendy
grocery store for college students. You have just completed your first year of
sales, and you have a large amount of data to analyze about its efficiency and
profitability. Your assistant manager has run an in-depth analysis of the data
and has a few questions, recommendations, and issues that he needs you to
address.
