Gr 12 4.1 – DATABASE DESIGN AND CONCEPTS

Question 1

Access control

Answer 1

The use of software settings and various technologies (e.g
passwords, encryption codes, biometric security measures)
to control user’s access to data and resources. It also
involves control over physical access to equipment.

Question 2

Logical data integrity

Answer 2

The correctness of data, or data ‘making sense’ in a
particular context.

Question 3

Normalisation

Answer 3

A series of steps followed to ensure that a database is an
optimal state, with no chance of anomalies (irregularities) –
that data is not being repeated and that queries and reports
can be created with ease.

Question 4

Physical data integrity

Answer 4

Overcoming practical issues such as power failures,
mechanical failures, natural disasters, ect. And dealing with
the physical storage and retrieval of data.

Question 5

Purge

Answer 5

Actually, remove deleted records from a database to compact and streamline the file.

Question 6

Rollback

Answer 6

When the DBMS gets the instruction to reverse a transaction
(or series of transactions) and restores the data to its
previous state.

Question 7

Transaction processing system

Answer 7

A software system that captures and processes data from
everyday business activities.