110782
Description
Mind Map by scott.dowle, updated more than 1 year ago
|
Created by scott.dowle
almost 11 years ago
|
|
DBMS + MIS + DSS
- DBMS
- 3 Main Features
- Data Definition Language
- Allows tables
to be defined by
field names,
data type,
primary key etc
- Allows tables
to be defined by
field names,
data type,
primary key etc
- Data Manipulation Language
- Changing data via
operations such as -
insert, delete, update,
and processing data
- Helped by Queries
- Helped by Queries
- Changing data via
operations such as -
insert, delete, update,
and processing data
- Data Dictionary
- Structure + attributes
of data items used in
database
- Includes names +
descriptions of tables as
well as data types
- Metabdata - database
of the database
- Metabdata - database
of the database
- Structure + attributes
of data items used in
database
- Data Definition Language
- Role of Database
Administrator (DBA)
- Defining/ maintaining/
modifying structure of tables
etc
- Controlling access to database
- Assigning access rights/
usernames + passwords
- Identifying new user query and
report requirements
- Manage/
Maintain
backups
- Ensure
compliance
with legislation
- Defining/ maintaining/
modifying structure of tables
etc
- 3 Main Features
- MIS
- Internal Data
- Company Info + Operations
- Company Info + Operations
- External Data
- Competitors, Population
shifts, Economic + Social
factors, Govt. legislation
- Competitors, Population
shifts, Economic + Social
factors, Govt. legislation
- Levels Of Management
- Strategic
- Chief Executives,
Directors etc.
- Objectives, Long Term
Goals, plan decisions,
make investment decisions
- Requires
- Reports on overall
performance, relative
to past performance
and competitors
- Possible effects of
decisions
- Summary reports
on accounting and
different
departments
- Reports on overall
performance, relative
to past performance
and competitors
- Chief Executives,
Directors etc.
- Tactical
- Heads of
Department,
Supervisors etc.
- Manage budgets,
allocate resources,
monitor progress,
provide info to
managers
- Requires
- Staff
performance
- Requirements
for senior
management
- Available resources
- Staff
performance
- Heads of
Department,
Supervisors etc.
- Operational
- Individuals with
responsibility
- Day to day operation
- Monitor effectiveness of operations
- Instructions from
supervisors about
operational
requirements
- Effective use of resources
- Individuals with
responsibility
- Strategic
- Purpose
- Manage and control internal operations
- Allow access to
relevant data and
present it effectively
- Access to real-time data
- Manage and control internal operations
- Features
- Transform large
amounts of raw data
- Utilizes data from many sources
- Present data in
meaningful
format
- Used at different
levels of
management
- Transform large
amounts of raw data
- Internal Data
- DSS
- Integrated tools
designed to help
problem solving -
such as scheduling
work activities,
resource allocation
and forecasting
- Main Features
- Assist managers
with complex
problems
- Apply different
business models
- May incorporate
Expert system
- Assist decision
making at strategic,
tactical,
operational
- Assist managers
with complex
problems
- 3 Components
- DBMS
- Internal + External data
analysed by DDS
- Internal + External data
analysed by DDS
- Support Tools
- User to interact with the system
- User to interact with the system
- Model
Management
System
- Takes input + performs
calculations to form
output (forecast)
- Takes input + performs
calculations to form
output (forecast)
- DBMS
- Integrated tools
designed to help
problem solving -
such as scheduling
work activities,
resource allocation
and forecasting
Want to create your own Mind Maps for free with GoConqr? Learn more.