The Pitt Fitness program director wants to list customer last names and first names along with the
Question:
The Pitt Fitness program director wants to list customer last names and first names along with the classes they are taking. He creates a query using the Customers and Classes tables. In the query grid, he adds the LastName and FirstName fields from the Customers table and the ClassName field from the Classes table. What is most likely wrong with this query?
a. You need the Reservations table to join the Customers and Classes tables together.
b. The relationship between Customers and Classes is one to many.
c. The relationship between the fields LastName and FirstName is one to one.
d. There is nothing wrong with this query.
Step by Step Answer:
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt