During the database redesign process,you discover that when you try to change a DEPARTMENT name (the department's primary key),the change is disallowed by the DBMS due to your design of the EMPLOYEE table (which has a foreign key referencing DEPARTMENT)You want the change to be allowed.In order to fix this,you use what SQL syntax?
A)ON UPDATE CASCADE
B)ON DELETE CASCADE
C)ADD CONSTRAINT
D)FOREIGN KEY

Question

Quizplus · Accepted Answer

The SQL syntax that allows the change of the primary key in the DEPARTMENT table and cascades the change to the foreign key in the EMPLOYEE table is ON UPDATE CASCADE. This will update the foreign keys in the EMPLOYEE table with the new value of the primary key in the DEPARTMENT table. The other options are not applicable to this scenario - ON DELETE CASCADE is used to delete related records when the primary record is deleted, ADD CONSTRAINT is used to add a new constraint to a table, and FOREIGN KEY is used to create a relationship between two tables.

During the Database Redesign Process,you Discover That When You Try