null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
110782
DBMS + MIS + DSS
Description
A Level ICT (Unit 3.1) Mind Map on DBMS + MIS + DSS, created by scott.dowle on 05/27/2013.
No tags specified
ict
unit 3.1
ict
unit 3.1
a level
Mind Map by
scott.dowle
, updated more than 1 year ago
More
Less
Created by
scott.dowle
over 11 years ago
125
0
0
Resource summary
DBMS + MIS + DSS
DBMS
3 Main Features
Data Definition Language
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
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
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
MIS
Internal Data
Company Info + Operations
External Data
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
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
Operational
Individuals with responsibility
Day to day operation
Monitor effectiveness of operations
Instructions from supervisors about operational requirements
Effective use of resources
Purpose
Manage and control internal operations
Allow access to relevant data and present it effectively
Access to real-time data
Features
Transform large amounts of raw data
Utilizes data from many sources
Present data in meaningful format
Used at different levels of management
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
3 Components
DBMS
Internal + External data analysed by DDS
Support Tools
User to interact with the system
Model Management System
Takes input + performs calculations to form output (forecast)
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Networks
Will8324
General ICT Quiz
leahshaw
ICT Revison Flash Cards
Arun Johal
FLAT FILE VS RELATIONAL DATABASE
rosiejones
Online World - Learning Aim A
andysedge
Business Aims and ICT Strategies
scrt
User Interfaces
Skeletor
General ICT Quiz
Jade Fantom
Browse Library