Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

WJEC Computing A2 > Applications of Computer System > Flashcards

Applications of Computer System Flashcards

1
Q

Check Sum

A

An error detection system. The check-sum is calculated by summing all the values in a block of data and including it when the data is stored or transmitted.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Flat File

A

A Flat File refers to a single file used to hold all of the data within a specific problem.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Flat File Problems

A
  • Data redundancy.
  • Data consistency
  • Data integrity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Relational database

A

A relational database is a collection of tables that hold records. The records may be connected through relationships (links).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Data Consistency

A

This deals with ensuring data is accurate and valid.

Problems can arise if data goes out of date, e.g. storing age instead of date of birth.

It can also arise if the same data is stored more than once.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data redundancy

A

Data items are said to be redundant if they are stored more than once. Redundancy can lead to loss of consistency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Data Independence

A

Data being inconsistent in a flat file due to possibility of different formats, etc, and being consistent in a RDBMS as each record is only stored once so cannot have different attributes. A date field could be stored in file as a text field but in another field as a date/time field and the data would be incompatible. In a relational database because the attributes of any one entity are contained within one file, there is no risk of the same attribute being stored in a different format in a different file (Spelling mistakes in names).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Normalizing

A

Normalizing is the process of ensuring that data is correctly organized. There are three tests, called normal forms, which should be applied to the data to ensure that the data is correctly organized.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

1st Normal Form

A

A database is in 1st Normal Form if it has no repeating attributes or group of attributes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

2nd Normal Form

A

A database is in 2nd Normal Form if the non key fields depend on the whole key and not part of it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

3rd Normal Form

A

A database is in 3rd Normal Form if data items are dependent on the (primary) key, the whole (primary) key and nothing but the (primary) key.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Primary Key

A

A primary key uniquely identifies a record in a file. No two records in the file will have the same primary key.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Foreign Key

A

A foreign key forms a relationship from a record in one entity to a record in another entity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

DBMS

A

A Data Base Management System is responsible for managing, storing, retrieving data, in a database, for other applications to use.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

View

A

A view is the name given to the part of the data structure that can be seen by a particular use or application.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Transaction Support

A

A transaction is a sequence of events that must be carried out either completely or not at all. If the transactions fails then all of the steps carried out must be reversed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Concurrency Support

A

This DBMS functions enables many user processes to access a database at the same time. In Particular, when user processes involve transactions that update the same data, a DBMS must perform at he updates in a way that prevents them interfering with each other. For example record locking.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Database Security

A

It covers:
- Making sure each user has access only to what they need to do their job.

  • Ensuring data is not lost through hardware or software failures.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Preventing Loss of Data is managed by:

A
  • Time back-ups

- Log/transaction files.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Query Languages

A

A query language is a (simple) language that allows data to be extracted from a database.

Example: SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

SQL

A

Structured query language. A 4GL used to define, interrogate and manage databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Data dictionary

A

A data dictionary is a document that describes each table (file) in the database, each field in terms of data type and validation, and identifies primary and foreign keys.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Database Administrator

A

The database administrator manages the structure of and access to the data in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Recovery

A

Restoring a computer system after failure. Possibly by copying files from a backup to the working store.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Distributed Systems

A

Distributed systems refer to the use of more than one computer in order to store or process data. This generally takes place behind the scenes so the user is not aware that more than one computer is being used.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Distributed Processing

A

Distributed Processing is the sharing of the processing requirements by using many computers accessed across a network. (It’s a form of parallel processing)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Distributed Processing Problems:

A
  • Speed of data transfer.

- Not suitable for all tasks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Distributed Database

A

A distributed database is one where several computers on a network each hold part of the data and cooperate to make it available to a user.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Distributed Database Benefit

A

It is to make the data as close as possible to the user to reduce network traffic and to speed up data transfer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Distributed Database drawback

A

It is difficult to ensure that all the data in all the computers is always up-to-date/maintain integrity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Data Warehousing

A

Data Warehousing is the accumulation of data possibly from several sources, for future processing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

Data Mining

A

Data Mining is the analysis of large amounts of data in a data warehouse to provide new information. The analysis will try to find statistically significant correlations or trends in the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Uses of data mining (supermarket)

A
  • To identify unexpected shopping patterns in supermarkets.
  • Optimize website profitability by making appropriate offers to each visitor.
  • Identify suspicious (unusual) behavior, as part of a fraud detection process.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

Uses of data mining (Insurance companies)

A
  • Spot and understand trends in claims.
  • Identify high risk customers.
  • Identify customers who may not renew policy (so they can be targeted).
  • Predict and detect fraudulent or risky behavior.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

Problems of Data Mining

A
  • Concerns over access to personal data.

- People being refused services e.g. insurance based on age, post code.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

Data security

A

Refers to making sure data is not lost.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

Bio-metric Security

A

Identifying users by measuring some aspect of the body eg Fingerprints/iris/retina/voice.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Process of bio-metric security

A

Take fingerprint and register on a database.
To log on - take finger print and compare it with stored prints.
If they match then let the user in.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Indexed Sequential File

A

An indexed sequential file is a sequential file (records are in key order). An index allows direct access to any particular record if the key is known.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

Advantages of Indexed sequential file

A
  • Rapid search since the index is in RAM.

- Key might be of different size if it’s variable length record.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

Multi-Level Index

A

A file, which is fully indexed, where the index is so large it also has an index .

The high-level index contains the block in the low level index where the record key is to be found.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

How can file become corrupted?

A
  • Hacking - deliberate damage.
  • Physical damage to hard disk.
  • System error.
  • Virus.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Full Backup

A

At regular intervals a copy of the file is made and kept secure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

Incremental Backup

A

An incremental backup is a type of backup that only copies files that have changed since the last backup.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

Incremental Backup - Advantages

A
  • Less storage needed.
  • More often - less data lost.
  • Faster.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

File Generations

A

File generation refer to the successive backup copies made of a file that frequently change. Father, Grand father, son.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
47
Q

Transaction Log

A

A full backup is made then a log of all changes is recorded. This means that the database can be restored up to the point at which it was corrupted.

48
Q

Backup Problems

A

The files have to not be used whilst the full backup takes place otherwise there could be inconsistencies. And most organisations want their system running 24 hours a day.

49
Q

Mirroring

A

Mirroring stores identical data in more than one place. There are two identical copies of the database.

50
Q

Mirroring protects against

A

Physical damage to hardware.

51
Q

File Archiving

A

An archive is a set of files that are no longer regularly needed but are kept, securely on a separate storage system, for legal or financial reasons.

52
Q

Why is it insufficient to keep all of this data on line?

A

It would cause the main system to get bigger, causing it to slow down.

Backups would increase in size and take longer to be created as well.

53
Q

File encryption

A

Encryption is a security measure that makes the contents of a file unreadable without a key.

54
Q

One way encryption

A

Using a non reversible algorithm to scrabble data.

used for encrypting passwords.

55
Q

Reversible encryption

A

Using algorithm to scrabble data wist it is transferred or stored. On retrieval the data scrabbling is reversed.

Used for: Encrypting files before transmission, encrypting files for storage.

56
Q

Public key encryption

A

An encryption system using two matching keys, the public key that is used to encrypt and the private key that is used to decrypt.

57
Q

Compression

A

The process of reducing a file size without losing information (non lossy compression) or without losing important information (lossy compression).

58
Q

Compression - Advantage

A

It reduces the time taken to transmit data and means that storage requirements are less.

59
Q

Lousy Compression

A

Image, sound, video

60
Q

Non Lousy

A

Everything else (that’s not image, sound and video)

61
Q

Image Compression

A

Reducing the amount of storage needed to represent an image. May be lossy or non loss.

62
Q

JPeg

A

JPeg is a standard which allows images to be compressed. Small errors in image are acceptable. Images can be compressed to a higher level if some errors are allowed. The amounts of compression can be controlled to allow a choice between high levels of compression or high accuracy.

63
Q

Mpeg

A

MPeg is a standard which allows compression of moving images. It allows some errors to enable greater compression. Since successive frames are often similar only the changes from one frame to the next need to be stored.

64
Q

MP3

A

A lossy form of compression used for sound.

65
Q

Safety Critical Systems

A

Safety critical systems are ones that would put human life at risk if they were to fail.

66
Q

Safety Critical Systems - Examples

A
  • Air traffic control.
  • Traffic lights.
  • Railway control.
  • Power supply control.
  • Vehicle engine management.
67
Q

Techniques used to make sure Safety critical system keeps working

A

Using CASE tools where possible - Reduces human error in coding.

Careful Design - Design Validation, using design Tools (UML).

Full and through Testing:

  • Test components.
  • Test full system.
  • Soak testing.

Hardware Redundancy - Duplicating hardware.

Alternate Power Supplies - Uninterruptable power supply.

Staff Training - To avoid errors.

Fail Safe - If a system fails it is put in to safe state.

68
Q

Weather Forecasting

A

Weather forecasting is achieved by modelling the earth’s atmosphere, predicting how it will change in the future

69
Q

Weather Forecasting - Super Computer

A
  • Large amounts of data is inputted from variety of sources.
  • It must be processed rapidly, since out of date forecasts are of no use.
  • Calculations are complex, since weather is unstable/hard to predict.
  • The greater the processing power the greater the accuracy.
  • May require good graphics for visual representation.
  • Comparisons need to be made with large amounts of historical data.
70
Q

Weather Forecasting - Super computers are needed because

A
  • The model must run faster than real time.

- The faster the computer the smaller the cubes used to model the atmosphere can be leading to more accurate forecasts.

71
Q

Weather Forecasting - data is gathered by

A
  • Land based stations
  • Balloons.
  • Aircraft
  • Satellites.
72
Q

Weather Forecasting - Data quality

A

Data is rejected if it fails quality control - the data need to be:

  • Within Range.
  • Consistent with neighboring observations.
  • Consistent with trends.
73
Q

CAD

A

Computer Aided Design refers to using computers to create designs plans for objects from engines, to furniture to buildings.

74
Q

CAD - Features

A
  • High Accuracy
  • Automated dimensions
  • Geometric constructions e.g. right angles, parallels.
  • Calculation of areas, volumes, etc.
  • Creation of parts list.
  • Determine stresses on the components.
  • Libraries of standard components e.g. bolts, bricks.
75
Q

CAD - Results might be used for

A
  • Producing constructions plans.
  • Stress testing.
  • Animating moving components to check function.
76
Q

CAD- High power computers are needed because

A
  • Interactivity/Animation is needed.
  • Working in 3D requires many calculations.
  • A product may be made of thousands of sub components.
77
Q

CAM (Computer aided manufacture)

A

Computer aided manufacture is the use of computer controlled manufacturing machines, lathes, milling machines and robots. Ideally the results from the design process CAD are sent directly to the manufacturing machines.

78
Q

CIM (Computer Integrated Manufacturing)

A

CIM refers to having integrated computer system that cover dealing with customer orders, creating or modifying designs, ordering raw materials and components, manufacturing, assemble and invoicing.

79
Q

Animation

A

A sequence of still images shown in succession to create the illusion of moving images.

80
Q

CGI

A

Computer Generated Imagery. used for adding realistic images to motion picture films.

81
Q

Bit map

A

An image represented by dots called pixels.

82
Q

Pixel

A

A picture element. In a bit mapped image the pixel is the smallest component.

83
Q

Control

A

Control refers to the use of a computer to automate some physical process such as controlling a washing machine, traffic lights or a driver-less for lift (used in warehouses).
All control systems must have some way of sensing what is happening in the world.

84
Q

Sensors

A

Sensors convert some physical measurements (temperature, pressure, direction ,light level etc) into an electrical signal. Many sensors are analogue devices, some, those that detect the presence or absence of something, are digital.
Analogue sensors will not be totally accurate.

85
Q

Actuators

A

An actuator is a device that converts an electrical signal into movement. Actuator allows a computer to open and close valve, to raise and lower a barrier, etc.

86
Q

Feedback

A

Feedback is the use of data from sensors as an input to controlling program. The result of the previous action becomes the input which contributes to selecting the next action.

87
Q

Overall Control

A

All control system make use of feedback. Data coming from sensors is processed, the computer makes a decision about what needs to change, the computer makes changes by using actuators, this has some effect on the world, the sensors detect this effect and the cycle repeats. Infinite loop.

88
Q

Chemical Simulators

A

Software that mathematically models the behavior of a chemical reactions.

89
Q

Aircraft control

A

There is a computer between the cockpit controls and the flying surfaces. The pilot gives instruction to the computer, which sends a message to the flying surfaces.

90
Q

Aircraft control - Affect

A
  • The computer can monitor the progress and ensure setting are achieved and maintained.
  • The computer can override dangerous commands.
  • The replacement of physical links by wiring reduces weight.
  • Since stressful motions can be eliminated the aircraft need not be so strong, saves weight and fuel.
  • The plane can be flown (and landed) by the auto pilot more easily than a conventional plane.
  • This may mean that if the computer system fails (software or hardware) then the pilot may have little or no control over the plane.
91
Q

Aircraft control- Automated take off and landing

A
  • Can take off and land in poor visibility.
  • Less delays
  • Less diversions
  • Saving fuel
92
Q

Aircraft control - Advantages

A
  • More efficient
  • Fuel economical
  • More maneuverable
  • Pilot-less plane
93
Q

Fly by wire

A

An aircraft where the controls are operated by a computer. The pilot gives instructions to the computer.

94
Q

Robotics

A

A robot is any computer controlled device that can be programmed to carry out a variety of complex tasks that mimic human activity.

95
Q

Robotics - Remote Control EXAMPLES

A
  • Bomb Disposal robots are remotely controlled.
  • Laparoscopic surgery robots enter the body and are remotely controlled to perform surgery without making a large incision.
  • Ophthalmic robots can be used in eye surgery where a surgeon controls a very small, accurate robotic arm.
96
Q

Robotics - Domestic EXAMPLES

A

Designed to perform laborious tasks.

  • Vacuum cleaning.
  • Lawn mowing.
  • Care for the elderly (in development)
97
Q

Robotics - Advantages

A
  • Robotic systems can be used where it is hazardous for or inaccessible to humans.
  • Cheaper to run in the long term.
  • 24 hours operation.
  • More Consistent than human.
  • Don’t get tired/ill.
  • Can work more quickly than human.
  • Factory can run without heating/lighting
98
Q

Robotics - Disadvantages

A
  • Unemployment - assembly work.
  • Public acceptance - Safety.
  • Lack of common sense.
  • Can’t adapt in changes (for example factory on fire).
  • Won’t notice obvious/repeated errors.
  • May require the factory to be rebuilt.
  • Difficult to set to do a new task.
99
Q

Expert Systems

A

Expert systems consist of facts, rules and inference engine (explains the reason).

100
Q

Expert Systems - Aim

A

To produce a knowledge base that can be used in the same way that an expect can to make judgement and to make diagnoses.

101
Q

Expert Systems - Why are they required

A
  • Save time of human expert
  • Greater availability - shortage of human experts.
  • Low running costs.
  • 24 Hour operation.
  • Consistent.
  • Not make mistakes.
  • Human experts die.
102
Q

Expert Systems - Medicine

A

General diagnostics to allow nurse to screen patients and pass on potentially serious problems to doctor.

103
Q

Expert Systems - Finance

A

To determine the way in which share prices will fluctuate.

To predict company performance from company statistics.

104
Q

Expert Systems - Production

A

Find an expert.

  1. REPEAT
  2. Extract the knowledge. The rules used for deduction. The intuition/feelings of the expert.
  3. Placing the knowledge into a knowledge base.
  4. Testing by comparing machine outcome with decisions made by expert.
  5. UNTIL satisfied with response.
105
Q

Expert System - package

A

There are many commercial expert system packages, they are often similar to Prolog and they are usually simple for the end user. They are also comparatively inexpensive but taught Expert Systems are very expensive and often commercially protected.

106
Q

Expert System - Operation.

A

It must be able to explain the way in which it achieved the result. It must explain its reasoning process and how it has arrived at its conclusions.

107
Q

Neural Nets

A

A computer based on the structure of a brain.

108
Q

Pairty Bit

A

An extra bit added to a byte of data in order to detect error in data transmission.

109
Q

Version Control - Types of Versions

A
  • Beta Versions.
  • Release candidates.
  • Full release (shrink wrap) version.
  • Bug Fixes.
  • Updates.
110
Q

Threats to Computer systems

A
  • Hardware failure
  • Software failure
  • Accidental operator error
  • Deliberate Operator damage
  • Hacking
  • Virus/Trojan Horse
  • Catastrophic failure (fire/explosion/flood)
111
Q

Firewalls

A

A firewall is a piece of hardware (or software) that sits between an organisation and the internet. The purpose of a firewall is to protect the organisation network from external unauthorized access.

112
Q

Disaster Recovery - Risk Analysis

A

What possible things may go wrong and an estimate of their likelihood.

113
Q

Disaster Recovery - Preventive measures

A

What measures are in place to avoid disaster e.g. duplicate hardware

114
Q

Disaster Recovery - Staff training

A

The staff training that is needed to allow staff to operate when a disaster occurs.

115
Q

Disaster Recovery - Recovery procedures

A

What steps need to be taken to recover from a particular disaster.

116
Q

Disaster Recovery - Possible strategies

A
  • Transferring processing to a computer bureau or to a different branch.
  • Daily off site backups
  • Manual procedures in case of system failure.

Any plan needs to be tested to make sure it is effective, updated regularly and staff are trained.

WJEC Computing A2 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions