Term 1

Question 1

integrity terms

Answer 1

Accuracy, authenticity, correctness, reasonableness, relevance, timeliness

Question 2

types of testing

Answer 2

formal (benchmarking), technical (testing as you go)

Question 3

effectiveness terms

Answer 3

accuracy, accessibility, clarity, attractiveness, communication of message, completeness, readability, timeliness, usability

Question 4

efficiency

Answer 4

time, cost, effort

Question 5

4 types of relational databases

Answer 5

one to one, one to many, many to one, many to many

Question 6

data types

Answer 6

Boolean, numeric, text

Question 7

forms of data validation

Answer 7

existence checks, type checks, range checks

Question 8

use of data validation

Answer 8

to check for the completeness and reasonableness of data

Question 9

primary key

Answer 9

unique identifier

Question 10

foreign key

Answer 10

a unique identifier in another table

Question 11

flat file

Question 12

use of verification

Answer 12

checks that data entry matches source data (proofreading, confirming data against other sources and checking that data visualised is consistent with the data acquired)

Question 13

use of queries

Answer 13

to retrieve, manipulate, delete or add data to a database