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

Multiple Choice

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