Question 10
Examine the 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.)
The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.
The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.
STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.
Correct answer: BE
Explanation:
References:http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html
References:
http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html