Flashcards
Topic 8 - Databases
Cards in this deck (6)
- 1State the type of data for each of the following A) 23 B) Film star C)?@~A) Integer/Number
B) Text/String
C) Text/String - 2Describe ValidationValidation checks to see if the data is sensible & resonable
- 3Identify the type of validation used to check: A) number between 0 and 100 B) Mr, Mrs, Miss, Dr, Rev C) GL19 3ZAA) Range Check
B) List or Lookup
C)Format Check/ Picture Check - 4identify 4 benefits of using a databaseFinding data is much faster than a paper based system
Whenever data needs to be updated it can be easily found
Data in a database can be shared with others on the network
Passwords so no one can read the data - 5Explain what is meant by a wildcard and give an exampleA wildcard is used in a query to stand for any character you do now know exactly
example: ? - 6Number of key fields shown? Give the key field State the purpose of the key field1) 1
2) Unique identity
3) To uniquely Identify people from others.
Information
- Description
- Flashcards on Topic 8 - Databases, created by Abby Debell on 09/02/2015.
- Created by
- Abby Debell
- Views
- 3
- Rating