SQL Terminology Domain 2 - Lesson 1 and 2

Edit Answers
123456789101112
Across
  1. 1. A SQL keyword used to define multiple values used for filtering criteria within a query.
  2. 4. A backup of an entire database.
  3. 5. A virtual table used to sort information in an entity and make that information easier to retrieve than without the index.
  4. 7. A join that shows all records from both tables within a defined join.
  5. 10. Key An entity field used to help create a one-to-many relationship between entities.
  6. 12. A SQL keyword set used to define fields that should be aggregated when aggregates are used within a query.
Down
  1. 1. A join that shows related records from both tables within the join.
  2. 2. A SQL command used to run a stored procedure.
  3. 3. A keyword used to return records without duplicate values among fields specified in a query.
  4. 4. A property that defines data in an entity. Also known as a column.
  5. 6. A database object with organized rows and columns as data. Also known as a table.
  6. 8. A SQL keyword used to remove a database object.
  7. 9. Adding a row of data to an entity.
  8. 11. An Entity Relationship Diagram (ERD) is a visual representation of a database, its entities, and the relationships among those entities.