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 FieldsInstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress Instructor City InstructorState

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: