ISDS 3110 Final Exam
Exam Coverage
Exam coverage for ISDS 3110 Final Exam Guide / Actual Exam includes
core information systems and data analytics concepts commonly
covered in business analytics coursework. It focuses on data
management, databases, SQL basics, data visualization, business
intelligence tools, and decision support systems. The exam also
evaluates understanding of data-driven decision-making, descriptive
and predictive analytics, spreadsheet modeling (e.g., Excel), and
interpretation of business data. Emphasis is placed on applying
analytical techniques, solving business problems using data,
understanding information system components, and making informed,
data-supported decisions in organizational contexts. 📊💻📘
,Pattern Match Search Condition - LIKE / NOT LIKE
%
- Represents any sequence of zero or more characters (wildcard)
_(underscore)
- Represents any single character
Subqueries
A query within a query
, Multi-Table Join with Selection Predicates example.
List the fname and lname of clients who are registered in branches in
'London'.
SELECT DISTINCT c.fName, c.lName FROM Client c, Registration r,
Branch b WHERE c.clientNo = r.clientNo AND r.branchNo =
b.branchNo AND b.city = 'London'
Motivation for Normalization
Problem 1. Data Redundancy
Problem 2. Update Anomalies
Exam Coverage
Exam coverage for ISDS 3110 Final Exam Guide / Actual Exam includes
core information systems and data analytics concepts commonly
covered in business analytics coursework. It focuses on data
management, databases, SQL basics, data visualization, business
intelligence tools, and decision support systems. The exam also
evaluates understanding of data-driven decision-making, descriptive
and predictive analytics, spreadsheet modeling (e.g., Excel), and
interpretation of business data. Emphasis is placed on applying
analytical techniques, solving business problems using data,
understanding information system components, and making informed,
data-supported decisions in organizational contexts. 📊💻📘
,Pattern Match Search Condition - LIKE / NOT LIKE
%
- Represents any sequence of zero or more characters (wildcard)
_(underscore)
- Represents any single character
Subqueries
A query within a query
, Multi-Table Join with Selection Predicates example.
List the fname and lname of clients who are registered in branches in
'London'.
SELECT DISTINCT c.fName, c.lName FROM Client c, Registration r,
Branch b WHERE c.clientNo = r.clientNo AND r.branchNo =
b.branchNo AND b.city = 'London'
Motivation for Normalization
Problem 1. Data Redundancy
Problem 2. Update Anomalies
