Business Information Systems 2024 Board Question Paper

Two Examples of Computer-Based Reservation Systems

Two prominent, real-world examples of Computer-Based Reservation Systems (CBRS) are:

1. Amadeus / Sabre Global Distribution System (GDS): Enterprise travel reservation networks that connect airlines, hotels, car rental agencies, and travel agents worldwide for real-time inventory checking, seat booking, and ticketing.
2. IRCTC (Indian Railway Catering and Tourism Corporation) / Airline Web Booking Portals: Consumer-facing computerized passenger reservation systems handling millions of concurrent seat reservations, ticket cancellations, dynamic seat allocations, and payment gateway transactions.

Definition of Business Process Improvement (BPI)

Business Process Improvement (BPI) is a systematic, incremental management methodology that focuses on analyzing, optimizing, and fine-tuning existing business processes to eliminate bottlenecks, reduce cycle time, reduce errors, and enhance operational efficiency without fundamentally redesigning the entire workflow from scratch (often implemented via Lean or Six Sigma frameworks).

Difference Between Database and Data Warehouse

Two Types of Wireless Networks

Two major categories of wireless computer networks are:

1. Wireless Local Area Network (WLAN / Wi-Fi - IEEE 802.11): Connects computers, smartphones, and printers within a limited geographic radius (such as an office, home, or campus) using radio frequencies.
2. Wireless Wide Area Network (WWAN / Cellular 4G & 5G): Provides voice and high-speed mobile broadband data services across broad metropolitan, national, and global geographic areas via cellular tower infrastructure.

Two Key Importances of Web 2.0

1. User-Generated Content & Active Collaboration: Transitions the World Wide Web from a passive, read-only medium (Web 1.0) into a participatory, bidirectional platform where users co-create, curate, and share knowledge (e.g., wikis, blogs, video-sharing platforms).
2. Crowdsourcing and Collective Intelligence: Enables enterprises to harness distributed customer ideas, product reviews, peer recommendations, and real-time market feedback to accelerate innovation and enhance customer engagement.

One Desirable Characteristic of a Transaction Processing System (TPS)

High Transaction Throughput and Rapid Response Time: A TPS must process massive volumes of routine, daily operational business transactions (such as point-of-sale checkouts, ATM withdrawals, and inventory updates) with minimal latency and high concurrency, ensuring that transactions are confirmed instantaneously without slowing down frontline business operations while strictly upholding ACID (Atomicity, Consistency, Isolation, Durability) properties.

Definition of Operational Supply Chain Management

Operational Supply Chain Management refers to the day-to-day execution, tracking, and control of the physical flow of materials, parts, and finished goods across the supply chain. It encompasses immediate operational tasks such as daily production scheduling, purchase order processing, warehouse inventory management, shipment dispatching, and customer order fulfillment.

What is Business Analytics?

Business Analytics (BA) is the systematic, iterative exploration of an organization’s raw operational and historical data using statistical models, quantitative analysis, data mining, machine learning, and predictive techniques to transform data into actionable insights, identify emerging business trends, and support strategic managerial decision-making.

Definition of Data Mart

A Data Mart is a small, specialized, departmental subset of an enterprise data warehouse designed to serve the specific reporting and analytical requirements of a single business unit, department, or functional area (such as Marketing, Sales, or Human Resources). It provides faster query performance, lower implementation costs, and targeted data accessibility for departmental managers.

What is an Information System?

An Information System (IS) is a formal, sociotechnical arrangement of interrelated components—including Hardware, Software, Data, People, Procedures, and Telecommunication Networks—that collects (input), transforms (processing), stores, and disseminates (output) timely and accurate information to support decision-making, coordination, control, and strategic competitive advantage in an organization.

Achieving Operational Excellence Using Information Systems

Concept of Operational Excellence:

Operational excellence is achieved when an organization continuously optimizes its business processes, minimizes waste and operational costs, improves productivity, and maximizes customer value by leveraging Information Systems.

+-------------------------------------------------------------------------+
|                  Information Systems for Operational Excellence         |
+-------------------+--------------------+--------------------------------+
| Automated Flow    | Real-Time Visibility| Synchronized Operations        |
| - Eliminates paperwork - Instant inventory data - Supplier auto-replenishment |
+-------------------+--------------------+--------------------------------+

Mechanisms to Achieve Operational Excellence:

1. Automation of Routine Workflows: Eliminates manual data entry errors, accelerates cycle times, and reduces administrative overhead (e.g., automated invoicing and order routing).
2. Real-Time Supply Chain Synchronization: Integrates suppliers and distributors using Electronic Data Interchange (EDI) and Enterprise Resource Planning (ERP) to eliminate stockouts and minimize carrying costs.
3. Cross-Departmental Data Transparency: A centralized database breaks down departmental silos, providing management with accurate, live performance dashboards.

Concrete Real-World Example:

• Walmart’s Retail Link System: Walmart connects its point-of-sale (POS) barcode scanners directly to suppliers like Procter & Gamble. When a customer purchases a product, the transaction data instantly triggers a reorder in the supplier’s warehouse. This just-in-time inventory system minimizes inventory holding costs, eliminates excess warehousing, and ensures shelf availability, enabling Walmart to maintain its low-cost competitive advantage.

Advantages of the Database Approach for Managing Data

Compared to traditional, isolated file-processing systems, the database approach centralizes data management via a Database Management System (DBMS), delivering significant enterprise benefits:

+------------------------------------------------------------------------+
|                     Database Approach Advantages                       |
+-------------------+--------------------+-------------------------------+
| Data Quality      | Security & Sharing | Architecture                  |
| - Zero redundancy | - Role-based access| - Physical data independence  |
| - High integrity  | - Concurrent multi-user - Logical data independence|
+-------------------+--------------------+-------------------------------+

1. Controlled Data Redundancy & Inconsistency: Data is stored in centralized, non-redundant normalized tables. Updates happen in one place, preventing contradictory versions of truth across departments.
2. Data Sharing and Multi-User Concurrency: Multiple authorized business users and applications can access the same data simultaneously without file-locking conflicts or race conditions.
3. Enforcement of Integrity Constraints: The DBMS automatically enforces business rules, primary keys, referential integrity, and data type validity rules at the engine level.
4. Data Independence (Physical and Logical): Separates conceptual data structures from physical storage schemes, allowing database tuning without rewriting client application programs.
5. Centralized Security and Backup/Recovery: Enables DBAs to manage access privileges, encrypt data, and perform automated recovery from hardware or transaction failures.

Three Major Advantages of Mobile Commerce (M-Commerce)

Mobile Commerce (M-Commerce) refers to conducting commercial transactions—buying, selling, and paying for products and services—using wireless handheld mobile devices (smartphones, tablets).

                      Core Advantages of M-Commerce
                                   |
         +-------------------------+-------------------------+
         |                         |                         |
  Ubiquity & Reach         Location-Based Services     Seamless Frictionless
(Anytime / Anywhere)        (Hyper-Personalization)           Payments

1. Ubiquity and Anytime/Anywhere Accessibility:
   • Consumers are no longer tethered to a desktop computer. M-commerce allows customers to browse catalogs, place orders, and track shipments anywhere, 24/7/365, dramatically expanding impulse buying and market reach for retailers.
2. Location-Based Services (LBS) and Hyper-Personalization:
   • Mobile devices leverage GPS, cellular triangulation, and Wi-Fi beacons to identify user location. Businesses can deliver personalized geo-targeted promotions, localized store directions, and real-time discounts when a customer enters a specific shopping zone.
3. Frictionless Digital Payments & Convenience:
   • Integrated mobile wallets (Apple Pay, Google Pay, eSewa, Khalti) and biometric authentication (fingerprint/Face ID) simplify one-click checkout, reducing shopping cart abandonment and accelerating transaction speed.

Importance of Social Computing in Marketing

Social computing combines social behaviors with digital interactive technologies, fundamentally reshaping enterprise marketing strategies:

+----------------------------------------------------------------------+
|                 Social Computing in Modern Marketing                 |
+------------------+-------------------+-------------------------------+
| Viral Reach      | Direct Engagement | Social Listening              |
| - Social sharing | - Two-way feedback| - Sentiment analysis & AI     |
| - Influencer ads | - Community bldg  | - Real-time crisis management |
+------------------+-------------------+-------------------------------+

1. Precision Micro-Targeting and High Ad ROI:
   • Social platforms (Meta, Instagram, LinkedIn, TikTok) gather rich behavioral, demographic, and interest data, allowing marketers to deliver highly personalized ads to narrow target audiences with high conversion rates.
2. Peer Recommendations & Social Proof (Viral Marketing):
   • Modern consumers trust peer reviews, user-generated ratings, and influencer testimonials far more than traditional corporate broadcast ads. Positive word-of-mouth spreads organically and rapidly across social networks.
3. Social Listening and Sentiment Analysis:
   • Organizations monitor brand mentions, customer complaints, and competitor trends in real time using Natural Language Processing (NLP) tools, allowing rapid product improvements and active crisis management.
4. Interactive Two-Way Customer Engagement:
   • Transforms marketing from static one-way messaging into interactive conversational relationships, fostering brand loyalty and active community building.

Two Types of Functional Area Information Systems (FAIS)

Functional Area Information Systems (FAIS) support specific business departments within an organization by automating specialized operational tasks and providing targeted managerial reports.

                     Functional Area Systems (FAIS)
                                   |
         +-------------------------+-------------------------+
         |                                                   |
Marketing Information Systems (MKIS)         Human Resource Information Systems (HRIS)
- Campaign & Lead Management                - Employee Records & Payroll
- Customer Demographics & Pricing           - Talent Acquisition & Performance

---

1. Marketing Information Systems (MKIS)

• Purpose: Supports the marketing and sales departments in analyzing customer demand, managing advertising campaigns, setting prices, and forecasting sales.
• Key Modules:
  • Sales Automation: Manages sales funnels, customer leads, and territory assignments.
  • Market Research & Analytics: Analyzes customer preferences, competitive pricing, and promotional campaign effectiveness.
  • Product Lifecycle Management: Monitors sales trajectories across product introduction, growth, and decline stages.

---

2. Human Resource Information Systems (HRIS)

• Purpose: Manages the entire employee lifecycle within an enterprise, ensuring optimal workforce allocation, regulatory compliance, and employee satisfaction.
• Key Modules:
  • Payroll & Benefits Administration: Automatically calculates wages, taxes, social security deductions, and bonuses.
  • Recruitment & Talent Acquisition: Tracks job applications, candidate resumes, and interview evaluations.
  • Performance & Training Tracking: Records employee appraisals, skill certifications, and training progress.

Stages of Business Analytics

Business analytics evolves through three sequential stages of maturity, each delivering higher business value and answering progressively sophisticated strategic questions:

Business Value
    ^
    |                                                 +-----------------------+
    |                                                 | Prescriptive Analytics|
    |                                                 | "What should we do?"  |
    |                                 +---------------+-----------------------+
    |                                 | Predictive Analytics  |
    |                                 | "What will happen?"   |
    |                 +---------------+-----------------------+
    |                 | Descriptive Analytics |
    |                 | "What happened?"      |
    | +---------------+-----------------------+
    +-------------------------------------------------------------------------> Complexity

---

1. Descriptive Analytics (“What Happened?”)

• Focus: Examines historical operational data to understand past business performance, trends, and anomalies.
• Techniques & Tools: Data aggregation, statistical summaries, slicing-and-dicing, OLAP cubes, executive dashboards (Power BI, Tableau).
• Example: Generating monthly sales reports by region to discover that sales dropped 12% in the second quarter.

---

2. Predictive Analytics (“What Will Happen?”)

• Focus: Applies statistical models, regression, machine learning algorithms, and data mining to historical patterns to forecast future outcomes and probabilities.
• Techniques & Tools: Linear/logistic regression, time-series forecasting, decision trees, neural networks.
• Example: Predicting which bank customers are at high risk of loan default or credit card fraud.

---

3. Prescriptive Analytics (“What Should We Do?”)

• Focus: Recommends optimal courses of action and evaluates the trade-offs of various decision alternatives using optimization and simulation techniques.
• Techniques & Tools: Linear programming, Monte Carlo simulations, heuristic algorithms, decision analysis trees.
• Example: An airline dynamically adjusting ticket prices and seat allocations across flights to maximize total flight revenue.

Steps of Business Process Reengineering (BPR)

Concept of Business Process Reengineering:

Popularized by Michael Hammer and James Champy, Business Process Reengineering (BPR) is the fundamental rethinking and radical redesign of core business processes to achieve dramatic, quantum-leap improvements in contemporary measures of performance, such as cost, quality, service, and speed.

Unlike incremental improvement (BPI), BPR advocates starting from a clean slate (“clean sheet of paper”).

+-------------------------------------------------------------------------+
|                         Sequential Steps of BPR                         |
+-------------------------------------------------------------------------+
| Step 1: Develop Business Vision and Process Objectives                  |
|                           |                                             |
|                           v                                             |
| Step 2: Identify and Select Critical Business Processes to Redesign    |
|                           |                                             |
|                           v                                             |
| Step 3: Understand and Measure Existing Processes (Baseline)            |
|                           |                                             |
|                           v                                             |
| Step 4: Identify IT Enablers and Levers                                 |
|                           |                                             |
|                           v                                             |
| Step 5: Design a Prototype / Blueprint of the New Process               |
|                           |                                             |
|                           v                                             |
| Step 6: Implement the Redesigned Process and Manage Change              |
+-------------------------------------------------------------------------+

---

Detailed Breakdown of Steps:

1. Step 1: Develop Business Vision and Process Objectives:
   • Senior leadership establishes strategic goals driving the reengineering effort (e.g., reducing order fulfillment time from 15 days to 2 hours, cutting operational costs by 40%).
2. Step 2: Identify Critical Processes to Redesign:
   • The organization audits existing workflows and selects core processes that have the greatest impact on strategic objectives or suffer from severe customer dissatisfaction (e.g., loan approval process, customer onboarding).
3. Step 3: Understand and Measure Existing Processes (Baseline):
   • Document the existing “As-Is” process to understand its bottlenecks, handoffs, unnecessary steps, and current cost/time baseline metrics without getting trapped in “analysis paralysis.”
4. Step 4: Identify Information Technology (IT) Enablers:
   • Explore innovative IT capabilities that make entirely new workflows possible (e.g., cloud computing, mobile apps, automated robotic process automation - RPA, shared databases).
5. Step 5: Design a Prototype / Blueprint of the New Process (“To-Be”):
   • Create a radical, streamlined “To-Be” process model that eliminates intermediate handoffs, consolidates job roles into case workers, and automates approvals.
6. Step 6: Implement and Manage Organizational Change:
   • Roll out the new process along with employee retraining, restructured incentives, continuous stakeholder communication, and iterative monitoring.

How Business Analytics Facilitates Decision Making with Examples

Framework of Analytics-Driven Decision Making:

Traditionally, managerial decision-making often relied on intuition, gut feeling, or static quarterly financial reports. Business Analytics (BA) transforms this into an evidence-based, objective paradigm where data models drive optimal business choices across all organizational levels.

Raw Transaction Data ---> Data Warehouse ---> Advanced Analytics Engine ---> Prescriptive Action
(POS, Web, ERP)           (Cleaned & ETL)     (Statistical ML Models)      (Automated / Managerial)

---

Key Ways Analytics Facilitates Decision-Making:

1. Uncovering Hidden Patterns & Relationships: Data mining algorithms expose subtle consumer purchasing correlations that humans cannot detect manually (e.g., market basket analysis).
2. Risk Mitigation and Predictive Scoring: Quantifies risk probabilities, enabling institutions to approve loans or set insurance premiums with minimal default exposure.
3. Real-Time Operational Agility: Real-time stream analytics allows instant operational adjustments during demand spikes or supply chain disruptions.
4. Scenario Simulation & “What-If” Analysis: Managers can test the impact of pricing changes, marketing budget reallocations, or production shifts before committing capital.

---

Comprehensive Real-World Examples:

• Example 1: Credit Risk Evaluation in Commercial Banking:

  • Problem: Evaluating loan applicants to balance revenue against loan default risk.
  • Analytics Application: Banks deploy logistic regression and gradient boosting models on thousands of variables (credit score, income stability, spending habits, repayment history).
  • Decision Facilitated: The system outputs an empirical default probability score. Low-risk applications are instantly auto-approved; marginal cases are routed to senior underwriters with clear risk flags.

• Example 2: Dynamic Pricing in Ride-Sharing (Uber / Grab):

  • Problem: Matching driver supply with rider demand during peak hours.
  • Analytics Application: Prescriptive algorithms analyze live GPS data, weather conditions, historical ride requests, and traffic congestion.
  • Decision Facilitated: Surge pricing algorithms automatically calculate optimal fare multipliers in real time to incentivize drivers to enter high-demand zones while moderating excess customer demand.

Three Types of Customer Relationship Management (CRM) Systems

Customer Relationship Management (CRM) systems are integrated software suites designed to manage all enterprise interactions with current and potential customers across their complete lifecycle:

+-------------------------------------------------------------------------+
|                              CRM Ecosystem                              |
+-------------------+--------------------+--------------------------------+
|  Operational CRM  |   Analytical CRM   |       Collaborative CRM        |
|  Front-Office     |   Back-Office      |       Cross-Departmental       |
|  Customer-Facing  |   Data & Insights  |       Data Sharing & Partners  |
+-------------------+--------------------+--------------------------------+

---

1. Operational CRM (Front-Office Automation)

• Purpose: Directly supports and automates front-office, customer-facing business processes.
• Core Components:
  • Sales Force Automation (SFA): Automatically tracks sales leads, manages pipelines, schedules follow-up tasks, and forecasts sales closings.
  • Customer Service & Support (CSS): Automates call center ticketing, helpdesks, live chat assistance, and return merchandise authorizations (RMA).
  • Marketing Automation: Delivers personalized email drip campaigns, manages lead scoring, and triggers promotions based on customer triggers.
• Primary Benefit: Improves frontline employee efficiency and ensures prompt, consistent customer service.

---

2. Analytical CRM (Back-Office Intelligence)

• Purpose: Analyzes customer transaction history, web interactions, preferences, and behavioral data collected by operational CRM to generate business insights.
• Core Components:
  • Customer Profiling & Segmentation: Groups customers into demographic or value-based clusters for targeted marketing.
  • Churn Prediction Modeling: Identifies at-risk customers likely to switch to competitors, allowing preemptive retention offers.
  • Customer Lifetime Value (CLV) Calculation: Determines the long-term profitability of distinct customer tiers.
• Primary Benefit: Enables strategic marketing, pricing optimization, and proactive customer retention.

---

3. Collaborative CRM (Cross-Departmental & Partner Integration)

• Purpose: Facilitates seamless communication and sharing of customer information across various internal departments (sales, billing, marketing, logistics) and external partners (distributors, resellers).
• Core Components:
  • Interaction Management: Logs customer touchpoints across phone, email, web, and physical stores in a shared company-wide profile.
  • Channel Management: Ensures unified pricing and brand experience regardless of whether a customer buys online or through a local dealer.
• Primary Benefit: Eliminates disjointed communications so customers never have to repeat their issue to different departments.

Justification: Improving Organizational Performance through Knowledge Management Systems (KMS)

Thesis Statement:

“By implementing a Knowledge Management System (KMS), an organization can significantly enhance its overall performance, innovation capacity, decision speed, and operational resilience.” This assertion is fully justified in contemporary information systems theory and corporate practice.

---

1. Theoretical Foundation: Tacit vs. Explicit Knowledge

• Explicit Knowledge: Objective, codified knowledge stored in documents, manuals, patents, databases, and standard operating procedures (SOPs). Easily digitized.
• Tacit Knowledge: Subjective, personal, highly experiential knowledge residing in human minds (intuition, craftsmanship, negotiation tricks). Difficult to codify.
• Role of KMS: A KMS facilitates the SECI Model (Nonaka & Takeuchi)—transforming tacit expertise into institutional explicit assets through Socialization, Externalization, Combination, and Internalization.

              +-----------------------------------------------+
              |                 KMS Impact                    |
+-------------+-------------+-------------------+-------------+-------------+
| Prevents Intellectual     | Accelerates       | Eliminates  | Fosters     |
| Brain-Drain (Turnover)    | Onboarding        | "Reinventing| Continuous  |
|                           | & Problem-Solving | the Wheel" | Innovation  |
+---------------------------+-------------------+-------------+-------------+

---

2. Key Dimensions of Performance Improvement:

1. Preventing Intellectual Capital Loss: When experienced senior employees retire or resign, their critical technical and institutional knowledge remains archived in the corporate KMS rather than vanishing with them.
2. Eliminating Redundant Effort (“Reinventing the Wheel”): Teams across global offices can search the KMS repository for pre-existing code, engineering designs, or legal contracts, reducing project cycle times by up to 50%.
3. Faster Onboarding & Knowledge Transfer: New hires access structured wikis and video repositories, reaching peak productive capacity significantly faster.
4. Enhanced Customer Support Quality: Technical support engineers quickly resolve complex customer issues by querying central resolution repositories.

---

3. Concrete Corporate Examples:

• McKinsey & Company / Accenture: Global management consultancies maintain sophisticated KMS platforms (e.g., McKinsey’s “PD Net”). When consultants take on an engagement in a new industry (e.g., electric vehicle supply chains in Southeast Asia), they immediately retrieve anonymized benchmark studies, diagnostic frameworks, and financial models built by global colleagues, delivering superior client recommendations in days instead of months.
• Siemens “ShareNet”: A global knowledge network linking thousands of technical sales engineers. If an engineer in Singapore encounters an unfamiliar industrial networking issue, they broadcast an inquiry on ShareNet; within hours, solutions from engineers in Germany or Brazil are shared, directly winning client contracts and avoiding costly design failures.