Across
- 2. Allows tables and results from queries to be presented in a user-friendly way to read
- 4. A small program that is written to perform a repetitive task automatically
- 8. A key field in one table used to create a link between data in another table
- 9. A database structured to recognize relations between stored items of information.
- 11. Heading given to each item of data stored about a single database entity
- 13. A two-dimensional database table
- 14. Bringing together data from various sources and assembling it within a single location
- 15. An item which is represented in a database
- 17. The field that uniquely identifies one record
- 19. A list of values, usually belonging to a particular field, displayed vertically in a table
Down
- 1. Used to search and extract data from the database to find the answer to a question
- 2. Ensures that an entry cannot be made in one table with a foreign key, if the key field does not exist in the linked table
- 3. A flat file where data is organised into a number of rows and columns
- 5. Used to enter a new record, modify an existing record and to view records already stored in a table
- 6. A snapshot of a database at a specific moment in time, containing all the properties described by a database schema as data values
- 7. Defines the type of data associated with a field, i.e. string, date/time
- 10. A number of data items related to an object or person. A record is represented as a row in a table
- 12. A single group of related data within a table
- 13. The title given to each used column within a database
- 16. Part of a record that stores a single data item. Represented by a column in a database
- 18. Used to search and extract data from the database to find the answer to a question