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

Systems Analysis and Design Reflection Activity: Chapter 2 Feasibility studies are critical in project management, helping us determine whether proposed projects are viable. As systems analysts, unde

Systems Analysis and Design Reflection Activity: Chapter 2  Feasibility studies are critical in project management, helping us determine whether proposed projects are viable. As systems analysts, understanding feasibility is essential. Let’s explore how reflection can enhance the feasibility evaluation process by answering the following questions:   1. Why are feasibility studies

Systems Analysis and Design Reflection Activity: Chapter 1 In this reflection activity, we will explore the critical role of systems analysts within organizations. Systems analysts play a pivotal rol

Systems Analysis and Design Reflection Activity: Chapter 1  In this reflection activity, we will explore the critical role of systems analysts within organizations. Systems analysts play a pivotal role in bridging the gap between business needs and technology solutions. By understanding their responsibilities, skills, and challenges, we gain insights into the

Provide a one-page summary of your learning experience from the class that I took about Fundamentals of Information Systems Security ( Kim, D., & Solomon, M. G. (2023). Fundamentals of information

Provide a one-page summary of your learning experience from the class that I took about Fundamentals of Information Systems Security ( Kim, D., & Solomon, M. G. (2023). Fundamentals of information systems security (4th ed.). Jones & Bartlett Learning.).  What critical thinking skills have you acquired over the past nine weeks, which

You are in the early stages of preparing a presentation for your organization’s Global Partners Meeting to be held in Geneva. Executive management, inspired by your unstoppable drive for sustainable

You are in the early stages of preparing a presentation for your organization’s Global Partners Meeting to be held in Geneva.  Executive management, inspired by your unstoppable drive for sustainable and viable information security practices across the organization, has asked you to prepare a presentation that will address the issues

Continued from 591164 Unit VII Final Research Paper Assignment objective: In this assignment, you will produce your final paper with the addition of the counterargument and conclusion paragraph,

Continued from 591164 Unit VII Final Research Paper Assignment objective: In this assignment, you will produce your final paper with the addition of the counterargument and conclusion paragraph, your revised introduction paragraph and developed body paragraphs, and a references page with at least three sources. Length: The overall paper should be 1,300

Summative Assessment: Sociotechnical Systems Presentation Research sociotechnical systems and related models. Create a 12- to 15-slide Microsoft PowerPoint presentation with detailed speaker notes out

Summative Assessment: Sociotechnical Systems Presentation Research sociotechnical systems and related models. Create a 12- to 15-slide Microsoft PowerPoint presentation with detailed speaker notes outlining how sociotechnical systems impact decision-making and innovation in modern organizations. In your presentation: Explain how leadership and management styles evolved to support and encourage a sociotechnical

Wk 1 – DIKW Model Graphic and Summary Consider the learning materials for this week. In this assignment, you will apply the data, information, knowledge, and wisdom (DIKW) model to an existing organi

Wk 1 – DIKW Model Graphic and Summary  Consider the learning materials for this week. In this assignment, you will apply the data, information, knowledge, and wisdom (DIKW) model to an existing organization. Select 1 organization with which you are familiar to use for this assignment. This could include a

Select one (1) of the following firewall architecture types: A screened-host firewallA dual-homed host firewallA screened-subnet firewallAn application-level proxy serverFor the firewall architecture

Select one (1) of the following firewall architecture types: A screened-host firewall A dual-homed host firewall A screened-subnet firewall An application-level proxy server For the firewall architecture type that you have selected, develop a paper that addresses the following: Define the specific firewall architecture type you have selected Describe how

Using the instructions from your textbook about items that should be on a good eCommerce site, use a free web creation tool such as weebly.com, to create your own eCommerce site. Come up with products

Using the instructions from your textbook about items that should be on a good eCommerce site, use a free web creation tool such as weebly.com, to create your own eCommerce site. Come up with products or services to offer on your site. Include information about those products including prices. Your

Based upon the results of a just completed IT Audit of your organization’s IT department, operations and infrastructure, it has been noted by the Auditor that there exists no current, implemented data

Based upon the results of a just completed IT Audit of your organization’s IT department, operations and infrastructure, it has been noted by the Auditor that there exists no current, implemented data classification scheme for your IT environment.  In response to the Audit Report, your management has tasked you with

You will develop and publish a PowerPoint presentation with personal voice narration were you explore information technology careers. The presentation should contain approximately 12 slides. On Each s

You will develop and publish a PowerPoint presentation with personal voice narration were you explore information technology careers. The presentation should contain approximately 12 slides. On Each slide you should have an image (graphic or picture that represents the content on the slide), voice narration, and other multimedia as appropriate. The time

The four major areas that you should consider when collecting and writing security requirements documents are: User ManagementData ManagementAccess ControlAuditingSelect one (1) of these four areas an

The four major areas that you should consider when collecting and writing security requirements documents are: User Management Data Management Access Control Auditing Select one (1) of these four areas and develop a report to management outlining and identifying the specific questions that would need to be asked and addressed

Please use your text and leverage any Internet source on the following topics: Vulnerability Facility AssessmentVulnerability Assessment Tools ReportAutomating Vulnerability AssessmentAfter reading th

Please use your text and leverage any Internet source on the following topics: Vulnerability Facility Assessment Vulnerability Assessment Tools Report Automating Vulnerability Assessment After reading the related information you have gleaned from the vast wealth of Internet resources, prepare a paper addressing the principles, functions, risks and benefits of vulnerability

Foundations Of Information Systems Management Summative Assessment: Value of Data: Analytics and Monetization As a leader who must understand the organization’s technical and business needs, you may h

Foundations Of Information Systems ManagementSummative Assessment: Value of Data: Analytics and Monetization As a leader who must understand the organization’s technical and business needs, you may help define the information systems and technologies needed to meet organizational objectives and then derive ways to digitize the organization.  The process will entail

Wk 6 – IST: Best Practices and Recommendations Success, whether organizational or individual, seldom comes strictly from individual experience and internal application. An ongoing requirement in today

Wk 6 – IST: Best Practices and Recommendations Success, whether organizational or individual, seldom comes strictly from individual experience and internal application. An ongoing requirement in today’s fast-changing global business environment is understanding what is successful for others and why, and more importantly, what was not successful and why. That

Foundations Of Information Systems Management (Summative Assessment: DIKW and Business Strategy) As a leader in your selected field, it is important to be able to organize and explain the resources av

Foundations Of Information Systems Management (Summative Assessment: DIKW and Business Strategy) As a leader in your selected field, it is important to be able to organize and explain the resources available within the organization. The data, information, knowledge, and wisdom (DIKW) model is a tool for knowledge management.  In this