Question: 6. Using a nested SELECT statement, retrieve the department numbers of the employees with phone extension 123. 7. a) Add the tuple D4, COMPLAINTS, E3'
6. Using a nested SELECT statement, retrieve the department numbers of the employees with phone extension 123. 7. a) Add the tuple D4, COMPLAINTS, E3' to the table DEPARTMENT'. b) Create a new department table, called NEW_DEPARTMENT that includes the tuple added in a). c) Check that NEW_DEPARTMENT exists in your database. d) Delete NEW_DEPARTMENT. e) Check that NEW_DEPARTMENT has been deleted
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help