1. What caused the latest revolution in management use
of computers? List at least two causes.
The increase in the use of computers by managers
stemmed from the availability of personal
computers and the introduction of easy-to-use
The ease of u
Mid-Term Exam I 1
Database Systems and Design (D131)
Dr. Ali El-Bastawiss 1 Hour I
Mketch to show the basic components of a database system
rate 5 of the basic mctions of any DBMS w"
' C) Convert the following Relational Algebra expr
Working with GAMS
Research Computing and Cyberinfrastructure
GAMS in Hammer and LION-X
Command to run GAMS files in Hammer:
gams_input_filename is an ASCII file with GAMS
commands and has an exten
A system is a collection of objects
such as people
, resources ,
concepts and procedures intended
to perform an identifiable function
or to serve a goal(s) .
Its clear that any system is a
subsystem of the super-system
The structure of a system
Modeling and Analysis
Technique for conducting experiments with
a computer on a model of a management
Frequently used DSS tool
The basic idea of simulation is to build an
experimental device (model) that will act
Types of Forecasting Methods
causes of behavior
Indicates how far into the future is
Short- to mid-range forecast
typically encompasses the immediate future
daily up to two years
a line of waiting
customers who require
service from one or more
waiting room + customers
+ service provider
Decision Chapter 3
Working Definition of DSS
A DSS is an interactive, flexible, and adaptable
CBIS, specially developed for supporting the solution
of a non-structured management problem for
improved decision making. It util
Managerial Decision Making and
a process by which organizational goals are
achieved through the use of resources
Goal Attainment: Output
A shipment plane has three rooms for storing cargo: front, centre and rear. These
rooms have the following limits on both weight and space:
Weight capacity (tonnes)
Space capacity (cubic metres)
 Hospital Employment
We have 3 hospitals A, B and C and we want to know how many
doctors to employ in each hospital. We target to minimize the total
wages that will be paid for these doctors (per day) given that each
doctor will be paid per day 200 $ i
1. Define a system.
A collection of people, resources, concepts, and procedures intended to perform an
identifiable function or serve a goal.
2. List the major components of a system.
Inputs, processes, outputs, and connecting interfaces. The sy
QUESTIONS FOR REVIEW
1. List the major components of DSS and briefly define each of them.
The major components are:
o Data management; includes a database and its management system.
o Model management; includes models and their management system.
Faculty of Computers and Information
Department of Decision Support
Academic Year: 2010/2011
Decision Support System Project
You are required to implement a complete DSS, with a data base, model base and a user friendly
output to generate
Assignment for Lecture 1
Most managers use computers by themselves to support their
The intent of DSS is to replace the decision maker.
Productivity measures efficiency.