Chapter 5 : Decision Support System

Question 1

What are 3 components of a decision support system ?

Answer 1

• Data management, model management and dialogue management

Question 2

What are 3 type of situation?

Answer 2

Structured ,semi-structured or unstructured situations

Question 3

1 example of structure , semi - structure and unstructure situation

Answer 3

• Structure situation , Eg: Home loan calculator
• Semi- structure situation , Eg : Bank loan approval for customers
• Substructure situation, Eg: Predicting stock prices, Betting, weather forecast

Question 4

4 Types of Decision Support System

Answer 4

• Spreadsheets
• Databases
• Expert system
• Neural network

Question 5

What involve in designing spreadsheeets?

Answer 5

• Involves creating a pen and paper model,identifying data sources,planning the user interface and developing the formulas to be used.

Question 6

What is absolute and relative referencing?

Answer 6

• Absolute referencing is the formula is copied exactly, with the cell references remaining the same , use symbol ‘$’
• Relative referencing , the mathematical processes, such as the operators and functions, are copied but the cell references change so that they relate to the destination

Question 7

What is knowledge base?

Answer 7

• Knowledge base is a set of general facts and if-then rules supplied by an expert.

Question 8

What is Database of facts?

Answer 8

• The database of facts is data entered by user , information received.

Question 9

What is Inference Engine?

Answer 9

The reasoning part within the expert system using information and rule to determine what question to ask next.

Question 10

What is Explanation mechanism?

Answer 10

Draw conclusion to questions asked

Question 11

What are 2 main type of inference engine?

Answer 11

• Forward chaining: Wait until all question is answered by user then draw conclusion.
• Backward chaining: Ask for the conclusion and draw back to evidence base on the answer

Question 12

What is fuzzy logic

Answer 12

Is to describe a variables that can be true or false, which is certainly to determine how certain someting is base on certainty value
- (Eg from 0 to 1, 0 is not certain and 1 is certain, between is determine how close to certain or not .)

Question 13

What is macro?

Answer 13

Quick command tool to copy and paste using a key .

Question 14

What is pivot table?

Answer 14

Is an interactive table that quickly summarises large amounts of data

Question 15

What are 4 common type of chart ?

Answer 15

• Bar chart
• Column chart
• Line chart
• Pie chart

Question 16

What are some issues relate to Decision support system?

Answer 16

• Intelligent system (AI)
• Preserving expert’s knowledge
• Improve performance and consistency
• Make rapid decision
• Analysing unstructured situations