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
Get step-by-step solutions from verified subject matter experts
