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

question 55

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