Database Terms

3. A property that defines data in an entity. Also known as a field.
4. A copy of data stored elsewhere to be restored if original data is lost or damaged.
6. A SQL keyword used to show the number of records within a query.
11. Type A setting that defines what kind of data can be entered in a field, such as a number, date, or text string.
12. A SQL keyword used to change the definition of a database object.
13. A data type that allows for values to be either true or false.
14. A file that stores data and allows people to search and create reports from the data.
16. A data type that is either a zero or a one.
18. A SQL keyword used to get the average amounts for one or more fields within a query.
20. A SQL keyword used to define a range of values used for a filter within a query.
22. An index based on the primary key of an entity.

1. A primary key consisting of two or more fields. Also known as a composite key.
2. normalization in which each field has a single value, data can be sorted in anyway possible.
3. A limitation on what can be entered in a data field within an entity.
5. A SQL keyword used to display records within a query if all records within that query match related records in a subquery.
6. A primary key consisting of two or more fields. Also known as a compound key.
7. Information that is organized, entered into files, and then retrievable as needed.
8. A symbol used to define a filter within a query, for example, the greater than or equal to symbol (>=).
9. A combining of two unrelated tables within a query.
10. A SQL keyword used to add an object to a database or add an entire database to an instance of SQL Server.
15. A SQL keyword used to find matching records from a query to a subquery.
17. A unit of measurement used to determine how much memory a piece of data will take.
19. normalization in which a value change does not necessitate a change in another non-key column within an entity.
21. a replacement name for a column or table.