In the real world, a many-to-many relationship exists between two data tables in an Access file. The data tables are titled “Full-time Employees” and “Retirement Benefits.” Which statement best describes the process for setting up the relationship between these two tables?
a. Create a one-to-one relationship for each relationship shared by the tables.
b. Create a one-to-many relationship for only the most important relationships shared by the tables.
c. Create a junction table to break the relationship into two separate one-to-many relationships.
d. Create a cross-reference table to delete any unneeded relationships in both tables.
