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

Activity: Discuss the importance of effective communication within systems projects. Objective: In this chapter you learned that effective communication is a critical aspect of systems projects. This

Activity: Discuss the importance of effective communication within systems projects. Objective: In this chapter you learned that effective communication is a critical aspect of systems projects. This exercise highlights the impact of effective communication on a company’s systems projects. Instructions: Research effective communication on the Project Management Institute website (  Consider the significance of communication in

A SWOT analysis categorizes an organization’s top strengths, weaknesses, opportunities, and threats into an organized list and is usually presented in a simple two-by-two grid. Tasks: From the followi

A SWOT analysis categorizes an organization’s top strengths, weaknesses, opportunities, and threats into an organized list and is usually presented in a simple two-by-two grid. Tasks: From the following list of possible corporate threats, select one (1): A disconnected, and less loyal, customer base Being leap-frogged by competitor’s technology Breach of

Information Systems for Life: Chapter 1 Activity: Discuss the Pros and Cons of “Bring Your Own Device” (BYOD) in a corporation. Objective: In this chapter you learned about the impact that the develop

Information Systems for Life: Chapter 1 Activity: Discuss the Pros and Cons of “Bring Your Own Device” (BYOD) in a corporation. Objective: In this chapter you learned about the impact that the development of mobile devices and the app ecosystem have had on systems analysts and the knowledge they have to acquire

The Impact Of Technology On Organizations Summative Assessment: Innovative Capabilities Audit Innovation is essential to an organization’s success. When evaluating an organization’s ability to mana

The Impact Of Technology On Organizations Summative Assessment: Innovative Capabilities Audit  Innovation is essential to an organization’s success. When evaluating an organization’s ability to manage technology and innovation, leaders and managers must be cognizant of (and realistic about!) the firm’s capabilities. However, measuring an organization’s capability to innovate can be challenging. The

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