A451 Topic 5 Databases

4. A field in a table that allows each record to be uniquely identified.
5. The process which ensures that data accepted for processing is sensible and reasonable
6. Checks if the data entered confirm to the correct combinations of characters
7. A ………….. database has more than one table and the tables are linked using key fields
8. Check to make sure the correct numbers of characters are entered.
9. Check to make sure that data had been entered. Data will not be process unless data has been entered.
11. A request for information from a database which matches a set of criteria

1. Performed to ensure that the data entered exactly matches the original source.
2. Column within a table, individual items of data within a record
3. A persistent collection of data which is held together in an organised or logical way.
6. Storage of data in one single table/entity
7. Single row within a table, collection of data about a single item or event
10. Contains data about items / single objects and made up of unique records and fields