Answer 15 How do you join tables in an Access query Answer 16 When do you use

Answer 15 how do you join tables in an access query

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:
Background image
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:
Background image

You've reached the end of your free preview.

Want to read all 3 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture