AOS 1 SAC 1 study

Question 1

What Are the Data Base Naming conventions?

Answer 1

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

Question 2

What is contained within a Data Base Data dictionary?

Answer 2

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

Question 3

What is an Input Mask

Answer 3

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

Question 4

Name the Four types of Validation check

Answer 4

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

Question 5

What is contained within a Query Design Table?

Answer 5

Field Name | Sort | Filter | Calculation | Other

Question 6

What is contained within a Testing Table

Answer 6

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

Question 7

List 5 Design principles for Data visualizations

Answer 7

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