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:

Intermediate Goods

Products that are used as inputs in the production of other goods or services and are not final products themselves.

GDP

Gross Domestic Product (GDP) measures the total monetary value of all goods and services produced over a specific time period within a country's borders.

Social Security

A government program that provides financial assistance to individuals during retirement, disability, or upon the occurrence of other social risks.

Italian Sports Car

High-performance automobiles produced in Italy known for their luxurious design, speed, and precision engineering.