Fichas
Topic 8 Flashcards
Fichas del conjunto (23)
- 1Data Types Number (Integer)A whole number (positive or negative) but no fractions E.g. 43
- 2Data Types Number (real)Any number, including whole numbers and fractions E.g. 435.26
- 3Data Types Text or StringLetters, numbers or other characters such as punctuation marks E.g. John Smith
- 4Data Types Date/ TimeAny time or date; the way the time or date is displayed depends on how it is formatted E.g. 04/10/12, 12:15:45
- 5Data Types CurrencyMoney £ (including foreign currency $)
E.g. £13.55 - 6Data Types BooleanTwo opposing states E.g. Yes
- 7Data Types ListsA list of values, Only data from the list can be selected E.g. Red, Blue
- 8Data Types PictureImage data, from a camera, mobile, the internet E.g. A picture
- 9Data Types SoundA beep from a barcode reader/ song E.g. A sound or music clip
- 10Data Types VideoA video introduction to a game/ film E.g. A moving picture
- 11Validation Methods Range CheckChecks that the data entered must be in a sensible range
- 12Validation Methods Type CheckEnsures that the data entered is of the correct type
- 13Validation Checks Format/ Picture CheckChecks that the data entered has a particular pattern
- 14Validation Checks Length CheckChecks the length of the input is correct for the number of characters used
- 15Validation Checks Presence CheckChecks that data has been entered
- 16Validation Checks Look up ListChecks if the data entered can compare with the list of the allowed answers
- 17Simple Query Search - Looks for data in one fieldComplex Query Search - Looks at data with multiple criteria
- 18Operators= Equals
< Less Than
> Greater Than
<> Not Equal to
AND Data where both are true
OR Data where one or more are true
LIKE Where not a perfect match is needed - 19Wildcard Characters* Any number of characters
? Any character
[ ] Any character in the brackets
[-] Any character within a range of characters
! Any character not in the brackets - 20Security Issues with Databases A - If data is secure D - If data is not secureAdvantages
- It cannot be destroyed
- Cannot be altered
- Cannot be wrongly accessed
Disadvantages
- Loss of customers
- Bad Publicity
-Payment for goods not being received - 21Methods used to keep Data securePhysical Security
- Locks on doors
-Alarms
-ID Cards
- Biometric Systems - 22Software methods for keeping Data securePasswords - Method of authentication
Access rights - Meaning no unauthorised individual can access important files
Backups - Made regularly, so if a problem arises the file can still be used - 23Benefits of using a DatabaseFast access to data
Easy to edit the data
Validation methods can be used
Reports can be used to aid decision making
Data can be shared on a network
Security measures can be taken to prevent access
Información
- Descripción
- GCSE ICT Fichas sobre Topic 8 Flashcards, creado por Lindis Dixon el 10/02/2015.
- Creado por
- Lindis Dixon
- Visitas
- 0
- Valoración