Name:    A114/I111 Fall 2003 Midterm Study Guide (Part Five)

 CompletionComplete each sentence or statement. 1. A(n) ________________________ database is a collection of tables. 2. Each __________________________ is stored in its own table. 3. The relationships between tables are handled through __________________________ columns. 4. A relation is a(n) _________________________-dimensional table. 5. Each row in a relation is _________________________. 6. If some of the entries contain repeating groups (not single-valued), this is known as a(n) ___________________________ relation. 7. The ________________________ key of a relation is the column or collection of columns that uniquely identifies a given row in a table. 8. When you combine a table name with a column name, you _________________________ the column name. 9. Conditions that data must satisfy are called _________________________. 10. Another name for a comparison operator is a(n) _______________________ operator. 11. If only one criterion needs to be true for the whole criterion condition to be true, use the _________________________ criterion. 12. A(n) ______________________ field is a field that is the result of a calculation using one or more existing fields. 13. Built-in statistics are known as ____________________ functions in Access. 14. ______________________ will create a collection of records that share some common characteristic. 15. The major sort key is also known as the ____________________ sort key. 16. It is necessary to ____________________ tables based on matching fields in corresponding columns to retrieve data from more than one table. 17. A query that changes data is a(n) _________________________ query. 18. A(n) _________________________ query will remove one or more records at a time from the table. 19. A(n) _______________________ query creates a new table using the query result. Short Answer 20. What is a theoretical method of manipulating a relational database? 21. Which command within relational algebra takes a horizontal subset of a table? 22. Which operation is used to extract data from more than one table? 23. List the three set operations. 24. How is the difference operation performed? 25. What is another name for the product of two tables? 26. If two tables have the same number of columns and their corresponding columns represent the same type of data, how are these tables referred to in set operations? 27. Define a union of table A and B. 28. Define an intersection of tables A and B. 29. Define the difference between two tables. Essay 30. Using figure 2.1 on pages 30-31 with relational algebra, write the algebraic statement to list all information from the Customer table concerning customer 282.  What will display? 31. Using figure 2.1 on pages 30-31 with relational algebra, list all information from the Customer table concerning those customers with credit limits of \$7,500.  What will display? 32. Using figure 2.1 on pages 30-31 with relational algebra, list the number and name of all the customers.  What will display?