Databases

1. - Used to enter a new record, modify an existing record and view records already stored in a table.
3. - Allows tables and results of queries to be presented in a user friendly way.
4. - represented as a row in a table.
7. - Carried out by a computer automatically when data is input. It ensures that data is reasonable, sensible and within acceptable limits.
9. - A type of validation check that ensures data matches a predetermined pattern e.g. DD/MM/YYYY
11. - Language used to write queries using SELECT, FROM and WHERE statements.
12. - data which is repeated.
14. - consists of a number of records.
15. - Used to search and extract data from a database to find the answer to a question.
16. - A type of validation check that ensures data is of the correct type e.g. numeric/text.

1. - a type of key which is a link to a primary key in another table.
2. - A small program written to perform a repetitive task automatically.
5. - a link between two or more tables
6. - A part of a record that stores a single data item, represented by a column.
8. key - uniquely identifies one record.
10. - a type of validation check that ensures data is within a lower and upper limit
13. - A type of check that ensures data is entered - the field cannot be left blank.