University of Maine 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
• A) 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?
• B) Calculate the cost of this query plan (i) and the cardinality of the result (ii). Justify and exemplify your answer.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.