Skip to content

Information System for Business Intelligence

CIS · Quiz · Summer 26

Paper 2 of 3Section A · Batch 232 · Rafsan Bin Habib (2)Switch

Section A · Batch 232

Paper 2 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 CIS Quiz 2, Spring 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. Scenario: Courier BI Performance A courier company's operational dashboard takes 90 seconds to load. Monitoring shows CPU usage at 30%, RAM usage at 95%, and a full scan of a 15-million-row delivery table whenever users filter by delivery_date. a) Identify the two most likely performance bottlenecks. b) Recommend one suitable technical improvement. 2. Scenario: Courier Reporting Table A company stores shipment data in one relation: shipment_report(ShipmentID, BookingDate, CustomerID, CustomerName, CustomerPhone, BranchID, BranchName, District, ServiceType, DeliveryCharge, DeliveryStatus) a) Identify any two redundancy or anomaly risks in this design. b) Propose four normalized tables and indicate their primary and relevant foreign keys. 3. Scenario: Courier BI Model Management wants to analyze shipment volume, delivery revenue, delivery time, and failed deliveries by booking date, customer, branch, service type, and delivery district. a) Name a suitable fact table and clearly define its grain. b) List any four appropriate dimension tables. 4. SQL for Decision Making Given deliveries(delivery_id, delivery_date, branch, district, service_type, delivery_status, delivery_charge), write one SQL query to show total delivery revenue and the number of delivered shipments by branch for Dhaka and Chattogram districts only. Include only branches with total revenue above 500,000 and display the highest revenue first.