Skip to content

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

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

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.