The Ultimate and Complete BIS 245 (BIS245) Study Guide 2025–2026, Covering
Database Design and Management Fundamentals, Relational Database
Concepts and Data Modeling, Entity Relationship Diagrams (ERDs) and
Normalization Techniques, Structured Query Language (SQL) Programming
and Queries, Database Tables Relationships and Constraints, Data Integrity
and Database Security Principles, Business Information Systems Applications
and Data Management Strategies, Database Development Life Cycle and
Implementation Processes, Reporting and Data Analysis Techniques, Business
Intelligence Foundations and Decision Support Systems, Practice Questions
with Verified Answers and Detailed Explanations, Real Database Case Studies,
Step-by-Step SQL and Database Design Frameworks, and Proven Strategies to
Successfully Master BIS 245 and Excel in Database Management and Business
Information Systems
<b>Question 1: In the context of modern business environments, an information system is
fundamentally defined as a set of interrelated components that collect, process, store, and
distribute information to support decision-making and control in an organization. Which of the
following best describes the primary role of people within this system?</b> A. People are
merely end-users who passively consume the reports generated by the hardware components.
B. People are the most important component because they are responsible for designing,
maintaining, and utilizing the system to achieve business objectives. C. People act primarily as
data entry operators whose sole function is to input raw data into the software applications. D.
People serve as the physical infrastructure that connects the various software and hardware
components together. <b>CORRECT ANSWER: B. People are the most important component
because they are responsible for designing, maintaining, and utilizing the system to achieve
business objectives.</b> Rationale: In any information system, people (or users) are considered
the most critical element because technology alone cannot solve business problems; it requires
human intervention to design, manage, and leverage the system for strategic advantage.
<b>Question 2: When analyzing the five-component framework of information systems, which
consists of hardware, software, data, procedures, and people, how do the first three
components differ from the latter two in terms of their primary function and nature?</b> A.
Hardware, software, and data are considered the actors because they perform the actions,
while procedures and people are the stage where the actions occur. B. Hardware, software, and
data are technology components that process and store information, whereas procedures and
people are human-oriented components that direct and utilize the technology. C. Hardware,
software, and data are dynamic components that change frequently, while procedures and
people are static components that remain constant over time. D. Hardware, software, and data
are only used in automated systems, while procedures and people are exclusively used in
,manual information processing systems. <b>CORRECT ANSWER: B. Hardware, software, and
data are technology components that process and store information, whereas procedures and
people are human-oriented components that direct and utilize the technology.</b> Rationale:
The five-component framework separates the technology aspects (hardware, software, data)
from the human aspects (procedures, people). The technology processes and stores data, while
humans create the procedures and interact with the technology to achieve business goals.
<b>Question 3: A large retail corporation is implementing a new point-of-sale system to track
inventory in real-time. The IT department has purchased the necessary servers and software,
but the store employees are resisting the change because they were not trained on the new
procedures. According to the sociotechnical systems theory, what is the most likely outcome of
this implementation?</b> A. The system will succeed because the technical components
(hardware and software) are perfectly aligned with the business requirements. B. The system
will fail or underperform because the social system (people and procedures) was ignored,
leading to resistance and improper usage of the technology. C. The system will automatically
adapt to the employees' habits without any need for formal training or procedural updates. D.
The technical components will compensate for the lack of training by automatically generating
error reports for management to review. <b>CORRECT ANSWER: B. The system will fail or
underperform because the social system (people and procedures) was ignored, leading to
resistance and improper usage of the technology.</b> Rationale: Sociotechnical theory
emphasizes that organizational performance is maximized when the social system (people,
culture, procedures) and the technical system (hardware, software) are jointly optimized.
Ignoring the human element often leads to system failure.
<b>Question 4: In the hierarchy of organizational information systems, which type of system is
specifically designed to support non-routine decision-making for senior management by
providing generalized computing and communication capabilities rather than specific
operational data?</b> A. Transaction Processing Systems (TPS) B. Management Information
Systems (MIS) C. Decision Support Systems (DSS) D. Executive Support Systems (ESS)
<b>CORRECT ANSWER: D. Executive Support Systems (ESS)</b> Rationale: Executive Support
Systems (ESS) are designed for senior management to address non-routine, strategic decisions.
They provide a generalized computing and communication environment, often utilizing internal
data from MIS/DSS and external data (like market trends) via advanced dashboards.
<b>Question 5: A manufacturing company uses an automated system on its assembly line that
monitors temperature and pressure sensors. If the pressure exceeds a certain threshold, the
system automatically shuts down the machine to prevent an explosion. This is an example of
which level of decision-making?</b> A. Strategic decision-making, because it involves long-term
planning and external market factors. B. Management control decision-making, because it
requires middle managers to allocate resources efficiently. C. Operational control decision-
making, because it involves routine, repetitive, and highly structured tasks to ensure daily
operations run smoothly. D. Unstructured decision-making, because the system must use
,complex algorithms to guess the best course of action. <b>CORRECT ANSWER: C. Operational
control decision-making, because it involves routine, repetitive, and highly structured tasks to
ensure daily operations run smoothly.</b> Rationale: Operational control decisions are highly
structured, routine, and repetitive. They involve day-to-day operations and can often be fully
automated, such as a sensor triggering a shutdown when a specific threshold is crossed.
<b>Question 6: When evaluating the strategic business value of an information system, Porter's
Competitive Forces Model is frequently used. According to this model, which of the following
forces is directly mitigated by implementing a customer loyalty program that increases
switching costs for buyers?</b> A. The threat of new entrants into the market. B. The
bargaining power of suppliers. C. The rivalry among existing competitors. D. The bargaining
power of customers (buyers). <b>CORRECT ANSWER: D. The bargaining power of customers
(buyers).</b> Rationale: By implementing a loyalty program that increases switching costs, a
company makes it more difficult or expensive for customers to switch to a competitor. This
directly reduces the bargaining power of customers, as they are locked into the company's
ecosystem.
<b>Question 7: A company decides to outsource its entire IT infrastructure, including data
centers and network management, to a third-party cloud provider. This strategic move allows
the company to focus on its core competencies in product development. Which value chain
activity is primarily being supported by this outsourcing decision?</b> A. Inbound logistics, by
ensuring raw materials are delivered on time. B. Operations, by converting the outsourced IT
resources into a competitive advantage for primary activities. C. Technology development, by
leveraging external expertise to support the firm's internal technological innovation and core
business processes. D. Marketing and sales, by reducing the cost of advertising through cloud-
based analytics. <b>CORRECT ANSWER: C. Technology development, by leveraging external
expertise to support the firm's internal technological innovation and core business
processes.</b> Rationale: In Porter's Value Chain, "Technology development" includes the
know-how, procedures, and technology used to design, produce, and deliver the product.
Outsourcing IT infrastructure is a technology development strategy that allows the firm to focus
its internal resources on core product innovation.
<b>Question 8: In the context of business process management (BPM), what is the primary
purpose of conducting an "As-Is" process analysis before designing a new information
system?</b> A. To immediately implement the new system without considering the current
workflow to save time. B. To document and understand the current process, identify
inefficiencies, bottlenecks, and redundant tasks that the new system must address. C. To train
the employees on the new system by showing them how the old system was completely wrong.
D. To calculate the exact financial cost of the old system so that it can be sold to a competitor.
<b>CORRECT ANSWER: B. To document and understand the current process, identify
inefficiencies, bottlenecks, and redundant tasks that the new system must address.</b>
Rationale: An "As-Is" analysis maps the current state of a business process. It is essential for
, identifying pain points, redundancies, and inefficiencies that the "To-Be" (future) process and
the new information system must resolve to add value.
<b>Question 9: A retail bank is redesigning its loan approval process. Instead of having multiple
departments (credit check, income verification, collateral assessment) handle the application
sequentially, the bank implements a system where a single loan officer handles the entire
process from start to finish using an integrated dashboard. This is an example of which business
process redesign principle?</b> A. Parallelizing sequential tasks to speed up the process. B.
Combining tasks and empowering workers to make decisions, thereby reducing handoffs and
processing time. C. Centralizing data storage to ensure all departments access the same
database. D. Capturing information once at the source to avoid re-entry errors. <b>CORRECT
ANSWER: B. Combining tasks and empowering workers to make decisions, thereby reducing
handoffs and processing time.</b> Rationale: Business Process Reengineering (BPR) often
involves combining sequential or fragmented tasks into a single role. By empowering one loan
officer to handle the entire process using an integrated system, the bank eliminates handoffs,
reduces delays, and improves customer service.
<b>Question 10: Which of the following best describes the concept of "business process
reengineering" (BPR) as opposed to "continuous process improvement" (CPI) or Total Quality
Management (TQM)?</b> A. BPR focuses on making small, incremental changes to existing
processes over time to gradually improve quality. B. BPR involves the radical redesign of core
business processes to achieve dramatic improvements in productivity, cycle times, and quality,
often starting with a "clean slate." C. BPR is primarily concerned with ensuring that every
employee follows the standard operating procedures without any deviations. D. BPR relies
exclusively on external consultants to audit the current processes and suggest minor
adjustments to the user interface of existing software. <b>CORRECT ANSWER: B. BPR involves
the radical redesign of core business processes to achieve dramatic improvements in
productivity, cycle times, and quality, often starting with a "clean slate."</b> Rationale: BPR is
characterized by radical, fundamental rethinking and dramatic redesign of processes to achieve
dramatic improvements. In contrast, CPI and TQM focus on continuous, incremental
improvements to existing processes.
<b>Question 11: In a relational database management system (RDBMS), what is the primary
purpose of a "primary key" within a specific table?</b> A. To encrypt the data stored in the
table to prevent unauthorized access by external hackers. B. To uniquely identify each record
(row) in the table, ensuring that no duplicate records exist and enabling efficient data retrieval.
C. To establish a link between two different tables by storing the primary key of the related
table. D. To automatically calculate the sum or average of all numerical values stored in that
specific column. <b>CORRECT ANSWER: B. To uniquely identify each record (row) in the table,
ensuring that no duplicate records exist and enabling efficient data retrieval.</b> Rationale: A
primary key is a column (or set of columns) whose values uniquely identify every row in a table.
It enforces entity integrity by preventing duplicate records and null values in the key column.
Database Design and Management Fundamentals, Relational Database
Concepts and Data Modeling, Entity Relationship Diagrams (ERDs) and
Normalization Techniques, Structured Query Language (SQL) Programming
and Queries, Database Tables Relationships and Constraints, Data Integrity
and Database Security Principles, Business Information Systems Applications
and Data Management Strategies, Database Development Life Cycle and
Implementation Processes, Reporting and Data Analysis Techniques, Business
Intelligence Foundations and Decision Support Systems, Practice Questions
with Verified Answers and Detailed Explanations, Real Database Case Studies,
Step-by-Step SQL and Database Design Frameworks, and Proven Strategies to
Successfully Master BIS 245 and Excel in Database Management and Business
Information Systems
<b>Question 1: In the context of modern business environments, an information system is
fundamentally defined as a set of interrelated components that collect, process, store, and
distribute information to support decision-making and control in an organization. Which of the
following best describes the primary role of people within this system?</b> A. People are
merely end-users who passively consume the reports generated by the hardware components.
B. People are the most important component because they are responsible for designing,
maintaining, and utilizing the system to achieve business objectives. C. People act primarily as
data entry operators whose sole function is to input raw data into the software applications. D.
People serve as the physical infrastructure that connects the various software and hardware
components together. <b>CORRECT ANSWER: B. People are the most important component
because they are responsible for designing, maintaining, and utilizing the system to achieve
business objectives.</b> Rationale: In any information system, people (or users) are considered
the most critical element because technology alone cannot solve business problems; it requires
human intervention to design, manage, and leverage the system for strategic advantage.
<b>Question 2: When analyzing the five-component framework of information systems, which
consists of hardware, software, data, procedures, and people, how do the first three
components differ from the latter two in terms of their primary function and nature?</b> A.
Hardware, software, and data are considered the actors because they perform the actions,
while procedures and people are the stage where the actions occur. B. Hardware, software, and
data are technology components that process and store information, whereas procedures and
people are human-oriented components that direct and utilize the technology. C. Hardware,
software, and data are dynamic components that change frequently, while procedures and
people are static components that remain constant over time. D. Hardware, software, and data
are only used in automated systems, while procedures and people are exclusively used in
,manual information processing systems. <b>CORRECT ANSWER: B. Hardware, software, and
data are technology components that process and store information, whereas procedures and
people are human-oriented components that direct and utilize the technology.</b> Rationale:
The five-component framework separates the technology aspects (hardware, software, data)
from the human aspects (procedures, people). The technology processes and stores data, while
humans create the procedures and interact with the technology to achieve business goals.
<b>Question 3: A large retail corporation is implementing a new point-of-sale system to track
inventory in real-time. The IT department has purchased the necessary servers and software,
but the store employees are resisting the change because they were not trained on the new
procedures. According to the sociotechnical systems theory, what is the most likely outcome of
this implementation?</b> A. The system will succeed because the technical components
(hardware and software) are perfectly aligned with the business requirements. B. The system
will fail or underperform because the social system (people and procedures) was ignored,
leading to resistance and improper usage of the technology. C. The system will automatically
adapt to the employees' habits without any need for formal training or procedural updates. D.
The technical components will compensate for the lack of training by automatically generating
error reports for management to review. <b>CORRECT ANSWER: B. The system will fail or
underperform because the social system (people and procedures) was ignored, leading to
resistance and improper usage of the technology.</b> Rationale: Sociotechnical theory
emphasizes that organizational performance is maximized when the social system (people,
culture, procedures) and the technical system (hardware, software) are jointly optimized.
Ignoring the human element often leads to system failure.
<b>Question 4: In the hierarchy of organizational information systems, which type of system is
specifically designed to support non-routine decision-making for senior management by
providing generalized computing and communication capabilities rather than specific
operational data?</b> A. Transaction Processing Systems (TPS) B. Management Information
Systems (MIS) C. Decision Support Systems (DSS) D. Executive Support Systems (ESS)
<b>CORRECT ANSWER: D. Executive Support Systems (ESS)</b> Rationale: Executive Support
Systems (ESS) are designed for senior management to address non-routine, strategic decisions.
They provide a generalized computing and communication environment, often utilizing internal
data from MIS/DSS and external data (like market trends) via advanced dashboards.
<b>Question 5: A manufacturing company uses an automated system on its assembly line that
monitors temperature and pressure sensors. If the pressure exceeds a certain threshold, the
system automatically shuts down the machine to prevent an explosion. This is an example of
which level of decision-making?</b> A. Strategic decision-making, because it involves long-term
planning and external market factors. B. Management control decision-making, because it
requires middle managers to allocate resources efficiently. C. Operational control decision-
making, because it involves routine, repetitive, and highly structured tasks to ensure daily
operations run smoothly. D. Unstructured decision-making, because the system must use
,complex algorithms to guess the best course of action. <b>CORRECT ANSWER: C. Operational
control decision-making, because it involves routine, repetitive, and highly structured tasks to
ensure daily operations run smoothly.</b> Rationale: Operational control decisions are highly
structured, routine, and repetitive. They involve day-to-day operations and can often be fully
automated, such as a sensor triggering a shutdown when a specific threshold is crossed.
<b>Question 6: When evaluating the strategic business value of an information system, Porter's
Competitive Forces Model is frequently used. According to this model, which of the following
forces is directly mitigated by implementing a customer loyalty program that increases
switching costs for buyers?</b> A. The threat of new entrants into the market. B. The
bargaining power of suppliers. C. The rivalry among existing competitors. D. The bargaining
power of customers (buyers). <b>CORRECT ANSWER: D. The bargaining power of customers
(buyers).</b> Rationale: By implementing a loyalty program that increases switching costs, a
company makes it more difficult or expensive for customers to switch to a competitor. This
directly reduces the bargaining power of customers, as they are locked into the company's
ecosystem.
<b>Question 7: A company decides to outsource its entire IT infrastructure, including data
centers and network management, to a third-party cloud provider. This strategic move allows
the company to focus on its core competencies in product development. Which value chain
activity is primarily being supported by this outsourcing decision?</b> A. Inbound logistics, by
ensuring raw materials are delivered on time. B. Operations, by converting the outsourced IT
resources into a competitive advantage for primary activities. C. Technology development, by
leveraging external expertise to support the firm's internal technological innovation and core
business processes. D. Marketing and sales, by reducing the cost of advertising through cloud-
based analytics. <b>CORRECT ANSWER: C. Technology development, by leveraging external
expertise to support the firm's internal technological innovation and core business
processes.</b> Rationale: In Porter's Value Chain, "Technology development" includes the
know-how, procedures, and technology used to design, produce, and deliver the product.
Outsourcing IT infrastructure is a technology development strategy that allows the firm to focus
its internal resources on core product innovation.
<b>Question 8: In the context of business process management (BPM), what is the primary
purpose of conducting an "As-Is" process analysis before designing a new information
system?</b> A. To immediately implement the new system without considering the current
workflow to save time. B. To document and understand the current process, identify
inefficiencies, bottlenecks, and redundant tasks that the new system must address. C. To train
the employees on the new system by showing them how the old system was completely wrong.
D. To calculate the exact financial cost of the old system so that it can be sold to a competitor.
<b>CORRECT ANSWER: B. To document and understand the current process, identify
inefficiencies, bottlenecks, and redundant tasks that the new system must address.</b>
Rationale: An "As-Is" analysis maps the current state of a business process. It is essential for
, identifying pain points, redundancies, and inefficiencies that the "To-Be" (future) process and
the new information system must resolve to add value.
<b>Question 9: A retail bank is redesigning its loan approval process. Instead of having multiple
departments (credit check, income verification, collateral assessment) handle the application
sequentially, the bank implements a system where a single loan officer handles the entire
process from start to finish using an integrated dashboard. This is an example of which business
process redesign principle?</b> A. Parallelizing sequential tasks to speed up the process. B.
Combining tasks and empowering workers to make decisions, thereby reducing handoffs and
processing time. C. Centralizing data storage to ensure all departments access the same
database. D. Capturing information once at the source to avoid re-entry errors. <b>CORRECT
ANSWER: B. Combining tasks and empowering workers to make decisions, thereby reducing
handoffs and processing time.</b> Rationale: Business Process Reengineering (BPR) often
involves combining sequential or fragmented tasks into a single role. By empowering one loan
officer to handle the entire process using an integrated system, the bank eliminates handoffs,
reduces delays, and improves customer service.
<b>Question 10: Which of the following best describes the concept of "business process
reengineering" (BPR) as opposed to "continuous process improvement" (CPI) or Total Quality
Management (TQM)?</b> A. BPR focuses on making small, incremental changes to existing
processes over time to gradually improve quality. B. BPR involves the radical redesign of core
business processes to achieve dramatic improvements in productivity, cycle times, and quality,
often starting with a "clean slate." C. BPR is primarily concerned with ensuring that every
employee follows the standard operating procedures without any deviations. D. BPR relies
exclusively on external consultants to audit the current processes and suggest minor
adjustments to the user interface of existing software. <b>CORRECT ANSWER: B. BPR involves
the radical redesign of core business processes to achieve dramatic improvements in
productivity, cycle times, and quality, often starting with a "clean slate."</b> Rationale: BPR is
characterized by radical, fundamental rethinking and dramatic redesign of processes to achieve
dramatic improvements. In contrast, CPI and TQM focus on continuous, incremental
improvements to existing processes.
<b>Question 11: In a relational database management system (RDBMS), what is the primary
purpose of a "primary key" within a specific table?</b> A. To encrypt the data stored in the
table to prevent unauthorized access by external hackers. B. To uniquely identify each record
(row) in the table, ensuring that no duplicate records exist and enabling efficient data retrieval.
C. To establish a link between two different tables by storing the primary key of the related
table. D. To automatically calculate the sum or average of all numerical values stored in that
specific column. <b>CORRECT ANSWER: B. To uniquely identify each record (row) in the table,
ensuring that no duplicate records exist and enabling efficient data retrieval.</b> Rationale: A
primary key is a column (or set of columns) whose values uniquely identify every row in a table.
It enforces entity integrity by preventing duplicate records and null values in the key column.
