0%(2)0 out of 2 people found this document helpful
This preview shows page 2 - 3 out of 3 pages.
Answer:15. How do you join tables in an Access query?Answer:16. When do you use an update query?Answer:17. When do you use a delete query?Answer:18. When do you use a make-table query?Answer:19. What is relational algebra?Answer:20. Describe the purpose of the SELECT command in relational algebra.Answer:21. Describe the purpose of the PROJECT command in relational algebra.Answer:
22. Describe the purpose of the JOIN command in relational algebra.Answer:23. Describe the purpose of the UNION command in relational algebra.Answer:24. Are there any restrictions on the tables when using the UNION command? If so, what are these restrictions?Answer:25. Describe the purpose of the INTERSECT command in relational algebra.Answer:26. Describe the purpose of the SUBTRACT command in relational algebra.Answer:27. Describe the purpose of the product process in relational algebra.Answer:28.Describe the results of the division process in relational algebra.Answer:29.In the BITS Corporation database shown in Figure 2-1, the Consultant table contains four rows and the Client table contains 12 rows. How many rows would be contained in the Cartesian product of these two tables?Answer:30. In Your Turn 2-23 on page 64, would you get the same result if you performed the PROJECT command before the JOIN command? Why or why not?Answer: