IS 201 MIDTERM 2 EXAM 1 QUESTIONS AND ANSWERS
Information granularity - CORRECT ANSWER✅✅"The scale or level of detail present in a set of data or
other phenomenon."
Transactional information - CORRECT ANSWER✅✅"Real-time business processes."
Analytical information - CORRECT ANSWER✅✅"Inferences relevant to the organization."
Real-time information/systems - CORRECT 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 - CORRECT 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" - CORRECT 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 - CORRECT ANSWER✅✅"solve the problem of data redundancy"
, DBMS - CORRECT 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 - CORRECT ANSWER✅✅separating data into a set of related tables
Business-critical integrity constraint - CORRECT 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.
The sales records indicate that ramen noodles sell extremely well with college students. So well, in fact,
that you have trouble keeping it in stock and on the shelves. What aspect of information quality could
keep ramen on the shelves? - CORRECT ANSWER✅✅Timeliness
A lot of customers have entered their personal information into your customer loyalty database, but
some of them keep entering their information more than once. This causes issues with the ___________
of the data. - CORRECT ANSWER✅✅Uniqueness
What level of information granularity would be most analytical in nature and could best support
decision making for a CEO? - CORRECT ANSWER✅✅Aggregate
You have been hired as a new database administrator for your company's order processing system. Your
new manager has noticed that there are a few (1 or 2 per 1000) minor inconsistencies in the data. Your
company estimates that it will cost you $50,000 to find and fix the problem. Your database deals with
around 500 individual transaction records every day, and each transaction averages about 5 dollars. You
want to make sure that you follow the satisficing principles you learned in IS201. What should you do? -
CORRECT ANSWER✅✅Leave the problem, the data we have is good enough.
Information granularity - CORRECT ANSWER✅✅"The scale or level of detail present in a set of data or
other phenomenon."
Transactional information - CORRECT ANSWER✅✅"Real-time business processes."
Analytical information - CORRECT ANSWER✅✅"Inferences relevant to the organization."
Real-time information/systems - CORRECT 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 - CORRECT 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" - CORRECT 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 - CORRECT ANSWER✅✅"solve the problem of data redundancy"
, DBMS - CORRECT 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 - CORRECT ANSWER✅✅separating data into a set of related tables
Business-critical integrity constraint - CORRECT 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.
The sales records indicate that ramen noodles sell extremely well with college students. So well, in fact,
that you have trouble keeping it in stock and on the shelves. What aspect of information quality could
keep ramen on the shelves? - CORRECT ANSWER✅✅Timeliness
A lot of customers have entered their personal information into your customer loyalty database, but
some of them keep entering their information more than once. This causes issues with the ___________
of the data. - CORRECT ANSWER✅✅Uniqueness
What level of information granularity would be most analytical in nature and could best support
decision making for a CEO? - CORRECT ANSWER✅✅Aggregate
You have been hired as a new database administrator for your company's order processing system. Your
new manager has noticed that there are a few (1 or 2 per 1000) minor inconsistencies in the data. Your
company estimates that it will cost you $50,000 to find and fix the problem. Your database deals with
around 500 individual transaction records every day, and each transaction averages about 5 dollars. You
want to make sure that you follow the satisficing principles you learned in IS201. What should you do? -
CORRECT ANSWER✅✅Leave the problem, the data we have is good enough.
