Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Assignment 3 Submit a Word document with the answers to the following questions. Review Oracle Database 19c: Basic SQL and Oracle Database 19c: PL/SQL Search Oracle Live SQL for the HR Objects and Dat

Assignment 3

Submit a Word document with the answers to the following questions.

Review Oracle Database 19c: Basic SQL and Oracle Database 19c: PL/SQL

Search Oracle Live SQL for the HR Objects and Data For Live SQL script. Save the script and execute it. Or use this link to find the script https://livesql.oracle.com/apex/livesql/file/content_GV8MU6SITA2V3VYI179FAJUCY.html

Search Oracle Live SQL for the script, SQL Joins script. Execute and study the queries of the script, SQL Joins https://livesql.oracle.com/apex/livesql/file/content_O59U2TFO5QEAOEFC6OPJ9MHBP.html

1.         Explain the construction of Statement 1:

SELECT e1.last_name||’ works for ‘||e2.last_name  

   “Employees and Their Managers” 

FROM hr.employees e1, hr.employees e2  

WHERE e1.manager_id = e2.employee_id 

      AND e1.last_name LIKE ‘R%’ 

ORDER BY e1.last_name;

2.         Explain the construction of this statement:

SELECT d.department_id, e.last_name 

FROM hr.departments d, hr.employees e 

WHERE d.department_id = e.department_id(+)

ORDER BY d.department_id, e.last_name;

3.         Execute and explain the construction of the uncorrelated subquery shown in the screenshot: 

-find screenshot and links in the attached document

4.         Execute and explain the construction of the correlated subquery shown in the screenshot: 

-find screenshot and links in the attached document

5.         Explain the difference between a correlated and uncorrelated subquery.

6.         Write a query demonstrating the use of the WHERE clause with a comparison condition (Use a relational operator.). Use the HR database.

7.         Write a query demonstrating the use of the WHERE clause with a logical operator (AND, OR, or NOT) in the condition. Use the HR database.

8.         Write a query demonstrating the use of the WHERE clause with a NULL condition. Use the HR database and the emp_details_view. Hint: The manager_id is NULL for one record in the table.

9.         Write a query demonstrating the use of the WHERE clause with an IN condition. Use the HR database.

10.   Write a query demonstrating the use of the WHERE clause with a compound condition. Use the HR database.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

In this final project, imagine that you are the chief executive officer (CEO) of your health organization and that you are asked by your organization’s board of directors to prepare a policy proposal

In this final project, imagine that you are the chief executive officer (CEO) of your health organization and that you are asked by your organization’s board of directors to prepare a policy proposal to be submitted to your local area’s congressperson. In this policy proposal, you are defending or challenging

In 400–600 words: Describe what you think is the most pertinent health policy issue with the potential to transform the way healthcare is delivered.Provide a rationale for the implementation of a poli

In 400–600 words: Describe what you think is the most pertinent health policy issue with the potential to transform the way healthcare is delivered. Provide a rationale for the implementation of a policy brief from a legal, ethical, and operational perspective. Be specific, and provide examples.

The Patient Protection and Affordable Care Act (PPACA) requires that U.S. citizens and legal residents obtain qualifying health coverage. Write a report of 5–7 pages that explores the individual manda

The Patient Protection and Affordable Care Act (PPACA) requires that U.S. citizens and legal residents obtain qualifying health coverage. Write a report of 5–7 pages that explores the individual mandate section of this health reform law and how current legislation impacts this. Complete the following: Explain the individual mandate included in

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Use this recent peer-reviewed a

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Use this recent peer-reviewed article from a healthcare journal that reports on how well the Patient Protection and Affordable Care Act (PPACA) is working. 

The final project is to design a network, network security and WAN connectivity for the following situation: Organization of 100 computer users in three locations. Location one: two buildings, 25 comp

The final project is to design a network, network security and WAN connectivity for the following situation: Organization of 100 computer users in three locations. Location one: two buildings, 25 computer users in each building. 50 total Location two: one building, 15 computer users. Location three: one building 35 computer users. Document

https://www.dropbox.com/scl/fi/b5pcfgruhyc7sft4nuukl/Stage-4-Business-Analysis-and-System-Recommendation.docx?rlkey=1cbaqfqlu4iwyvb92vjma4xrv&st=ac27fqoj&dl=0 https://www.dropbox.com/scl/fi/u8

https://www.dropbox.com/scl/fi/b5pcfgruhyc7sft4nuukl/Stage-4-Business-Analysis-and-System-Recommendation.docx?rlkey=1cbaqfqlu4iwyvb92vjma4xrv&st=ac27fqoj&dl=0 https://www.dropbox.com/scl/fi/u8z004mkd6uc1swn9r6mk/EZ-ATS-Brochure.pdf?rlkey=eczacb8pmmp05okxc0b8ysy21&st=5897a3aa&dl=0 Stages 2 and 3 (both completed)  https://www.dropbox.com/scl/fi/pkknsc9bkgbhlzm7483bb/Stage-2-Business-Analysis-and-System-Recommendation.docx?rlkey=8eb0mki4ctf3w8485lss9u1u4&st=1u4bg8s9&dl=0 https://www.dropbox.com/scl/fi/ycgf96hxd4115hvxkuqxg/Stage-3.docx?rlkey=etjzyb4jnyq0oep4lye4mz5k7&st=i9wlqeya&dl=0

The United States created Medicaid—a publicly funded healthcare program—to assist people in obtaining healthcare services. Write a paper of 5–7 pages that explores Medicaid and the Children’s Health I

The United States created Medicaid—a publicly funded healthcare program—to assist people in obtaining healthcare services. Write a paper of 5–7 pages that explores Medicaid and the Children’s Health Insurance Program (CHIP) and that addresses the following: What legislation introduced Medicaid, and what are the funding sources for the program? What are

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Complete the following: Describ

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Complete the following: Describe 2 key lessons that you have learned from state or local health reform efforts, and provide an analysis on how

Many people throughout the United States face significant barriers to healthcare access. As policy makers and other stakeholders consider ways to address challenges related to access to care, one key

Many people throughout the United States face significant barriers to healthcare access. As policy makers and other stakeholders consider ways to address challenges related to access to care, one key area of focus involves those who lack insurance or have inadequate coverage through insurance. Develop a PowerPoint presentation of 8–10

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Choose a health policy issue in

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Choose a health policy issue in your workplace or community that is related to healthcare cost, quality, or access, and then discuss the following

Write an executive summary of a recent (within the past 2 years) article related to healthcare policy processes that is centered on improving healthcare quality and outcomes. Your summary must include

Write an executive summary of a recent (within the past 2 years) article related to healthcare policy processes that is centered on improving healthcare quality and outcomes. Your summary must include the following: Describe the health policy development process and the roles that various stakeholders have in that process associated

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Complete the following for this

Write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Complete the following for this assignment: Select 1 health issue—such as diabetes, cancer, aging, chronic diseases, or obesity—and describe how current health policy (federal

https://www.dropbox.com/scl/fi/21fxfc7fr7z4y5ghhznoj/Stage-2-Business-Analysis-and-System-Recommendation-2.docx?rlkey=srllqpema7rdductuxmqw94zz&st=cz970218&dl=0 https://www.dropbox.com/scl/fi/

https://www.dropbox.com/scl/fi/21fxfc7fr7z4y5ghhznoj/Stage-2-Business-Analysis-and-System-Recommendation-2.docx?rlkey=srllqpema7rdductuxmqw94zz&st=cz970218&dl=0 https://www.dropbox.com/scl/fi/dwf6cju9felcxlyh7iizu/Maryland-Technology-Consultants-Case-Study.pdf?rlkey=tstsxmpnzat9023c0ryuvvjeg&st=qieyaz64&dl=0

The case study retail store has provided a list of reports and data manipulation tasks that are needed in the processing of orders for their customers. Answer the following: What structured query lang

The case study retail store has provided a list of reports and data manipulation tasks that are needed in the processing of orders for their customers. Answer the following: What structured query language (SQL) statement scripts are needed to create the database schema for the relational database system and manipulate

Write 400–600 words that respond to the following questions (listed below) with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas: Before you start

Write 400–600 words that respond to the following questions (listed below) with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas: Before you start this assignment, please read the story titled Sporting Goods Store Reporting. After reviewing the story, conduct research online into the