A2 CCEA ICT Revision Cards

Main features of a relational database

Data consistency

Data inconsistency

Data independence

Data integrity

Data redundancy

Flat file

Disadvantages of flat file

Purpose of normalisation

Normalisation

Advantages of normalisation

Primary Key / Key attribute

A composite key

A foreign key

Entity

ER Model

DBMS

Role of the database administrator (DBA);

Facilities provided by a DBMS for end users

How does the DBMS improve the quality of the organisation’s information

Strategic Decision Making

Tactical Decision Making

Operational Decision Making

Internal sources of information

External sources of information

Purpose of MIS

Features of MIS

Advantages of MIS

Disadvantages of MIS

Expert System

How is Expert System constructed

Expert system
Advantages

Expert system
Disadvantages

Decision Support System (DSS)
Definition

Decision Support System (DSS)
Features

Decision Support Systems
Advantages

Decision Support Systems
Disadvantages

Potential threats to the security of data

Disaster Recovery Planning

Backup and Recovery strategies
Real time

Backup and Recovery strategies
Every month / Batch:

Client server

Client server
Advantages

Client server
Disadvantages

Peer to peer network

Peer to peer network
Advantages

Peer to peer network
Disadvantages

Distributed database
Features

Advantages of distributed database

Disadvantages of distributed database

Centralised database
Features

Centralised database
Advantages

Centralised database
Disadvantages

Wireless Communication
Advantages

Wireless Communication
Disadvantages

Mobile technology

Need for communication standards

Open Systems Interconnection (OSI)

Checksum

Echo checking

Parity bits

Firewall

Access rights

Username and password

Data encryption

Accounting software

Auditing software

RAD
Rapid Application Development

Waterfall life cycle method

Role of the end user in waterfall method

Prototyping

Role of the ICT developer in system development

Role of the End User in system development

Need for documentation

Technical Documentation - contents

User Documentation- contents

CASE Tools
Graphics / modelling tool

CASE Tools
Project management tool

CASE Tools
Code generator

CASE Tools
Data dictionary generator

CASE Tools
Interface generating tool

Custom built / in house development

Custom built / in house development
Advantages

Custom built / in house development
Disadvantages

Off the shelf

Off the shelf
Advantages

Off the shelf
Disadvantages

Outsourcing

Outsourcing
Advantages

Outsourcing
Disadvantages

Alpha testing

Beta testing

Acceptance testing

Processes of review and software maintenance

Features of a well designed HCI
(human computer interaction)

Purpose of user interface

Command line

Command line
Key Terms

Form driven

Natural language

GUI

How a GUI assists experienced users

Dialogue

Psychological factors which influence human interaction
with a computer system

Support available to the user of an information system:
User guides

Advantages of electronic user guide over printed manual

User guide - Contents

Help Desk

User group

The use of ICT based resources for training and re- skilling of employees
Online course

The use of ICT based resources for training and re- skilling of employees
Interactive DVD

Video conferencing

Advantages of
Video conferencing

Computer Misuse Act

Data Protection Act

Limitations of the Data Protection Act

Role of Data Controller

Rights of the Data Subject

Copyright, Designs and Patents Act

The Health and Safety at Work Act

Implications of ICT legislation for an organisation, its employees and
members of the public

Eyestrain
Can be minimised by:

Repetitive Strain Injury (RSI)

Carpal tunnel syndrome

Backache

social, moral and ethical issues from the point of view of the
professional arising from the use of ICT

Acceptable use policy

moral and ethical implications of ICT in relation to professional bodies
British Computer Society (BCS)

Benefits of BCS

moral and ethical implications of ICT in relation to professional bodies
Association for Computing Machinery (ACM)

Benefits of ACM

Disadvantages of belonging to a professional body

Impact of the increasing use of ICT in the Service sector

Impact of the increasing use of ICT in the Manufacturing sector

Use of ICT on the employee:
Teleworking

Use of ICT on the employee:
Teleworking advantages for employees

Use of ICT on the employee:
Teleworking advantages

Disadvantages of teleworking