Consider the follow relations’ schemas to answer the following question: Student (sid, name, level, address) Book(bid, title, author) BorrowedBook( sid , bid , date) Draw optimized tree for the next...

Consider the follow relations’ schemas to answer the following question:

• Student (sid, name, level, address)


• Book(bid, title, author)


• BorrowedBook(sid,bid, date)
  
  

  Draw optimized tree for the next query:

  
  
  
  
  • SELECT S.name
  
  
  • FROM Student S, Book B, BorrowedBook BB
  
  
  • WHERE S.sid = BB.sid
  
  
  • AND B.bid = BB.bid
  
  
  • AND B.author = 'Henry F. Korth'
  
  
  • AND S.level between 2 and 4