RELATIONAL DATABASES

Edit Answers
12345678910111213141516171819202122232425
Across
  1. 2. The name given to a row in the relational model.
  2. 4. The clause used to combine rows that have the same values in specified columns into a summary row.
  3. 7. The programming language most commonly used to access databases through applications (often referred to in the Advanced SQL topic).
  4. 9. The SQL statement used to modify existing data in a table.
  5. 11. The most fundamental operation in SQL used to retrieve data from a database.
  6. 13. A block of code that executes automatically in response to a specific database event (INSERT, UPDATE, DELETE).
  7. 16. The name given to a table in the relational model.
  8. 18. The join type that includes all rows from one table and the matched rows from the other (e.g., Left or Right).
  9. 19. The structure that logically represents the design of the database.
  10. 21. The SQL statement used to remove existing rows from a table.
  11. 22. A construct used to ensure that a value exists in a set of allowed values for an attribute.
  12. 24. The SQL keyword used to remove a relation or index from the database.
  13. 25. The logical operator used to negate a condition in SQL.
Down
  1. 1. The number of attributes (columns) in a relation.
  2. 3. A set of columns in a table that refers to the primary key of another table.
  3. 5. A stored block of code that performs a specific task and can accept parameters but usually does not return a value.
  4. 6. A stored block of code that always returns a single value.
  5. 8. A temporary named result set based on an SQL query, used in Advanced SQL.
  6. 10. A type of function that returns a single summary value from a set of rows.
  7. 12. A condition in the WHERE clause that uses the result of another SELECT statement.
  8. 14. A constraint that ensures all values in a column are unique and non-null, often used as an identifier.
  9. 15. A clause used in SQL to filter the results of aggregate functions.
  10. 17. A type of Join that returns only the rows having matching values in both tables.
  11. 20. A SQL clause used to filter rows based on a specified condition.
  12. 23. A construct that allows a user to iterate through the rows of a query result set one at a time.