Domain 3 - Lessons 1 & 2 Terms

3. A relationship between two primary keys in two entities.
5. A value specified, usually by a user, that is used to retrieve data using that value when running a stored procedure.
6. A statement used to retrieve desired data from a database.
9. A SQL keyword that allows for the use of wildcards to return approximate matches of criteria within a query.
14. The process of ensuring that an entity in a database can work with other entities as needed from an organization and relationship standpoint.
15. An index based on an entity field that is not the primary key of an entity.
16. A data type consisting of whole numbers.
17. The combining of two entities within a single query, with data being related on a common field between the two entities.
18. A keyword set used to sort data within a dataset.
20. A join that shows all records from one side of the join and related records from the other side of the join.
23. A keyword used to return matching records between two entities.
24. A SQL keyword used to get the largest value within a range of values.
25. A SQL keyword used to define multiple values used for filtering criteria within a query.
27. A join that shows all records from the first table defined in a join.
28. A SQL keyword set used to define fields that should be aggregated when aggregates are used within a query.

1. A window in SQL Server that shows databases and their objects within each server instance.
2. A join that shows all records from both tables within a defined join.
4. A value a person enters to use as a filter when running a stored procedure.
7. A record entered in the many table of a one-to-many relationship that has a value in its foreign key that does not exist in the primary key of the entity used on the other side of the relationship.
8. An entity relationship between a primary key in one entity and a foreign key in another entity.
10. A permissions principle that ensures people with access to a database have the permissions they need to perform their job duties, but those permissions are the only ones they have.
11. A virtual table used to sort information in an entity and make that information easier to retrieve than without the index.
12. A SQL statement that copies records from one entity to another.
13. A join that shows related records from both tables within the join.
19. A value that is returned from running a stored procedure.
21. A SQL keyword used to indicate an empty value within a field.
22. A data type that holds a set number of characters in a field and allows for Unicode characters.
26. A SQL keyword used to get the smallest value within a range of values.