Flashcards
Topic 8 flash cards
Cards in this deck (20)
- 1State the data type for each of the following: a) 23 b) Film Star c) ?@) d) 14.23 (4 marks)a) integer
b) string
c) string
d) Real number - 2Describe Validation (1 mark)Validation checks to see that data being entered is sensible and reasonable
- 3Identify the type of validation used to check: a) Number between 0 and 100 b) Mr, Miss, Mrs, Dr, Rev c) GL19 3ZA (3 marks)a) Range check
b) Lookup or list
c) Format check - 4Identify four benefits of using a database ( 4 marks)-Find data quicker as you can query a database
-Validate fields so mistakes are less likely
-Easily change and alter records
-Automatic, ready to print reports - 5Explain what is meant by a wildcard and give an example ( 2 marks)A wildcard is used in a query to stand for any character you do not know exactly. For example * or ?
- 6Describe one benefit of encoding (1 mark)Saves memory
- 7Define a key field (1 mark)A key which uniquely identifies each individual record
- 8Describe using example two advantages to a club of using a computer to store the membership data (4 marks)-you can search for a member by querying the database so you can easily update a record
-You can use mail merge to quickly enter address data for a letter with upcoming dates - 9Suggest the most suitable data type for cost ( 1 mark)Currency
- 10Give one advantage of having fixed field lengths ( 1 mark)Faster to process
- 11Explain the difference between searching and sorting data (2 marks)-Searching means locating specific information using a query
-Sorting means putting all the data into a certain order - 12Explain why a surname would be an unsuitable key field (1 mark)-surnames is not unique as there are two people with the same surname
- 13Explain what is meant by a report (1 mark)-Reports are used to present the specific outputs from an information handling system usually on a print out paper
- 14Explain what is meant by data integrity (1 mark)-The correctness of the data is sorted
- 15Describe one way data integrity is improved by the use of a database (2 marks)-ensure that errors are not introduced when data is
-use validation techniques - 16Define a Database (1 mark)A database is a collection of related data or information that is held together in an organised and in a logical way
- 17Define a record (1 Mark)Consists of a collection of related field, e.g a row
- 18Define a field (1 Mark)Single item of data within a record
- 19Define a table (1 Mark)A collection of related records
- 20Describe four advantages of using an online database over a paper database (4 Marks)-An online database can hold a vast amount of information whereas a paper based form has limited storage
-It is very fast to find a specific record instead of searching manually
-Can easily search for a specific criteria
-Can be easily backed up
Information
- Description
- Flashcards on Topic 8 flash cards, created by jeror001 on 04/02/2015.
- Created by
- jeror001
- Views
- 1
- Rating