Databases

123456789101112131415161718
Across
  1. 3. when a key field appears in another table
  2. 4. Ensures data entered is sensible, reasonable and acceptable
  3. 7. Forces the user to enter a postcode as LL000LL
  4. 8. A database object used to present data in a professional manner.
  5. 10. The type of validation which would ensure the % entered is between 0 and 100.
  6. 13. When two fields are joined together.
  7. 15. an individual data item e.g. name
  8. 16. Forces the user to enter a date in the format DD/MM/YYYY
  9. 18. A database object used to search for data which meets specific criteria.
Down
  1. 1. A data type that would be suitable for DOB
  2. 2. A type of validation which means fields cannot be left blank.
  3. 5. A phone number must contain 11 digits. What type of validation would ensure this?
  4. 6. The data type used to store monetary values e.g. £10.99
  5. 9. Stores data about an object/person e.g., student, book, car
  6. 11. Uniquely identifies a record.
  7. 12. Stores data items about a person, object etc.
  8. 14. A program used to carry out a number of tasks/instructions at click of a button.
  9. 16. An object use to enter data/records or view existing data.
  10. 17. A data type which can contain a combination of letters and numbers