Draw the query plan tree assuming there are no indexes

Assignment Help Computer Engineering

Reference no: EM133744810

Assignment: Current Event Counterfeit Goods Seizure

Consider the following tables:

students (studentsId -> name, course, dateBirth)
books (bookid -> title, yearPublication, publishingCompany)
loans (loanId -> studentId, bookId, dateLoan)

And the following query:

SELECT S.name

FROM Students S, books B, loans L
WHERE S.studentId = L.studentId
AND B.bookId = L.bookId
AND B.publishingCompany = 'O'Reilly'
AND YEAR(S.dateBirth) BETWEEN 1990 AND 2000

And assume:

There are 15,000 student records stored on 1,500 pages.
There are 100,000 work records stored on 10,000 pages.
There are 500,000 loan records stored on 25,000 pages.
There are 1,000 different publishers.

Students' birth dates range from 1980 to 2010

1. Draw the query plan tree, assuming there are no indexes and the data is not ordered by any attributes. Justify and give an example of your answer?

2. Calculate the cost of this query plan (a) and the cardinality of the result (b) Justify and exemplify your answer.

Reference no: EM133744810

Questions Cloud

Write about the theory you have studied : Write about the theory you've studied throughout the semester which is the narrative theory. Application/Example of the theory in action in everyday life.

What do you think you can do to expand medicaid expansion : Expanding your thoughts to include you as a DNP-leader, what do you think you can do to expand Medicaid expansion to the rural communities?

Create a dashboard and use at least three indicators : Create a dashboard and use at least three indicators. Your product should include a description and rationale for each indicator chosen for your dashboard.

Analyze the problem using milios framework for prevention : Analyze the problem using Milio's framework for prevention from the module 1 readings (Chapter three in your text, pp 41).

Draw the query plan tree assuming there are no indexes : Draw the query plan tree, assuming there are no indexes and the data is not ordered by any attributes. Justify and give an example of your answer?

Example of the influence of on gender differences : In many Middle Eastern countries, males are socialized and schooled to work in the public sphere, females in the private world of home and child rearing.

Balance between meeting metrics or regulatory requirements : How does clinical supervisor find balance between meeting metrics or regulatory requirements and ensuring quality of care through development of supervisees?

Concept of the sociological imagination : Describe C. Wright Mills' concept of the sociological imagination. What does the sociological imagination allow us to do?

Is crime an unavoidable aspect of society : Is crime an unavoidable aspect of society? What proactive measures can be implemented to mitigate its occurrence? Please provide a detailed explanation.

User Account

All Pages