1		2
																		3
													4		5
										6
				7
										8
9		10
										11				12
						13			14
15				16
17												18
								19		20
						21
																22
							23

Across 1. The _______() function converts the value of a field to uppercase. 5. Keyword, used with a wildcard to search for part of a text string. 6. An attribute that uniquely identifies each record—no duplicates. Every table must have one, even if you have to use an autonumber. Two words, no spaces. 8. A student takes many classes and a class has many students. What type of relationship is this? Three words, no spaces. 9. Returns the number of values of the specified column. Without the parenthesis. 14. Return all rows from the left table, even if there are no matches in the right table. Two words, no spaces. 17. Exactly one row of a parent table is related to one row of a child table. What type of relationship is this? Three words, no spaces. 18. There are four characteristics that have to be true before we can call a set of SQL statements a transaction. What is the acronym? 20. A primary key introduced into a related table Two words, no spaces. 21. A record in Table A can have MANY matching records in Table B, but a record in Table B can only match ONE record in Table A. What type of relationship is this? Three words, no spaces. 22. Return rows when there is at least one match in both tables. INNER JOIN is the same as ____________. 23. A key made of two or more columns. Two words, no spaces.

Down 2. The __________ command allows you to change almost everything in your table without having to reinsert your data. 3. You will only be able to insert values into your foreign key that exist in the table the key came from, the parent table. This is called ____________ ______________. Two words, no space. 4. The ____() function returns the total sum of a numeric column. 7. Goes with Update statement to to say what the new value should be. 10. Keyword used to change existing records in a table. 11. Primary mechanism for retrieving information from your database. Questioning your database. 12. All of the pieces of the transaction must be completed, or none of them will be completed. 13. The type of table to step in between two many-to-many tables and simplify the relationships to one-to-many. 15. reverses everything to the way it was before you typed START TRANSACTION. 16. The __________ keyword. It changes only the data type of a column and leaves the name alone. 19. SQL offers another type of table, known as a ___________. It is temprorary, but it persists until you drop it.