DECISION SUPPORT SYSTEM 

Q1. Fill in the blanks

  1. Some amount of ________ is built in to all aspects of the world
  2. Decision ________ is one of the most systematic tools of decision-making theory and practice.
  3. Decision support system can aid human _________ deficiencies.
  4. Management Information System uses more information than _________
  5. Decision Support System improves the ______ of decision
  6. Most of the statistical packages provide facilities for data _________
  7. Decisions are irreversible and have far-reaching consequences for the rest of ______ life.
  8. A data warehouse architecture is a description of the elements and _________ of the warehouse
    9. Click here to join us on Social Media for getting instant update on every notice

Q2. State True or False

  1. Management Support System consists of DSS, Expert System and Executive Information System
  2. Critical Success Factor (CSF) is a popular concept in DSS design
  3. DSS is a subject of computer based Information system
  4. As computer programming evolved over years, it got less complicated and more powerful
  5. Data warehousing system involves high cost
  6. Data clearing attempt to fill in missing values

Data reduction technique is used to obtain reduced representation of the data set.

  1. Excel programming offers a wide range of external data storage capabilities

 

 

Q3. Match the following

                        A                                                                                  B

  1. VBA Language                                                             DSS Tools
  2. Time series analysis                                                             activate Excel
  3. Application Programming Interface                                     unstructured
  4. MIS                                                                         Stream data base
  5. LAN/WAN                                                                         Excel program
  6. Window Task bar                                                             past data
  7. Web-Pages                                                             Middle Manager
  8. Multi-Media data base                                                 Computer hardware

Q4. Expand the following

  1. DDE
  2. MSD
  3. CRM
  4. GDSS
  5. OOP
  6. DWA
  7. OLAP
  8. ETL

                              PART B                    ( 16 x3 = 48 marks)

                                                             ( Answer any three)

Q5. Explain the six steps in decision making process

Q6. How decision tree helps in decision making and practices

Q7. Compare the advantages and disadvantages of EDP, MIS and DSS in terms of various parameters

Q8. Explain the role of DSS and its application in today’s business

Q9. What are the concepts of DSS and show it by a flow diagram

 

Que. 10:                                        SECTION C    (Case Study)             20 marks

A Marketing Decision Support System at Corn Rail

Corn Rail is a non profit corporation started in 1976 by the U.S. administration to revitalize is freight service of 6 bankrupt rail lines. The company operates in a competitive environment mainly against the truck transport and therefore marketing strategies are very important.

The success of Corn Rail depends on pricing Requests for adhoc information by the many decision makers at remote locations must be responded  very fast.

A huge database of historical data (about 5 million records per year, each containing 100 fields of data) is used for information retrieval. To reply to users request means a search for data, sorting, summarization, consolidation, computation, data presentation and data transfer. Most users do not have computer experience and therefore it is necessary to have a user friendly Data Base Management System (DBMS)

In addition to internal data, the DBMS includes industry and other environmental information provided by external data  banks and information about clients and competitors.

Questions

  1. Draw a flow diagram on Corn Rails customer interactive computing software
  2. What are the improvements you may suggest as a software vendor to increase its usage?
  3. What type of training programme would you suggest for the users?
  4. What are the likely savings to the company by interacting this system?

To develop easy person – machine  dialogue, what is your suggestion?