Which of the following is the correct technique for representing a M:N relationship using the relational model?
A) An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation.
B) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
C) An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
D) The key from either relation is placed as a foreign key in the other relation.
E) None of the above

Question

19-12-2022
Computers and Technology

Answered

Which of the following is the correct technique for representing a M:N relationship using the relational model?
A) An intersection relation is created, and the key of either entity is placed as a key in both the intersection relation and in the other relation.
B) An intersection relation is created with a surrogate key, which is placed in each of the parent entities.
C) An intersection relation is created, and the keys of both parent entities are placed as a composite key in the intersection relation.
D) The key from either relation is placed as a foreign key in the other relation.
E) None of the above

Answer :

Other Questions

Considering the SQL create statements; assume that SALE, SALE_ITEM and ITEM tables were created without Primary keys and Foreign Keys. Which of the following SQ

Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date Not Null, Primary Key (SUB_NO, STUDENT_NO, DATE_TAK

Draw an erd for the create queenworks database. use crow foot notation, identify cardinality and participation constraints as you derive them from data in table

Codider the Bayesina Network below: Note: The namerical values of the probabilities are for part (e) (a)â(d) . (a) Find the joint protability P(A,B,C,D,E,F,G) a

The JavaScript code segment below calls a function magicArray that has three array parameters (a, b, and c) of the same length. The function is intended to assi

An engineer is writing some CSS for the footer of their web page, but noticed something off about how the CSS is showing up on the page. Which of the following

Scenario: 1. You, as a requirements engineer are given the task of preparing requirements documentation for an “IoT solution to monitor water levels in a tank”

A sorted bag behaves just like a regular bag but allows the user to visit its items in ascending order with the for loop. Therefore, the items added to this typ

BhavikaKukreja BhavikaKukreja · Answer 1 · 2022-12-26T08:16:48-05:00

An intersection relation is created, and keys of both parent entities are placed as a composite key in intersection relation.

M:N - many-to-many relationship: In relational database design, a many-to-many (M:N) relationship exists when, for one instance of entity A, there exists zero, one, or many instances of entity B; and for one instance of entity B, there exists zero, one, or many instances of the entity A. ( abbreviated M:N)

Many-to-many (m:n) relationships add complexity and confusion to our model and to application development process.

The key to resolve m:n relationships is to separated two entities and create two one-to-many (1:n) relationships between them with third intersect entity.

A many-to-many (or M:N) relationship is one of three database relationships. The other two are: One-to-one (1:1) relationships

learn more about m:n relationship at

https://brainly.com/question/13437434

#SPJ4