Question: Please Help Specify the following queries in SQL on the COMPANY relational database schema shown in Figure 5.5. Submit SQL and the result of each

Please Help Specify the following queries in SQL on the COMPANY relational Please Help

Specify the following queries in SQL on the COMPANY relational database schema shown in Figure 5.5. Submit SQL and the result of each query.

a) List the names of all employees who have a dependent with the same first name as themselves.

b) Find the names of all employees who are directly supervised by Franklin Wong.

190 Chapter 6 Basic SQL Figure 6.3 Results of SQL queries when applied to the COMPANY database state shown in Figure 5.6. (a) Qo. (b) 01. (c) 02. (d) 08. (e) 09. (f) Q10. (g) Q1C. (a) (b) Lname Bdate Address 1965-01-09 731 Fondren, Houston, TX Frame John Franklin Ramesh Joyce Wong Narayan English Address 731 Fondren, Houston, TX 638 Voss, Houston, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX (c) (f) | Pnumber 10 30 Dnum 4 Lname Address Wallace 291 Berry, Bellaire, TX Wallace 291 Berry, Bellaire, TX Bdate 1941-06-20 1941-06-20 (d) E.Fname John S.Lname Wong Borg Wallace Franklin Alicia Jennifer Ramesh E.Lname Smith Wong Zelaya Wallace Narayan English Jabbar S.Fname Franklin James Jennifer James Franklin Franklin Jennifer Borg Ssn 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 123456789 333445555 999887777 987654321 Wong Wong Wallace Joyce Dname Research Research Research Research Research Research Research Research Administration Administration Administration Administration Administration Administration Administration Administration Headquarters Headquarters Headquarters Headquarters Headquarters Ahmad (e) E.Fname 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 666884444 453453453 987987987 888665555 Headquarters Headquarters Headquarters Frame John Franklin Ramesh Joyce Minit B T K A Lname Smith Wong Narayan English Ssn Bdate Address Sex Salary Super_ssn Dno 123456789 1965-09-01 731 Fondren, Houston, TX M 30000 3334455555 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 666884444 1962-09-15 975 Fire Oak, Humble, TX | M 38000 333445555 5 453453453 1972-07-31 5631 Rice, Houston, TXF 25000 3334455555

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Database Help: Specify the following queries in SQL on the COMPANY relational database schema shown in Figure 3.5. Show the result of each query if it is applied to the COMPANY database in Figure...

Specify the following queries in SQL on the COMPANY relational database schema shown in Figure 5.5. Show the result of each query if it is applied to the COMPANY database in Figure 5.6. a. Retrieve...

6.10. Specify the following queries in SQL on the COMPANY relational database schema shown in Figure 5.5. Show the result of each query if it is applied to the COMPANY database in Figure 5.6. a....

Specify the following queries in SQL on the COMPANY relational database schema. Show the result of each query if it is applied to the COMPANY database. 1 . Find the names of all employees who are...

Please Help with these? Specify the following queries on the COMPANY relational database schema shown in Figure 5.5 using the relational operators discussed in this chapter. Also show the result of...

Question 1. (16 points) Exercise 6.16 (a, c, e and i) on pages 281 - 282. Specify the follow- ing queries on the COMPANY relational database schema shown in Figure 5.5 using the relational algebra...

1 What update anomalies occur in the EMP _ PROJ and EMP _ DEPT relations of figure given below? 2 What are the different types of SQL injection attacks? What preventive measures are possible against...

Dont copy from others!!!!!! if you copy others, ill report 2. Specify the following 5 queries in SQL on the Salesrep database schema of Figure 1.1. (Total for que 2 is 10 marks) i. List all your 5...

Specify the following queries in SQL on the COMPANY database. Show the result of each query. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ProductX...

Which of these formulas represent molecules? State how many atoms are in each molecule? a. Fe b. PCl3 c. P4 d. Ar

Imagine a person standing naked in a room at 23.0C. The walls are well insulated, so they also are at 23.0C. The person's surface area is 2.20 m2 and his basal metabolic rate is 2167 kcal/day. His...

Server farms are often inefficient but ensure an organization can scale up quickly when customer demand increases. True Fatse

Camden Biotechnology began operations in September 2 0 2 4 . The following selected transactions relate to liabilities of the company for September 2 0 2 4 through March 2 0 2 5 . Camden's fiscal...

5. The computer imposes a discipline of linear thinking. Organizations will need to find ways to encourage and protect nonlinear thinking and communicating.

6. Expectations of work performance may be machine driven. Employees in some organizations will perceive this as dehumanizing and coercive. (pp. 480481)

7. Where Do We Begin?