Question

Problems inherent in the many-to-many relationship in the relational environment can best be avoided by

Group of answer choices

using the hierarchical model.

breaking the M:N situation up, to produce a set of 1: M relationships.

enforcing referential integrity rules.

placing all entities in one table.

In a(n)_____________ the unmatched pairs would be retained and the values for the unmatched other table would be left blank or null.

Group of answer choices

equi JOIN

natural JOIN

theta JOIN

outer JOIN

Answer 1

Question 1:
Problems inherent in the many-to-many relationship in the relational environment can best be avoided by breaking the M:N situation up, to produce a set of 1:M relationships
So, answer is option 2
Answer:
breaking the M:N situation up, to produce a set of 1:M relationships


Question 2:
In a(n) outer JOIN the unmatched pairs would be retained and the values for the unmatched other table would be left blank or null.
So, answer is option 4
Answer:
outer JOIN