Please enable JavaScript.

Coggle requires JavaScript to display documents.

Quality of Information (Relevance of information ((Not Relevant …

- - - - Arithmetic
    - - order of text/values
- - - - A check to see if the data is within a certain range.
      - Example: The "Month" section of a Date of Birth entry can only be from 1-12.
      - Example: The ages of Year 5 students can only be entered as a value between 9-11.
    - - A presence check can be used on any field in a database and simply checks that some data has been entered into the field, i.e. that the field has not been left blank. Presence checks are used on important fields which must have data in them
    - - examples : a number data type would be suitable for clothing sizes, which would prevent anyone from entering data such as "ten"
      - a type check will ensure that the correct type of data is entered into that field
      - a date data type will ensure that a date entered actually exists. 31/2/07 would not be possible
    - - A check for determining if the data is in a specific format, this is usually determined by the input mask
        
        E.g. Numbers or letter
    - - The number of characters that must be inputted.
        
        Example
        
        Username must contain at
        least 10 characters
        
        Username:Olivia1234 :check:
        
        Username:Olivia :red_cross:
    - - The method should be used consistently throughout.
      - Example: In a form, when Male is selected in the Gender section, only Mr or Dr may be selected in the Title section.