Delete department number 30 from the department table. If it is not successful, write down your suggestion to make it work.
Write queries/statements for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> DELETE FROM Dept
2 Where DeptId = 30;
DELETE FROM Dept
*
ERROR at line 1:
ORA-02292: integrity constraint (SYSTEM.EMPLOYEE_DEPTID_FK) violated - child
record found
(Remove/disable Foreign key constraint in employee table)
```
You might also like to view...
If all three RGB parameters for decimal are set to 0, the color will be ________
Fill in the blank(s) with correct word
When you click a Dialog Box ________, a corresponding dialog box is opened
Fill in the blank(s) with correct word
Information ____________________ is the process of gathering information either directly or indirectly from a system or the system's environment.
Fill in the blank(s) with the appropriate word(s).
While attempting to identify the problem, you should _______________ the user and identify user changes to the computer.
Fill in the blank(s) with the appropriate word(s).