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