1z0-071 Exam Dumps | Examine the business rule: Each student can take up multiple projects and each project can have multiple

<< Prev Question Next Question >>

Question 27/50

Examine the business rule:
Each student can take up multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) 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 in this scenario?

A. The ERD must have a M:M relationship between the students and projects entities that must be resolved into 1:M relationships.

B. PROJECT_ID must be the primary key in the projects entity and foreign key in the STUDENTS entity.

C. The ERD must have a1:M relationship between the students and projects entitles.

D. An associative table must be created with a composite key of STUDENT_ID andPROJECT_ID; which is the foreign key linked to theSTUDENTSandPROJECTSentities.

E. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the projects entity.

Question 27/50

LEAVE A REPLY

Download PDF File