Databases crossword

12345678910111213
Across
  1. 1. a classification of how data is stored and displayed, and of which operations that can be performed on the stored value
  2. 3. the standard query language for writing scripts to obtain useful information from a relational database.
  3. 5. a list of SQL commands that perform a given task, often stored in a file so the script can be reused
  4. 8. a database table
  5. 9. an SQL command to include only those records (rows) in a query that match a given condition
  6. 11. an SQL command that sorts the results from a query by a given column either alphabetically or numerically
  7. 12. an SQL command that fetches specified fields (columns) from a table
  8. 13. an SQL command that identifies the table to use
Down
  1. 1. a persistent structured collection of data that allows people to extract information in a way that meets their needs
  2. 2. a database contains only one table
  3. 4. a collection of fields that describe one item
  4. 6. a field in a database that uniquely identifies a record
  5. 7. an SQL command that counts the number of records (rows) in which the field (column) matches a specified condition; used with SELECT
  6. 10. a collection of related records in a database
  7. 12. an SQL command that returns the sum of all the values in a field (column); used with