Name___________________ Databases Practice Task 1. (a) Give 2 advantages of storing records electronically than in filing cabinets? (2) (b) Give 3 examples of database being used in real life? (3) (c) Which GPP package do we use for creating databases? (1) 2. A part of the DVLA database can be seen below. (a) Give 1 example of a Record (1) (b) Give 1 example of a Field (1) (c) What is a Data File? (1) (d) Give 2 field types that could be used in the database (2) (e) Another driver is added to the database. List the correct order of the steps. Enter steps 1 – 4 in the correct boxes Close the DVLA Database File Open the DVLA Database File Enter the new Data Print the Database (f) The manager wants a printout of all the drivers who have 6 months left on their Road Tax. How could this be done? (explain the search) (3) (f) The manager wants a printout of all the drivers who have had their license for more than 5 years and more than 6 penalty points on their license. How could this be done? (explain the search) (6) (c) What would be the best “Field Type” for each of the fields (2) Field Name Field Type Forename Surname Date of Birth Bank Balance Sort Code (d) It would be beneficial if the bank could organise the records in alphabetical order of surname. How could this be done? (3)
"Database Practice Questions"