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