Which of the Following Is the Best Approach While Handling

Multiple Choice

Which of the following is the best approach while handling 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) create two or more records for the employee, each of which lists a different project
B) include multiple project fields, such as project 1, project 2, and so on, for the employee
C) normalize the relationship between "employees" records and "projects" records
D) make the relationship between "employees" records and "projects" records hierarchically dependent