Question

In the Relationships window, how would you ensure that when a primary key is changed, all foreign keys will change as well?

Select an answer:

a,Click enforce referential integrity, then click cascade delete.
b.Create a one-to-many relationship.
c.Click cascade update.
d,Click enforce referential integrity, then click cascade update.

Answer 1

To synchronize the primary key with all related foreign keys upon a change, enable 'enforce referential integrity' and select the 'cascade update' option in the Relationships window. option c is the correct answer.

Step-by-step explanation:

To ensure that when a primary key is changed, all related foreign keys will automatically change as well in the Relationships window, you should click enforce referential integrity, then click cascade update.

When enforce referential integrity is selected, the database management system will not allow changes to the primary key that would create orphaned records. Choosing cascade update means that if you update a primary key, all the foreign keys that reference it will also be updated to reflect the new value. This maintains the synchronization between tables and the integrity of your data.

In the Relationships window, if you want to ensure that when a primary key is changed, all foreign keys will also change, you would need to enable the option to enforce referential integrity and enable cascade update. In order to do this, you would click on the 'Enforce Referential Integrity' checkbox and then click on the 'Cascade Update' checkbox.