In the figure above, the relationship between the Courses and Materials tables is a(n) ____.
A) One-to-many relationship with referential integrity
B) Many-to-many relationship
C) Cascade Update Related Fields option
D) Cascade Delete Related Records option

Question

In the figure above, the relationship between the Courses and Materials tables is a(n) ____.
A) One-to-many relationship with referential integrity 
B) Many-to-many relationship 
C) Cascade Update Related Fields option 
D) Cascade Delete Related Records option

Quizplus · Accepted Answer

The figure shows a Courses table and a Materials table with a one-to-many relationship. The relationship is indicated by the arrow from Courses to Materials, representing Courses as the "one" side and Materials as the "many" side. The presence of referential integrity ensures that there will be no orphan records in Materials when a related record is deleted from Courses. The other options, many-to-many relationship and cascade options, are not applicable in this scenario.

In the Figure Above, the Relationship Between the Courses and Materials