Databases

1. Removes an entire table from the database.
3. SQL commands used for defining, altering and deleting database structures.
6. Modifies existing records in a table.
9. Connection between two or more tables in a relational database.
17. Process of organising data in a database to reduce redundancy and improve data integrity.
19. Type of database that stores data in several tables composed of rows and columns.
20. A primary key made up of two or more columns to uniquely identify a record.
23. A rule that ensures relationships between tables remain consistent

2. One record in a table can be linked to multiple records in another table, but each of those related records refers back to only one record in the first table.
3. Structured approach to designing, implementing and maintaining a database.
4. A column (or group of columns) that creates a relationship between two tables by referencing the primary key of another table.
5. Acronym representing key properties of reliable database transactions.
7. The unnecessary repetition of data within a database.
8. Renames columns or tables temporarily.
10. A single, structured data item in a table, representing one entry or instance.
11. A request for data or information from a database table or combination of tables.
12. A structured collection of data that is stored and accessed electronically.
13. A standard language used to communicate with and manipulate databases.
14. Assigns new privileges to a user account.
15. One record in a table is linked to exactly one record in another table.
16. A column (or combination of columns) that uniquely identifies each row in a table.
18. Restrict the number of rows returned.
21. Filters records based on conditions.
22. SQL command that enables getting data from the database.
24. A set of data elements organised in rows and columns.