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 first name, last name and his her salary 14 Show department name for those departments which are located in Stafford 15 Show project numbers (PNO) and total number of hours worked on them 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 13. For those employees

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 first name, last name and his/her salary.

14. Show department name for those departments which are located in Stafford.

15. Show project numbers (PNO) and total number of hours worked on them.

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 12. Show each employee's first name, last name and his/her manager's...

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 11. Show all information about those employees who have dependents. ( no...

/* company.sql Script to define and populate the example database COMPANY from Chapter 3 of Elmasri and Navathe (pp.70-75 in the 6th edition), with some modifications */ -- drop tables DROP TABLE...

Activity A (20 points) Database creation Do not consider primary and foreign keys for this assignment C reate a database named company. Create a table in this database. Named: departments The...

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...

A local hotel offers ballroom dancing on Friday nights. A researcher observes the customers and estimates their ages. Discuss the skewness of the distribution of ages if the mean age is 51, the...

Find Io in the network in figure using Norton's theorem. -120 jna 6/45 A 20 2/0P A

8. A castle is located on top of a mountain. Ali stands 55 m away from the foot of the mountain, on level ground. The angles of elevation of the top of the castle and the top of the mountain from...

How can a fixed - width integer create a vulnerability in a program? Find or write an example of Java code that would cause a vulnerability in a fixed - width integer and explain the logic and...

Explain several descriptive analytics approaches, including summary statistics and data reduction, and how they summarize results.

The creation of hazardous by products, like silver in film processing, require us to collect our used chemicals for disposal at a hazardous-waste-facility.

Explain the diagnostic approach to Data Analytics, including profiling and clustering.