Computing Unit 3 AOS 1

Question 1

What are the aspects of data integrity

Answer 1

Accuracy:
   -Completeness
   -Consistency
   -Clarity
Authenticity
Correctness
Reasonableness
Relevance
Timeliness

Question 2

List All of the Data types and some info about them

Answer 2

Character:
Contains a single Alphanumeric value Like 'S' or 'L'.
Text or String:
Contains a mix up to 255 characters.
Numeric - integer, Floating Point:
only numbers, integer is whole numbers, floating point is decimals.
Numeric - Date:
Numbers of days since 0
Boolean:
true or false, yes or no.
Image:
Sound:

Question 3

List all the design tools for data visualisations

Answer 3

Data Dictionary's:
design data base tables, establishes fields data types, field size and validation
IPO charts:
data structure diagram:
outlines tables and their relationships
Story Board:
How a user with navigate the solution
Website maps:

Question 4

What is a format

Answer 4

It refers to any choice made about the appearance of the solution like number of decimal places.

Question 5

List some conventions of databases, spreadsheets and data visualisations

Answer 5

Titles- should be larger and above the element they are referring to.
Colours and contrast- should be used to make the solution more visible.
Hierarchical design

Question 6

What Are the Data Base Naming conventions?

Answer 6

1. Accurate, Detailed.
2. No Spaces
3. Capitalization for the first letter in each word
4. Common prefixes

Question 7

What is contained within a Data Base Data dictionary?

Answer 7

Field Name | Data Type | Field Size | Format | Caption | Description | Validation Rule | Validation Text |

Question 8

What is an Input Mask

Answer 8

The format an entry has to conform to Eg DD/MM/YY

Question 9

Name the Four types of Validation check

Answer 9

1. Existence check
2. Type check
3. Range check
4. Input Mask

Question 10

What is contained within a Query Design Table?

Answer 10

Field Name | Sort | Filter | Calculation | Other

Question 11

What is contained within a Testing Table

Answer 11

Item Tested | How it was tested | Expected result | Actual Result | How it was fixed

Question 12

List 5 Design principles for Data visualizations

Answer 12

Efficiency
Effectiveness
  -Completeness 
  -White Space
  -Readability 
     -Text
     -Colour
     -Alignment 
Attractiveness
Clarity
Functionality 
Accessibility