Data Bases Information Flashcards
(17 cards)
What is a Database?
A database is a persistent organised store of data on a computer system.
What are the four data types?
Text
Number
Data/Time
Boolean (True or False)
What is meant by the Presence test?
A test by the program to check if there is a answer inputted from the user (required field)
What is meant by the Format check?
A check to see if the data that was inputted from the user was of the right format. E.g. if the field required a date of birth, then the input should be numbers
What is meant by the Type Check?
A check to confirm the data is the right type. Entering the answer as 3 rather than three.
What is meant by the Range Check?
A check to confirm the data fits between a lower and higher limit
Name an example of the Format Check.
The data for a postcode should take the pattern LLNNLL L = Letter and N = Number.
Name an example of the Type Check.
If the question was “How many children do you have?”, the program would expect “3” as a answer rather than “Three”
Name a example of the Range Check.
If the question was “How many children do you have?” There would be a limit of around 20, any more this may not true, a real representation.
What are the four advantages of using Databases?
Safe Backed up Protected Availability Kept up to Date No data redundancy
What measures are taken to secure data security?
Access levels for different users
Back ups
Passwords
Audit files/log files
What is meant by validation?
Validation is process of checking data when it has been inputted from the user. It is carried out by software not humans.
What is meant by verification?
Verification is checking that the data is correct, checking to data inputs to confirm it is correct.
When would you expect to have a verification check online?
When changing your password you will be asked to input it in twice to confirm it is correct and that you have not made a mistake/type-o.
State 2 advantages of using databases over storing the data in a file on paper.
More secure
No redundant data
More accessible
Kept up to date
How can data not be safe?
Fire or Flood catastrophe
Accidental deletion of data
Malicious action, by an intruder.
What is data in a database at risk of?
Errors (We're all human) Loss of data Insufficient data Inconsistency Unauthorised access
