Madelynn enforced referential integrity on all the one-to-many relationships in the Volunteers database.Provided all data entry was completed after the relationships were established, which join type would not be needed in the database?
A) inner
B) self
C) right outer
D) left outer

Question

Quizplus · Accepted Answer

Referential integrity ensures that every foreign key in a child table matches a primary key in the parent table, meaning there are no orphan records. Therefore, a right outer join, which includes all records from the right table and matched records from the left table, would not be necessary because there wouldn't be any unmatched records in the right table to include.

Madelynn Enforced Referential Integrity on All the One-To-Many Relationships in the Volunteers