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.
Tap a question to open its answer.
- 110 marksDSS FrameworkHideAnswer
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)
Type Description Data-Driven DSS Focuses on accessing and manipulating large databases Model-Driven DSS Emphasizes simulation and optimization models Knowledge-Driven DSS Uses expert knowledge and AI rules Document-Driven DSS Manages unstructured documents and text Communication-Driven DSS Supports 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
- Improves the speed and quality of decisions
- Supports complex problem solving
- Enables what-if and sensitivity analysis
- Provides data visualization for better understanding
- Integrates multiple data sources
- Reduces the cost of poor decisions
8. Limitations of DSS Framework
- High development and maintenance cost
- Requires skilled users to operate effectively
- Over-reliance may reduce managerial judgment
- Data quality directly affects decision quality
- May face resistance from users
9. Summary Table
Component Role Example DBMS Stores and retrieves data Oracle, SQL Server MBMS Runs analytical models Forecasting, LP models Knowledge Base Provides expert rules Rule-based inference engine User Interface Interaction with user Dashboard, 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.
- 210 marksDecision Oriented DiagnosisHideAnswer
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):
Phase Description Intelligence Scanning the environment, identifying problems Design Developing and analyzing possible courses of action Choice Selecting the best alternative Implementation Carrying 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
Benefit Explanation Relevance Ensures DSS directly addresses real decision needs User acceptance System is built around actual user behavior and preferences Efficiency Avoids building unnecessary features Effectiveness Improves decision quality by targeting specific gaps Alignment Connects 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.
- 310 marksImplementing Communication-Driven and GrouHideAnswer
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 ...
- 45 marksDecision Support vs. Transaction ProcessinHideAnswer
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...
- 55 marksDSS Project Management and ParticipantsHideAnswer
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...
- 65 marksDecision Support vs. Transaction ProcessinHideAnswer
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...
- 75 marksArchitecture and Components of Expert SystHideAnswer
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...
- 85 marksFuzzy ReasoningHideAnswer
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 ...
- 95 marksOpportunities and IS PlanningHideAnswer
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:
Dimension Description Strategic Impact of Existing Systems How critical are the current IT systems to the organization's operations? Strategic Impact of Future Systems How 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
- Guides IT investment decisions -- helps prioritize where to allocate IT budgets
- Aligns IT with business strategy -- ensures IT supports organizational goals
- Identifies risk -- highlights areas where IT failure could be catastrophic
- Helps in IT governance -- determines the level of management attention required
- 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.
- 105 marksExpert Systems Development Life CycleHideAnswer
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...
- 115 marksTypes of Fuzzy Expert SystemsHideAnswer
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...
- 125 marksPrepare a Feasibility StudyHideAnswer
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...