Boolean logic and databases

Edit Answers
123456789101112131415161718
Across
  1. 3. An SQL command that fetches specified fields (columns) from a table
  2. 7. An SQL command to include only those records (rows) in a query that match a given condition
  3. 10. A database that contains only one table
  4. 11. An SQL command that returns the sum of all the values in a field (column); used with SELECT
  5. 12. A field in a database that uniquely identifies a record
  6. 14. A method of checking the output from a logic circuit; it lists all the possible binary input combinations and their associated outputs
  7. 17. An electronic circuit that relies on 'on/off' logic; the most common are NOT, AND, OR, NAND, NOR and XOR
  8. 18. A persistent structured collection of data that allows people to extract information in a way that meets their needs
Down
  1. 1. A form of algebra linked to logic circuits and based on TRUE or FALSE
  2. 2. A classification of how data is stored and displayed, and of which operations that can be performed on the stored value
  3. 4. A collection of fields that describe one item
  4. 5. An SQL command that counts the number of records (rows) in which the field (column) matches a specified condition; used with SELECT
  5. 6. An SQL command that sorts the results from a query by a given column either alphabetically or numerically
  6. 8. The values associated with each record in a database table
  7. 9. The standard query language for writing scripts to obtain useful information from a relational database
  8. 13. These are formed from a combination of logic gates and designed to carry out a particular task
  9. 15. A collection of related records in a database
  10. 16. An SQL command that identifies the table to use