Using the relations given in the appendix, write the SQL statements to perform the following operations:i. Add a new employee in the employee table whose employee number is 1009, full name is Stephen M. Clinton, date of birth is 23rd July 1970, and hire date is 1st July, 2022.ii. Add a dependant of this employee in the employee table, with dependant number of 1, first name specified as Johannes and date of birth specified as 5th February, 2005.iii. Delete records in the dependant table where the dependantnumber is 2.iv. Delete all dependants of the employee with employee number 1008 from the dependant table. APPENDIXEMP NUM EMP LNAME1001 Callifante1002 Smithson1003 Washington1004 Chen1005 Johnson1006 Ortega1007 O'Donnell1008 BrzenskiFIGURE 1 EMPLOYEE RELATIONEMP NUM DEP_NUM1001100110031006100810081008EMP FNAME EMP INITIAL EMP DOB EMP HIREDATEJeanine12-Mar-6425-May-97William23-Nov-7028-May-97Herman15-Aug-6828-May-9723-Mar-7415-Oct-9820-Dec-9805-Jan-0223-Jun-0201-Nov-03LydiaMelanieFIGURE 2 DEPENDANT RELATIONJorgePeterBarbaraDEP_FNAME1 Annelise2 Jorge1 Suzanne1 Carlos1 Michael2 George3 KatherineJKHGDADEP_DOB05-Dec-9730-Sep-0225-Jan-0425-May-0119-Feb-9527-Jun-9818-Aug-0328-Sep-6612-Jul-7910-Jun-7112-Feb-70niging

i. The INSERT command is used to add a new record row to an existing table. The following statement…

Answered: Using the relations given in the…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using the relations given in the appendix, write the SQL statements to
perform the following operations:
i. Add a new employee in the employee table whose employee
number is 1009, full name is Stephen M. Clinton, date of
birth is 23rd July 1970, and hire date is 1st July, 2022.
ii. Add a dependant of this employee in the employee table, with
dependant number of 1, first name specified as Johannes and
date of birth specified as 5
th February, 2005.
iii. Delete records in the dependant table where the dependant
number is 2.
iv. Delete all dependants of the employee with employee
number 1008 from the dependant table.