The Instructors table and the ClassInstructors table have a one-to-many relationship. When forming the relationship, you want

Question:

The Instructors table and the ClassInstructors table have a one-to-many relationship. When forming the relationship, you want to ensure that if an instructor changes his or her InstructorID in the Instructors table, the related InstructorID will change in the ClassInstructors table. What option should you select when editing the relationship?

a. Enforce Referential Integrity

b. Cascade Update Related Fields

c. Cascade Delete Related Records

d. Enforce Referential Integrity and Cascade Update Related Fields InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress Instructor City InstructorState