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)
```
Computer Science & Information Technology
You might also like to view...
A full software installation enables you to choose which program features you want installed on your hard drive
Indicate whether the statement is true or false
Computer Science & Information Technology
Which of the following is a diagram showing a hierarchy of threats or vulnerabilities?
A) Spoofing B) Denial of Service C) Repudiation D) Threat tree
Computer Science & Information Technology