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

---

Definitions:

Dangling Modifier

A word or phrase intended to modify a word not clearly stated in the sentence, often leading to confusion or ambiguity.

Misplaced Modifier

A grammatical error where a descriptive word or phrase is placed too far from the noun it is meant to modify, leading to unclear or absurd sentences.

Independent Clauses

Sentences or parts of a sentence that can stand alone as a complete thought because they have both a subject and a verb.

Dependent Clause

A group of words with a subject and verb that cannot stand alone as a complete sentence because it does not express a complete thought.