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
C
You might also like to view...
According to Max Weber, Protestant ethics discouraged the development of capitalism
Indicate whether the statement is true or false.
Finding the best solution to a business problem or opportunity describes the attention to details characteristic that a systems analyst should exhibit during the requirements determination phase
Indicate whether the statement is true or false