One of the reservations agents at Colonial Adventure Tours created the query shown in Figu...

One of the reservations agents at Colonial Adventure Tours created the query shown in Figure to list each trip name and the last name and first name of each corresponding guide. The query results included 410 records and he knows that this result is incorrect. Why did he get so many records? What should he change in the query design to get the correct query results?

The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures in Chapter 1. (If you use a computer to complete these exercises, use a copy of the Colonial Adventure Tours database so you will still have the original data when you complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take.

Figure