2:40 George Mcf Assignment_2 - SQL ITT... CU EMPLOYEE NAVE MINE BOAT ADDRESS SEX SALARY PERSON 17. Patron Wong 32342355 120 688 Viem, Hels TT-20 Gamer BORGERET 5 Waters SEZ 1620 y un Narayan OUT ke L 1972-073 2000 S AY DEPARTMENT DALAM DNM MASSA MATE Am 3131452 Adnan 26-0 1906-19 DEPT LOCATIONS NUMBER LOCATION $ WORKS ON HOURS NO 1 2 12M 18 200 3453453 S53451 445555 13 LOS 194 106 10 99 445555 . 30 10 350 30 5555 30 PROJECT PAME NUMER NOCATIONUM 1 2 5 1 10 ro 1 Com SON DATE DEPENDENT ISSN DEPENDENT NAME SA MUSSSS The MSSSS BILARONS TA es Se OU 2:40 George Mcf Assignment_2 - SQL ITT... NTROL 1256M 1.2345 12 SO NON DALICHTER 205 Ce the Copy Dhe She Created the Page wel vedele Show more Met 377422983424 MM 58665559, EMPLOYEE. ht. 4. PROIECT 4 SM 03:42, SOSEDEPENDENT Delete the EMPLOYEESN7602 DI PROFEXT PRAME 7 Medity RSSN and MRSTARTDATE DEPARTMENTS Medya SUPERSSN EMPLOYEES IT'S Rarewalls where in tem 1 Find all employees we were bestemte 15 12. Retrieve the one of charge the wonders all the procedy department 12 Retrieve en playas de dependent 14 he was the Deuteroplees bewerk het 15. det hele werd 16 Add pack of mystem There were 2:40 George Mcf Assignment_2 - SQL ITT... ONAMI DAMER MESIN MORTARTDATE 54321 SL- DEPT_LOCATIONS NUMBER BARADON 1 attend 3 WORKS ON Song VICE 25 3 1 200 200 6655455453 S53451 SSSS WS wa 301445555 103 10 20 M 10 92 200 15 563421 20 PROIECT NAME NUMBRILOCATION OM 1 Sad Coro 10 DEPENDENT DEPENDENT NAME 1885885 Thom MENSUS 32 Michael 1.750 100 SEX DAT FR-25DAUGHTER M1583-10.35SON SOM MY MELO 11821 DATI For each of the fatherine perlele lhe code this should be done in Winterschil tund a screen shot of the results for each question below Create the Company De Schem. 13 Martel Create each table deside the primary key and the Foreigner 124 Marel Populisteschtle with the detaren I Markal Show the write bo poslate the tables 12 Marts NB. Alle can have more than enorme 2. Insert "Robert", "F"Sl. 943776541". 1953-06-21 2365 Newcastle Rt. Belaire. "TX". M. 5100, 8665555.1 EMPLOYEE. 12 Marel 3. Introduct. 4. Bellite. O PROJECT 12 Marks 4. Insert 453453453", John'. M. 1970-19-12. SPOUSE DEPENDENT 12 Maths 3. Delete the EMPLOYEE tuple with SSN-987654321 para Delete the PROJECT Tuple with PRAMEX 7. Modify the MGRSS MGRSTARTDATE OF DEPARTMENT tuple with DNUMBERS 12445671992-10-01 respectively 13 M & Modify the SUPERSSN attribute of the EMPLOYEE tople with SSN-916677778094377543 13 M Retrieve all employees who address is an Houston Texa 13 Maks 10. Find all employees who were bore during the 1950 3 Mars 11. Show the resulting salanes il every employee working on the Product project is given a 10 percent raise [6 Marks 12. Retrieve the name of each employee who was on all the projects controlled by department number 16 Marts 13. Retrieve the names of employees who have a dependents 15 Marko 14 For each projects which more than two employ work, trieve the project sumber the project man the number of employees who work on the projet Marka 15. Forcach department that has more than the employees, trieve the department sumber and the number of employees who are making sure than 10.000 16 Mar 1. Add tribute for keeping track of job of sployees to the employee table Sabi 1. The Paffile with the results with the naming on Lastom_firstname_1304_20711 The sole win the code with extensione Firstname J304221.00 2:56 Search