Examine this business rule:
Each student can work on multiple projects and each project can have multiple students.
You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true? (Choose two.)
To model a many-to-many relationship in an ER diagram, you need to create an associative table that links the primary keys of the related entities. In this case, an associative table is required with a composite key of STUDENT_ID and PROJECT_ID, functioning as foreign keys linked to the STUDENTS and PROJECTS entities. This ensures optimal data storage and permits generating reports in the required format. Additionally, the many-to-many relationship between the STUDENTS and PROJECTS entities must be resolved into one-to-many relationships through this associative table.
https://www.examtopics.com/discussions/oracle/view/15644-exam-1z0-071-topic-1-question-17-discussion/
Why B incorrect?
If student_id is a FK in the projects, only one student can "participate" in the project. Actually you could have it, as long as you also have the many-to-many, but is bad practice.