Which of the Following Is the Best Way to Handle

Multiple Choice

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it?

A) creating two or more records for the employee, each of which lists a different project
B) including multiple project fields, such as project 1, project 2, and so on, for the employee
C) normalizing the relationship between "employees" records and "projects" records
D) making the relationship between "employees" records and "projects" records hierarchically dependent