Question: Consider the following SQL Query: SELECT FNAME, DNAME FROM EMP ASN E, DEPT AS D WHERE E.DNO = D.DNUMBER AND D.DNAME =CCI AND SALARY >

Consider the following SQL Query:

SELECT FNAME, DNAME

FROM EMP ASN E, DEPT AS D

WHERE E.DNO = D.DNUMBER AND D.DNAME =’CCI’ AND SALARY > 15000;

Draw the initial query tree for the above SQL query, and then show how the query tree is optimized by applying the Heuristic Rules. 

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Initial Query Tree CCI 15000 SELECT LFNAME DNAME FROM HEMP E DEPT D WHERE LFNAME DNAME FROM LEDN... View full answer

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!

Q:

Let A1, A2, Ag be independent events so that P(A)=q, 0

Q:

As a matter of tax policy, many politicians have used the concept of depreciation as an economic stimulus. For example, the Bush tax cuts after 9/11 were responsible for Section 179 depreciation as...

Q:

What did the NASA's Challenger Shuttle case demonstrate in terms of team decision making?

Q:

Consider the following SQL query for our bank database select T.branch-name from branch T, branch S where T.assets > S.assets and S.branch-city = Brooklyn Write an efficient relational-algebra...

Q:

Consider the following SQL query: This query selects: a. The supplier name, supplier address, and supplier city of all suppliers who cannot supply any products. b. The supplier name, supplier...

Q:

Consider the following SQL query that seeks to find a list of titles of all courses taught in Spring 2017 along with the name of the instructor. select name, title from instructor natural join...

Q:

Consider the following query: The query retrieves: a. The name and number of the product with the highest ordered quantity. b. The name and number of all products that are ordered and do not exceed...

Q:

17. What is difference between Abstract class and Interface(Abstract vs Interface)? (5 Marks) 18. Find which of the following uses encapsulation? - (5Marks) a. void main(){ int a; void fun( int...

Q:

Consider the following queries: 1 . SELECT * FROM invoice WHERE customer _ id IN ( SELECT customer _ id FROM customer WHERE first _ name like ' J % ' ) ; 2 . SELECT invoice. * FROM invoice INNER JOIN...

Q:

consider the following transaction and select the option that matches when revenue is recognized. Transaction: Provided legal services to client to be collected next month. A. Deferral B. Prepayment....

Q:

On August 1, Nikee purchased 39,000 shares of its common stock @ $163 per share.On September 23, Nikee sold 25,000 of these shares at $167 per share.On December 29, Nike sold 3,000 of these shares at...

Q:

The six product life-cycle stages of a deliverable include: Question 8 options: a) concept/definition, design, and start-up b) operations, retirement, and prototype c) construct, operations, and...

Q:

Joann Crier has completed her 3-month probation period with Inner City Health Care. She is doing quite well and has demonstrated skill in accurate financial documentation. She has been asked to take...

Q:

Scenario 2 Jenna, a marketing specialist, has an employment contract that was renewed yearly over a five year period. Jenna's contract was renewed annually to align with the company's growth...

Q:

Dave was a bachelor who lived in Sydney. He was a loner and in ill health. He contacted his sister, Keren, in Oxford, England and asked her to move to Sydney to help look after him. He promised that...

Q:

The demand equation for pen per day is as under (6) D 160- 15 P Calculate (a) How many pens per day can the firm sell at a price of Rs. 10 per pen? (b) If firm wants to sell two pens per day what...

Q:

Part 1: On November 27th , the board of directors of India Star Company declared a $.50 per share dividend. The dividend is payable on December 24th to stockholders of record on December 7th . India...

Q:

Suppose that A is an m n matrix with linearly independent columns and the linear system LS(A, b) is consistent. Show that this system has a unique solution.

Q:

Explain the following terms briefly: attribute, domain, entity, relationship, entity set, relationship set, one-to-many relationship, many-to-many relationship, participation constraint, overlap...

Q:

Suppose that duplicates are handled using the approach without overflow pages discussed in Section 10.7. Describe an algorithm to search for the left-most occurrence of a data entry with search key...

Q:

Consider the instance of the Sailors relation shown in Figure 5.1. 1. Write SQL queries to compute the average rating, using AVG; the sum of the ratings, using SUM; and the number of ratings, using...

Q:

Consider the Scoot & Go Rider shown on the next page and made by the Processed Plastic Company (PPC). Suppose that PPC has received a rush order from Walmart for 8,800 units to be shipped in five...

Q:

A manager wants to assign tasks to workstations in order to achieve an hourly output rate of four units. The department uses a working time of 56 minutes per hour. a. Assign the tasks shown in the...

Q:

a. A pencil is made from a graphite rod and wooden body (plus a metal band and eraser at one end). Given the graphite rod, come up with two different ways (concepts) of manufacturing a pencil (ignore...