Question: SQL Question: Implement SQL script that performs the following actions. (1) First, the script modifies a description of one department in a relational table DEPARTMENT

SQL Question:

Implement SQL script that performs the following actions.

(1) First, the script modifies a description of one department in a relational table DEPARTMENT such that a new manager of the department is a member of a department different from the managed department.

(2) Next, the script finds all cases that violate in a database 'dbtest' the following consistency constraint. "An employee who is a manager of a department must be a member of the same department" The script must list the outcomes of verification of the consistency constraint as a single column table with the following messages as the following rows. An employee who manages a department is a member of department Use a function CONCAT to create the messages above. Note, that it is NOT your task to eliminate the violations of consistency constraint listed above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!