Across
- 1. When sorting on two fields, the more important field; also called a major sort key.
- 5. The combination of two or more rows in an operation, such as a join, or the combination of two or more fields
- 6. A query that deletes all records that satisfy some criterion.
- 8. a join of two or more tables where only records with matching join data is in all involved tables
- 9. The command to retrieve rows from a table
- 10. built in functions used to calculate a count, sum, min, max, or average
- 11. the operation in which two tables are connected on the basis of a common field
- 14. More than one data in a single location in a table.
- 15. The process of arranging rows in a table or results of a query in a particular order.
- 16. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name. For example, Customer.Address
- 18. field or combination of field which uniquely identifies each row (record or tuble)
- 19. A two-dimensional table-style collection of data in which all entries are single-valued, each column has a distinct name, all the values in a column are values of the attribute that is identified by the column name, the order of columns is immaterial, each row is distinct, and the order of rows is immaterial. Also called a table.
- 23. A combination of criteria in which at least one of the criteria must be true.
- 25. A field whose value is computed from other fields in the database; also called a calculated field.
- 26. a query that creates a table or database
- 29. A collection of relations (tables).
- 32. The formal name for a row in a table.
- 33. a Boolean condition used to identify data in a query
- 34. a join of two or more tables where all records from all involved tables are returned
Down
- 2. also called secondary sort key.
- 3. a query that changes the contents of a table.
- 4. Two or more simple criteria (conditions)combined with the AND or OR operators.
- 7. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null.
- 9. When sorting on two fields, the less important field; also called minor sort key.
- 10. Combination of criteria in which both criteria must be true.
- 12. also called primary sort key.
- 13. when more than one database column is necessary to make a row unique.
- 17. An operator used to compare values
- 20. A query that allows the user to enter the value needed to run the query
- 21. A compound condition that tests for a range of values, inclusive of the lower number, the higher number, and all numbers in- between.
- 22. A structure that satisfies the properties required to be a relation (table) with the exception of allowing repeating groups (the entries in the table do not have to be single-valued).
- 24. also called a relational operator.
- 27. A data value meaning "unknown" or "not applicable."
- 28. A question, the answer to which is found in the database
- 30. The process of creating collections of records that share some common characteristic.
- 31. The field on which data are sorted; also called a key.