2079

CSC483 · TU past paper

Decision Support System and Expert System 2079 question paper

The complete TU 2079 exam paper for Decision Support System and Expert System (CSC483), all 12 questions with solved model answers written to the mark scheme.

Past Papers20802079

Tap a question to open its answer.

  1. 110 marksDSS FrameworkAnswer

    Explain DSS framework in detail.[10]

    DSS Framework in Detail

    1. Introduction to DSS

    A Decision Support System (DSS) is an interactive, computer-based information system that supports decision-making activities in an organization. It helps managers and decision-makers solve semi-structured and unstructured problems by providing relevant data, models, and analytical tools.


    2. DSS Framework

    The DSS framework describes the architecture, components, and working mechanism of a Decision Support System. It is typically organized around three core subsystems and supported by a user interface.


    3. Major Components of the DSS Framework

    The classical DSS framework (proposed by Sprague and Carlson) consists of the following major components:

    +--------------------------------------------------+
    |              USER / DECISION MAKER               |
    +--------------------------------------------------+
                            |
                  [ User Interface / Dialog ]
                            |
            +---------------+---------------+
            |               |               |
      [ Database      [ Model Base     [ Knowledge
       Management      Management       Base /
        System ]        System ]        Engine ]
            |               |               |
            +---------------+---------------+
                            |
                  [ Data / External Sources ]
    

    3.1 Database Management System (DBMS) / Data Component

    • Stores and manages internal and external data relevant to decision-making.
    • Sources include: operational databases, data warehouses, external feeds, spreadsheets.
    • Functions:
      • Data storage and retrieval
      • Data integration and filtering
      • Query processing
    • Provides the raw information needed for analysis.

    3.2 Model Base Management System (MBMS) / Model Component

    • Contains a library of quantitative and analytical models used to analyze data.
    • Types of models included:
      • Statistical models (regression, forecasting)
      • Optimization models (linear programming)
      • Simulation models
      • Financial models (NPV, ROI)
    • Functions:
      • Model creation, storage, and execution
      • Sensitivity analysis and what-if analysis
      • Scenario planning
    • This is the analytical engine of the DSS.

    3.3 Knowledge Base / Knowledge Management Component

    • Provides intelligent reasoning and domain-specific knowledge.
    • Contains rules, heuristics, and expert knowledge.
    • Supports Expert Systems integration.
    • Helps in solving unstructured problems where pure data analysis is insufficient.
    • Functions:
      • Rule-based reasoning
      • Inference and recommendation
      • Integration with AI/ML components

    3.4 User Interface / Dialog Management System

    • The bridge between the user and the DSS.
    • Allows users to interact with the system in a user-friendly manner.
    • Features:
      • Menus, forms, dashboards, and reports
      • Natural language queries
      • Graphical displays and visualizations
    • Characteristics of a good dialog component:
      • Easy to use (user-friendly)
      • Flexible and adaptable
      • Supports multiple interaction styles

    4. Types of DSS (within the Framework)

    TypeDescription
    Data-Driven DSSFocuses on accessing and manipulating large databases
    Model-Driven DSSEmphasizes simulation and optimization models
    Knowledge-Driven DSSUses expert knowledge and AI rules
    Document-Driven DSSManages unstructured documents and text
    Communication-Driven DSSSupports group decision-making (GDSS)

    5. DSS Framework Process Flow

    Step 1: Problem Recognition
             |
    Step 2: Data Collection (from DBMS)
             |
    Step 3: Model Selection and Execution (from MBMS)
             |
    Step 4: Knowledge Application (from Knowledge Base)
             |
    Step 5: Result Generation and Display (via UI)
             |
    Step 6: Decision Made by Manager
    

    6. Characteristics of DSS Framework

    • Supports semi-structured and unstructured decisions
    • Designed for managers at all levels
    • Emphasizes flexibility and adaptability
    • Supports what-if analysis and scenario testing
    • Enhances decision quality but does not replace the decision-maker
    • Can be individual or group-based (GDSS)

    7. Advantages of DSS Framework

    1. Improves the speed and quality of decisions
    2. Supports complex problem solving
    3. Enables what-if and sensitivity analysis
    4. Provides data visualization for better understanding
    5. Integrates multiple data sources
    6. Reduces the cost of poor decisions

    8. Limitations of DSS Framework

    1. High development and maintenance cost
    2. Requires skilled users to operate effectively
    3. Over-reliance may reduce managerial judgment
    4. Data quality directly affects decision quality
    5. May face resistance from users

    9. Summary Table

    ComponentRoleExample
    DBMSStores and retrieves dataOracle, SQL Server
    MBMSRuns analytical modelsForecasting, LP models
    Knowledge BaseProvides expert rulesRule-based inference engine
    User InterfaceInteraction with userDashboard, reports

    Conclusion

    The DSS framework provides a structured, integrated environment for supporting managerial decision-making. By combining data management, analytical models, knowledge-based reasoning, and an intuitive user interface, DSS enables organizations to make better, faster, and more informed decisions in complex and uncertain environments.

  2. 210 marksDecision Oriented DiagnosisAnswer

    Discuss decision oriented diagnosis to DSS development.[10]

    Decision-Oriented Diagnosis to DSS Development

    Introduction

    Decision-Oriented Diagnosis is a systematic approach to developing a Decision Support System (DSS) that begins by thoroughly analyzing and understanding the decision-making process within an organization before designing or building the system. Rather than starting with data or technology, this approach starts with the decision itself as the central focus.


    Concept of Decision-Oriented Diagnosis

    The core idea is that a DSS must be built around the nature of the decisions it is meant to support. Before development begins, analysts must diagnose:

    • What decisions need to be supported
    • Who makes those decisions
    • How those decisions are currently being made
    • What information is needed and what is lacking
    • What improvements are possible through a DSS

    This ensures the resulting system is truly aligned with organizational decision needs rather than being a generic information system.


    Steps in Decision-Oriented Diagnosis

    Step 1: Identify the Decision to be Supported

    • Clearly define the target decision or set of decisions
    • Classify the decision type:
      • Structured (routine, programmable)
      • Semi-structured (partially programmable)
      • Unstructured (complex, judgment-based)
    • DSS is most relevant for semi-structured and unstructured decisions

    Step 2: Analyze the Decision Maker(s)

    • Identify who makes the decision (individual or group)
    • Understand the decision maker's:
      • Cognitive style (analytical vs. heuristic)
      • Level of expertise and experience
      • Information preferences
    • This shapes the user interface and interaction design of the DSS

    Step 3: Understand the Decision-Making Process

    Using Simon's decision-making model (Intelligence, Design, Choice, and Implementation phases):

    PhaseDescription
    IntelligenceScanning the environment, identifying problems
    DesignDeveloping and analyzing possible courses of action
    ChoiceSelecting the best alternative
    ImplementationCarrying out the chosen decision

    The diagnosis identifies at which phase the decision maker needs support most.

    Step 4: Identify Information Requirements

    • Determine what data and information are needed at each phase
    • Identify gaps between available information and required information
    • Assess the quality, timeliness, and format of current information
    • This directly drives the database and model design of the DSS

    Step 5: Identify Decision Constraints and Context

    • Organizational constraints (policies, resources, time)
    • Environmental factors (market, regulations)
    • Uncertainty and risk levels involved
    • Understanding constraints helps define the scope and boundaries of the DSS

    Step 6: Diagnose Current Decision Support Mechanisms

    • Evaluate existing tools, reports, and systems currently used
    • Identify weaknesses and inefficiencies in current support
    • Determine what the DSS must do differently or better

    Step 7: Define DSS Requirements

    Based on the above diagnosis, formulate:

    • Functional requirements: What the DSS must do
    • Data requirements: What data must be stored and accessed
    • Model requirements: What analytical models are needed
    • Interface requirements: How the user will interact with the system

    Why Decision-Oriented Diagnosis is Important

    BenefitExplanation
    RelevanceEnsures DSS directly addresses real decision needs
    User acceptanceSystem is built around actual user behavior and preferences
    EfficiencyAvoids building unnecessary features
    EffectivenessImproves decision quality by targeting specific gaps
    AlignmentConnects DSS design to organizational goals

    Relationship to DSS Components

    The diagnosis directly informs the three core DSS components:

    Decision-Oriented Diagnosis
            |
            |-----> Data Management Subsystem (what data is needed)
            |
            |-----> Model Management Subsystem (what models/analysis needed)
            |
            |-----> User Interface Subsystem (how decision maker interacts)
    

    Example

    Consider a bank loan approval decision (semi-structured):

    • Decision identified: Whether to approve or reject a loan application
    • Decision maker: Loan officer
    • Process analyzed: Officer currently uses manual credit checks with inconsistent criteria
    • Information gap: No integrated risk scoring model
    • DSS designed: A DSS with a credit scoring model, customer database, and what-if analysis capability

    The decision-oriented diagnosis revealed exactly what the DSS needed to provide.


    Conclusion

    Decision-Oriented Diagnosis ensures that DSS development is problem-driven rather than technology-driven. By systematically diagnosing the decision environment, the decision maker, the decision process, and information needs, developers can build a DSS that genuinely enhances decision quality, reduces uncertainty, and supports managers effectively. It is considered one of the most rational and user-centered approaches to DSS development.

  3. 310 marksImplementing Communication-Driven and GrouAnswer

    Why GDSS is important? Explain various group decision support systems.[10]

    A Group Decision Support System (GDSS) is an interactive computer-based system that facilitates the solution of unstructured or semi-structured problems by a group of decision makers working together as a team. It combines communication ...

  4. 45 marksDecision Support vs. Transaction ProcessinAnswer

    How DSS differs from TPS? Explain. [5]

    Both Decision Support Systems (DSS) and Transaction Processing Systems (TPS) are types of information systems used in organizations, but they serve fundamentally different purposes, users, and functions. --- A TPS is a computerized syste...

  5. 55 marksDSS Project Management and ParticipantsAnswer

    Explain various DSS project participants. [5]

    A DSS project involves several key participants, each playing a distinct role in the development, implementation, and use of the system. The major participants are: --- - These are the managers or decision makers who directly interact wi...

  6. 65 marksDecision Support vs. Transaction ProcessinAnswer

    Differentiate between DSS data and operating data. [5]

    Basis DSS Data Operating Data --------- Purpose Used for decision making, analysis, and planning Used for day-to-day business operations and transaction processing Nature Historical, summarized, and integrated Current, detailed, and appl...

  7. 75 marksArchitecture and Components of Expert SystAnswer

    Explain the architecture of expert systems in detail. [5]

    An expert system is an AI-based computer program that simulates the knowledge and reasoning ability of a human expert in a specific domain to solve complex problems. --- The architecture of an expert system consists of the following majo...

  8. 85 marksFuzzy ReasoningAnswer

    Discuss fuzzy reasoning process. [5]

    Fuzzy reasoning (also called approximate reasoning or fuzzy inference) is a method of drawing conclusions from fuzzy premises using fuzzy logic. It extends classical logical reasoning to handle imprecise, vague, or uncertain information ...

  9. 95 marksOpportunities and IS PlanningAnswer

    Discuss strategic impact grid. [5]

    Strategic Impact Grid

    Introduction

    The Strategic Impact Grid (also known as the Strategic Grid or McFarlan's Strategic Grid) is a framework used to assess the strategic importance of Information Systems (IS) and Information Technology (IT) to an organization. It helps management understand the current and future role of IT in achieving business objectives.


    The Grid Structure

    The Strategic Impact Grid is a 2x2 matrix with two dimensions:

    DimensionDescription
    Strategic Impact of Existing SystemsHow critical are the current IT systems to the organization's operations?
    Strategic Impact of Future SystemsHow important will future IT applications be to achieving strategic goals?

    The Four Quadrants

                        HIGH
                         |
            TURNAROUND   |   STRATEGIC
                         |
    LOW ________________|________________ HIGH
      (Future Impact)   |          (Future Impact)
                         |
            SUPPORT      |   FACTORY
                         |
                        LOW
            (Current Systems Impact)
    

    1. Support

    • Current IT systems: Low strategic impact
    • Future IT systems: Low strategic impact
    • IT is used for routine, back-office tasks (e.g., payroll, accounting)
    • IT failure would cause inconvenience but not halt operations
    • IT is not a competitive differentiator
    • Example: A small retail shop using basic accounting software

    2. Factory

    • Current IT systems: High strategic impact
    • Future IT systems: Low strategic impact
    • Organization is heavily dependent on existing IT for day-to-day operations
    • IT failure would seriously disrupt business
    • Future IT investments are not seen as strategically critical
    • Example: Airlines using reservation systems

    3. Turnaround

    • Current IT systems: Low strategic impact
    • Future IT systems: High strategic impact
    • Current IT is not critical, but future IT applications are expected to be vital
    • Organization is in a transition phase
    • IT is seen as a future competitive weapon
    • Example: A company beginning to adopt e-commerce

    4. Strategic

    • Current IT systems: High strategic impact
    • Future IT systems: High strategic impact
    • IT is central to both current operations and future strategy
    • IT provides competitive advantage and is mission-critical
    • Requires strong IT leadership and significant investment
    • Example: Banks, online retailers like Amazon

    Importance / Uses of the Strategic Impact Grid

    1. Guides IT investment decisions -- helps prioritize where to allocate IT budgets
    2. Aligns IT with business strategy -- ensures IT supports organizational goals
    3. Identifies risk -- highlights areas where IT failure could be catastrophic
    4. Helps in IT governance -- determines the level of management attention required
    5. Supports planning -- assists in long-term IT strategic planning

    Conclusion

    The Strategic Impact Grid is a valuable tool for senior management and IT planners to evaluate the role of information systems in their organization. By positioning the organization within one of the four quadrants, decision-makers can better align IT investments with business strategy and manage IT-related risks effectively.

  10. 105 marksExpert Systems Development Life CycleAnswer

    Discuss expert system development life cycle. [5]

    An expert system is a computer program that emulates the decision-making ability of a human expert in a specific domain. Developing an expert system follows a structured life cycle consisting of the following phases: --- - Identify the p...

  11. 115 marksTypes of Fuzzy Expert SystemsAnswer

    Discuss various types of fuzzy expert systems. [5]

    A fuzzy expert system stores expert knowledge as fuzzy IF-THEN rules and reasons over them with fuzzy logic, which lets it handle linguistic and imprecise information that a Boolean expert system cannot express. All of them are rule-base...

  12. 125 marksPrepare a Feasibility StudyAnswer

    Write short notes on: a. Cost-Effectiveness Analysis b. Executive DSS [5]

    Cost-Effectiveness Analysis is a method of evaluating and comparing the relative costs and outcomes (effects) of two or more courses of action to determine which option provides the best value for the resources invested. - It is used whe...