Chapter 1

Question 1

Bench Test

Answer 1

A check that determines how a solution would behave with a range of data. The intention is to predict how the solution will treat the sample data.

Question 2

Cookie

Answer 2

A small file that a web server stores on a users computer containing data about the user and web viewing preferences.

Question 3

Data Acquisition Software

Answer 3

Program designed to create an online user form and then assist in retrieving and storing that data

Question 4

Data Integrity

Answer 4

TARA - Timeliness, Authenticity, Relevancy, Accuracy

Question 5

Effectiveness

Answer 5

COME BACK TO ME

Question 6

Efficiency

Answer 6

Time, Cost, Effort

Question 7

Entity Relation Diagram

Answer 7

A diagram that shows the interrelationships between difference entities and their attributes

Question 8

First normal form (1NF)

Answer 8

A table with no repeating groups; no single row has a column containing more than one value

Question 9

Flat File

Answer 9

A database that stores data in tables consisting of rows and columns; AKA Single table database

Question 10

Foreign Key

Answer 10

A common linking field, a field defined as a primary key in another table that is used to link tables together.

Question 11

Hasing

Answer 11

A method of encryption of data

Question 12

HTTPS

Answer 12

Hyper Text Transfer Protocol Secure; A combination of SSL and HTTP

Question 13

Input Mask

Answer 13

A control applied to how data is entered; it restricts entry of data to the specified format

Question 14

Machine Validation

Answer 14

Database validation tools to detect inputed values that are not following the validation rule

Question 15

Malware

Answer 15

A program designed to have undesirable or harmful effects

Question 16

Manual Validation

Answer 16

Inspecting the data to check for any mistakes

Question 17

Normalisation

Answer 17

Removing redundant data and arranging it into appropriate tables to improve data integrity and reduce redundancy; follows a set of rules to check for non normalised data.

Question 18

Primary Key

Answer 18

Uniquely identifies a record in a table/database

Question 19

Privacy Policy

Answer 19

A document stating Why the organisation is collecting data, The purpose of the data/what they will use it for, How it will be stored

Question 20

Query

Answer 20

Select specific data based on a series of criteria

Question 21

RDBMS

Answer 21

Relation Database Management System; Database with linking tables

Question 22

Second normal form (2NF)

Answer 22

Any column that is not part of the primary key is dependent on the whole primary key (????? Come back to me)

Question 23

SSL

Answer 23

Secure Socket Layer; provide security in the transmission of data

Question 24

Spyware

Answer 24

Discretely installed, collects data about the user and can change settings

Question 25

Task Completeness

Answer 25

A solutions ability to support all of the tasks a user wants to perform, in the way they expect

Question 26

Third normal form (3NF)

Answer 26

Come back to me????

Question 27

User Flow Diagram

Answer 27

A chart that shows the steps a user takes to complete a transaction such as purchase or sign up on a website

Question 28

Validation

Answer 28

Checking the data on input it is used for Existence Checking, Range Checking, Data-type checking

Question 29

Validation Rule

Answer 29

A rule that restricts data entry to only that of which follows or meets the validation criteria