Answered step by step
Verified Expert Solution
Question
1 Approved Answer
GEIT 3341: Database 3. Find the first name, middle initial and last name of all employees who work on exactly 2 projects. (2.5 points) 2.
GEIT 3341: Database 3. Find the first name, middle initial and last name of all employees who work on exactly 2 projects. (2.5 points) 2. Produce a relation showing the department name and the name of the project controlled by that department. (2 points) Query in SQL: Using the COMPANY schema, express the following operations in SQL. For your SELECT operations, make sure that they always work without modification even if the underlying tables change via insert/update/delete operations. Query SQL: 1. Find the first name, middle initial and last name of all female employees. (1 point) Query Output: Query in SQL: Query Output: Query Output: 4. Show how you can insert the following row in the PROJECT table using SQL: (1.5 points) 5. Show how you can decrease the salaries of all female employees by 5% using SQL. (1.5 points) 6. Using SQL, show how you can delete dependents whose name starts with the letter A. (1.5 points) Update Command: Delete command: Pname=Audit Pnumber 40 Plocation Houston Roum=1 Insert Command: Screen shot of EMPLOYEE table (to make sure that the salaries have been decreased): Screen shot of DEPENDENT table (to make sure that the dependents have been deleted) Screen shot of PROJECT table (to make sure that the project has been inserted): Figure 5.6 One possible database state for the COMPANY relational database schema. Dno EMPLOYEE Fname Minit John B Franklin T 5 5 Alicia 4 S 4 Lname San Bdate Address Sex Salary Super_ssn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voes, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace | 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TXM 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL Jennifer Ramesh Joyce Ahmad ID 0 -
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started