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

Recognize and use Excel's tools for data verification and validation.

Understand the impact of color choices in digital designs.

Identify and use basic Excel shortcuts and functions.

Understand the principles of data visualization and formatting in Excel.

---

Definitions:

Manage

The act of controlling or overseeing functions and tasks to achieve desired objectives.

Redefining Problem

The process of analyzing and adjusting the perception or understanding of a problem to identify new solutions or approaches.

Alternative Solutions

Different options or strategies that can be pursued to resolve a problem or conflict, offering multiple paths to a resolution.

Brainstorming

A creative group activity aimed at generating a large number of ideas for solving a problem.