Information System for Business Intelligence
CIS · Quiz · Summer 26
Paper 3 of 3Section A · Batch 232 · Rafsan Bin Habib (3)Switch
Section A · Batch 232
Paper 3 of 3
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Daffodil International University
Faculty of Science & Information Technology
Department of Computing and Information System (CIS)
Class Test 3, Summer 2026
Course Code: BI417; Course Title: INFORMATION SYSTEMS FOR BUSINESS INTELLIGENCE
Section: A
Time: 30 Mins
Marks: 15
Answer ALL Questions
[The figure in the right margin indicates the full marks. All portions of each question must be answered sequentially.]
1. Lecture 6 - JOINs and Multi-Table Analysis
5
a) Write one difference between INNER JOIN and LEFT JOIN. [2]
b) A company has customers(customer_id, name) and orders(order_id, customer_id). Which JOIN should be used to show all customers, including customers with no order? Give one reason. [1]
c) Write a simple SQL query using INNER JOIN to show customer name and order_id for customers who placed orders. [2]
2. Lecture 7 - Time-Based Analysis and KPIs
5
a) Why should YEAR and MONTH both be used when grouping monthly sales data from more than one year? [2]
b) Revenue was BDT 100,000 last month and BDT 120,000 this month. Calculate the growth percentage. [2]
c) Is the result an increase or a decrease? State one simple managerial interpretation. [1]
3. Lecture 8 - Decision Support Systems (DSS)
5
a) What is a Decision Support System (DSS)? [2]
b) Which decision type usually benefits most from DSS: structured, semi-structured, or unstructured? [1]
c) A manager sees that sales dropped 15% on a BI dashboard. Explain why the dashboard alone may not be enough to decide what to do next. Mention one DSS technique that can help. [2]
Scope: Lecture 6, Lecture 7 and Lecture 8 only.