Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 11 Show all information about those employees who have dependents ( no duplicate rows duplicate rows will get 0 points ) 12 Show each employee's first name, last name and his her manager's first name and last name APPENDIX DEPENIDANT begin tabular ccccc ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP cline 2 5 333445555 Alice F 4 5 1986 Daughter 333445555 Theodore M 10 25 1983 Son 333445555 Joy F 5 3 1958 Spouse 987654321 Abner M 2 28 1942 Spouse 123456789 Michael M 1 4 1988 Son 123456789 Alice F 2 12 1988 Daughter 123456789 Elizabeth F 6 5 1967 Spouse end tabular EMPLOYEE DEPARTMENT

The Answer is in the image, click to view ...

Question: Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 11. Show all information

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries

11. Show all information about those employees who have dependents. ( no duplicate rows duplicate rows will get 0 points !)

12. Show each employee's first name, last name and his/her manager's first name and last name.

APPENDIX

Consider the Database in Appendix (you can tear off the Appendix page

DEPENIDANT \begin{tabular}{ccccc} ESSN & DEPENDENT NAME & SEX & BDATE & RELATIONSHIP \\ \cline { 2 - 5 } 333445555 & Alice & F & 4/5/1986 & Daughter \\ 333445555 & Theodore & M & 10/25/1983 & Son \\ 333445555 & Joy & F & 5/3/1958 & Spouse \\ 987654321 & Abner & M & 2/28/1942 & Spouse \\ 123456789 & Michael & M & 1/4/1988 & Son \\ 123456789 & Alice & F & 2/12/1988 & Daughter \\ 123456789 & Elizabeth & F & 6/5/1967 & Spouse \end{tabular} EMPLOYEE DEPARTMENT

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!

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 9. Show the department number (dno), the number of employees working for...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 10. For those departments which have average salary greater than $50,000,...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 3. Show the entire information about all departments and the name of the...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 13. For those employees who work for department number 5, show employee's...

Consider the Database in Appendix (you can tear off the Appendix page for easier viewing) and write the following SQL queries 12. Show each employee's first name, last name and his/her manager's...

Consider the Database in Appendix and write the following SQL queries. Show the entire information about the employees (all rows and columns of the employee table). Show the entire information about...

Consider the Database in Appendix and write the following SQL queries. 1. For those departments which have average salary greater than $50,000, show the department number (dno), the number of...

Consider the Database in Appendix and write the following SQL queries. 1. Show the first name and the last name of those employees who make more than the average salary of all employees. 2. Show the...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Show that S ª Tc = Sc © Tc (S © T)c = Sc ª Tc Set union and intersection have straightforward extensions to collections of sets. The union of a collection C of sets U S={x : x S...

Determine the enthalpy change Dh of nitrogen, in kJ/kg, as it is heated from 600 to 1000 K, using (a) The empirical specific heat equation as a function of temperature (Table A - 2c), (b) The cp...

Which of the following is an example of a liquidity ratio? Question 13Answer A. Inventory Turnover B. Debt to Equity C. Return on Investment D. Current ratio

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...