Exam 1z0-071 topic 1 question 81 discussion

Actual exam question from Oracle's 1z0-071

Question #: 81
Topic #: 1

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.)

A. PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
B. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the projects entity.
C. 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.
D. The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into one-to-many relationships.
E. The ER must have a one-to-many relationship between the STUDENTS and PROJECTS entities.

Show Suggested Answer

Suggested Answer: CD 🗳️

by Orxan_H at April 21, 2023, 2:49 p.m.

Comments

Submit Cancel

CMjer

1 year, 2 months ago

Selected Answer: CD

https://www.examtopics.com/discussions/oracle/view/15644-exam-1z0-071-topic-1-question-17-discussion/

upvoted 1 times

...

Orxan_H

1 year, 3 months ago

Why B incorrect?

upvoted 1 times

TofOra

6 months ago

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.

upvoted 1 times

...

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam

Exam 1z0-071 topic 1 question 81 discussion

Comments

CMjer

Orxan_H

TofOra

SY0-701